Mac环境下从零配置ssm框架-从零学习SSM框架（1）

悠悠 2022-05-29 13:57 200阅读 0赞

## 前言 ##

*  我的所有博客操作均有相应截图，所以只要跟着做，一定是能跑通的

ssm 框架是Spring，SpringMVC，mybaties的缩写形式，常作为数据源较为简单的web框架，本篇讲述了以IDEA为开发工具进行的ssm框架集整合，并且用mysql数据库，从无到有建立maven项目–helloword  
*如果您已经配置完成了那到这边学习怎么使用吧*  
[https://blog.csdn.net/babybabyup/article/details/79711028][https_blog.csdn.net_babybabyup_article_details_79711028]

## 学习要求： ##

1.  掌握java语言基础
2.  了解mysql数据库的使用

## 原工具： ##

1.  tomcat（环境要配置好）
2.  mysql（数据库名=test，表名=user）
3.  maven
4.  jdk
5.  IDEA

## 配置步骤 ##

### 创建maven项目 ###

*  打开IDEA
 *  创建maven新项目

![70][]  
选择maven项目webapp  
![70 1][]  
填写两个ID（这两个ID的名称会在后面的配置文件里用到，记住最好）  
![70 2][]  
一路next就好  
![这里写图片描述][70 3]

![70 4][]  
finish。创建完成后出现`[INFO]maven execution finished`  
![70 5][]  
初步创建的工作目录  
(第一次创建会很慢，要下载所有用到的jar包，以后就会快的)  
![70 6][]  
然后手动创建，最后的文件以及目录为  
![70 7][]

*  在main的java文件夹上，右键，make directory as，选择sources root
 *  在main的resources文件夹上，右键，make directory as ，选择resources root
 *  在test的java文件夹上，鼠标右键，找到make directory as，选择Test Sources root
 *  在test的resources文件夹上，鼠标右键，找到make directory as，选择Test Resources root

总的说一下要配置的文件吧，这样大家能做到心里有ACDEF数,要把以下文件中用到的路径,项目名换成自己的。

*  pom.xml
 *  web.xml
 *  applicationContext.xml
 *  generatorConfig.xml
 *  jdbc.properties
 *  generator.properties
 *  log4j.properties

### 配置（重头戏开始喽） ###

#### pom.xml ####

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>com.springmvc</groupId>
    <artifactId>helloworld</artifactId>
    <packaging>war</packaging>
    <version>1.0-SNAPSHOT</version>
    <name>helloworld Maven Webapp</name>
    <url>http://maven.apache.org</url>
    <properties>
    
    <spring.version>4.2.5.RELEASE</spring.version>
    
    <mybatis.version>3.2.4</mybatis.version>
    
    <slf4j.version>1.6.6</slf4j.version>
    <log4j.version>1.2.12</log4j.version>
    </properties>
    <dependencies>
    
    
    <dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-core</artifactId>
    <version>${spring.version}</version>
    </dependency>
    
    <dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-web</artifactId>
    <version>${spring.version}</version>
    </dependency>
    
    <dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-oxm</artifactId>
    <version>${spring.version}</version>
    </dependency>
    
    <dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-tx</artifactId>
    <version>${spring.version}</version>
    </dependency>
    
    <dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-jdbc</artifactId>
    <version>${spring.version}</version>
    </dependency>
    
    <dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-webmvc</artifactId>
    <version>${spring.version}</version>
    </dependency>
    
    <dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-aop</artifactId>
    <version>${spring.version}</version>
    </dependency>
    
    <dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-context-support</artifactId>
    <version>${spring.version}</version>
    </dependency>
    
    <dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-test</artifactId>
    <version>${spring.version}</version>
    </dependency>
    
    
    
    <dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>${mybatis.version}</version>
    </dependency>
    
    <dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis-spring</artifactId>
    <version>1.2.2</version>
    </dependency>
    
    <dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.29</version>
    </dependency>
    
    <dependency>
    <groupId>junit</groupId>
    <artifactId>junit</artifactId>
    <version>4.11</version>
    <scope>test</scope>
    </dependency>
    
    <dependency>
    <groupId>javax.servlet</groupId>
    <artifactId>jstl</artifactId>
    <version>1.2</version>
    </dependency>
    <dependency>
    <groupId>javax.servlet.jsp</groupId>
    <artifactId>jsp-api</artifactId>
    <version>2.2.1-b03</version>
    <scope>provided</scope>
    </dependency>
    
    
    <dependency>
    <groupId>javax.servlet</groupId>
    <artifactId>servlet-api</artifactId>
    <version>2.5</version>
    <scope>provided</scope>
    </dependency>
    
    <dependency>
    <groupId>com.fasterxml.jackson.core</groupId>
    <artifactId>jackson-core</artifactId>
    <version>2.7.1</version>
    </dependency>
    <dependency>
    <groupId>com.fasterxml.jackson.core</groupId>
    <artifactId>jackson-annotations</artifactId>
    <version>2.7.1</version>
    </dependency>
    <dependency>
    <groupId>com.fasterxml.jackson.core</groupId>
    <artifactId>jackson-databind</artifactId>
    <version>2.7.1</version>
    </dependency>
    <dependency>
    <groupId>net.sf.json-lib</groupId>
    <artifactId>json-lib</artifactId>
    <version>2.4</version>
    <classifier>jdk15</classifier>
    </dependency>
    
    <dependency>
    <groupId>commons-lang</groupId>
    <artifactId>commons-lang</artifactId>
    <version>2.4</version>
    </dependency>
    <dependency>
    <groupId>commons-logging</groupId>
    <artifactId>commons-logging</artifactId>
    <version>1.1</version>
    </dependency>
    <dependency>
    <groupId>commons-pool</groupId>
    <artifactId>commons-pool</artifactId>
    <version>1.5.6</version>
    </dependency>
    <dependency>
    <groupId>commons-dbcp</groupId>
    <artifactId>commons-dbcp</artifactId>
    <version>1.4</version>
    </dependency>
    <dependency>
    <groupId>commons-beanutils</groupId>
    <artifactId>commons-beanutils</artifactId>
    <version>1.8.3</version>
    </dependency>
    <dependency>
    <groupId>commons-httpclient</groupId>
    <artifactId>commons-httpclient</artifactId>
    <version>3.1</version>
    </dependency>
    <dependency>
    <groupId>commons-collections</groupId>
    <artifactId>commons-collections</artifactId>
    <version>3.1</version>
    </dependency>
    <dependency>
    <groupId>commons-codec</groupId>
    <artifactId>commons-codec</artifactId>
    <version>1.9</version>
    </dependency>
    <dependency>
    <groupId>javax.annotation</groupId>
    <artifactId>jsr250-api</artifactId>
    <version>1.0</version>
    </dependency>
    
    <dependency>
    <groupId>net.sf.ezmorph</groupId>
    <artifactId>ezmorph</artifactId>
    <version>1.0.6</version>
    </dependency>
    <dependency>
    <groupId>javax.activation</groupId>
    <artifactId>activation</artifactId>
    <version>1.1</version>
    </dependency>
    <dependency>
    <groupId>taglibs</groupId>
    <artifactId>standard</artifactId>
    <version>1.1.2</version>
    </dependency>
    
    
    <dependency>
    <groupId>log4j</groupId>
    <artifactId>log4j</artifactId>
    <version>${log4j.version}</version>
    </dependency>
    <dependency>
    <groupId>org.slf4j</groupId>
    <artifactId>slf4j-api</artifactId>
    <version>${slf4j.version}</version>
    </dependency>
    <dependency>
    <groupId>org.slf4j</groupId>
    <artifactId>slf4j-log4j12</artifactId>
    <version>${slf4j.version}</version>
    </dependency>
    
    </dependencies>
    <build>
    <finalName>helloworld</finalName>
    <plugins>
    <plugin>
    <groupId>org.mybatis.generator</groupId>
    <artifactId>mybatis-generator-maven-plugin</artifactId>
    <version>1.3.2</version>
    <configuration>
    
    <verbose>true</verbose>
    
    <overwrite>true</overwrite>
    </configuration>
    </plugin>
    </plugins>
    </build>
    
    </project>

如果显示红色报错，则点击选择update。各个jar包的作用已注释，不再赘述。

#### jdbc.properties ####

记得改为自己的密码，名称

driver=com.mysql.jdbc.Driver
    url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8
    username=root
    #下面输入自己的数据库密码
    password=*************
    #定义初始连接数
    initialSize=0
    #定义最大连接数
    maxActive=20
    #定义最大空闲
    maxIdle=20
    #定义最小空闲
    minIdle=1
    #定义最长等待时间
    maxWait=60000

#### applicationContext.xml ####

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context" xmlns:beans="http://www.springframework.org/schema/beans" xmlns:mvc="http://www.springframework.org/schema/mvc" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.3.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd" >
    
    
    <context:component-scan base-package="com.springmvc"/>
    <mvc:annotation-driven />
    
    
    <mvc:resources location="/images/" mapping="/images/**"/>
    <mvc:resources location="/css/" mapping="/css/**"/>
    <mvc:resources location="/styles/" mapping="/styles/**"/>
    <mvc:resources location="/js/" mapping="/js/**"/>
    
    
    
    <bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">
    <property name="messageConverters">
    <list>
    <ref bean="mappingJacksonHttpMessageConverter"/>
    </list>
    </property>
    </bean>
    
    <bean id="mappingJacksonHttpMessageConverter" class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter">
    <property name="supportedMediaTypes">
    <list>
    <value>application/json;charset=UTF-8</value>
    </list>
    </property>
    </bean>
    
    
    
    
    
    
    
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    <property name="viewClass" value="org.springframework.web.servlet.view.JstlView"/>
    <property name="prefix" value="/WEB-INF/views/" />
    <property name="suffix" value=".jsp" />
    </bean>
    
    
    
    
    
    
    
    
    <bean id = "propertyConfigurer" class = "org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
    <property name="locations">
    <list>
    <value>classpath:jdbc.properties</value>
    </list>
    </property>
    
    </bean>
    
    
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
    <property name="driverClassName" value="${driver}"/>
    <property name="url" value="${url}"/>
    <property name="username" value="${username}"/>
    <property name="password" value="${password}"/>
    <property name="initialSize" value="1"/>
    <property name="maxActive" value="100"/>
    <property name="maxIdle" value="5"/>
    <property name="maxWait" value="80000"/>
    </bean>
    
    
    
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    <property name="dataSource" ref="dataSource" />
    </bean>
    
    
    
    <mvc:interceptors>
    
    <bean class="org.springframework.web.servlet.i18n.LocaleChangeInterceptor" />
    </mvc:interceptors>
    
    <mvc:view-controller path="/" view-name="redirect:/" />
    
    
    </beans>

#### log4j ####

### set log levels ###
    log4j.rootLogger = INFO,D
    
    ###输出到控制台###
    log4j.logger.toConsole=debug,stdout
    log4j.appender.stdout = org.apache.log4j.ConsoleAppender
    log4j.appender.stdout.Target = System.out
    log4j.appender.stdout.layout = org.apache.log4j.PatternLayout
    
    
    log4j.appender.stdout.layout.ConversionPattern =%d{yyyy-MM-dd HH\:mm\:ss} [%5p] - %c -%F(%L) -%m%n
    
    ### 输出到日志文件 ###
    ## 其中File 可以采用绝对路径 亦可以采用相对路径 catalina.home 是tomcat目录 如果没有logs文件夹 将会报错 ##
    ## 更加倾向于将日志文件放在 tomcat的日志目录下${catalina.home}/logs/salesmanb2bError.log ##
    ## 绝对路径如：e:/salesmanb2bError.log ##
    log4j.logger.daily=INFO,D
    log4j.appender.D = org.apache.log4j.DailyRollingFileAppender
    log4j.appender.D.File = ${catalina.home}/logs/helloworld/helloworld.log
    log4j.appender.D.Append = true
    log4j.appender.D.Threshold = INFO
    log4j.appender.D.layout = org.apache.log4j.PatternLayout
    log4j.appender.D.layout.ConversionPattern =%d{yyyy-MM-dd HH\:mm\:ss} [%5p] - %c -%F(%L) -%m%n
    
    
    ##log4j.logger.org.apache.ibatis=debug,stdout
    ##log4j.logger.java.sql=debug,stdout

#### web.xml ####

<?xml version="1.0" encoding="UTF-8"?>
    <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" version="3.0">
    <display-name>helloworld</display-name>
    
    <filter>
    <filter-name>encodingFilter</filter-name>
    <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
    <init-param>
    <param-name>encoding</param-name>
    <param-value>UTF-8</param-value>
    </init-param>
    <init-param>
    <param-name>forceEncoding</param-name>
    <param-value>true</param-value>
    </init-param>
    </filter>
    <filter-mapping>
    <filter-name>encodingFilter</filter-name>
    <url-pattern>/*</url-pattern>
    </filter-mapping>
    
    
    
    <servlet>
    <servlet-name>springServlet</servlet-name>
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    
    <init-param>
    <param-name>contextConfigLocation</param-name>
    <param-value> classpath:spring/applicationContext.xml</param-value>
    </init-param>
    <load-on-startup>1</load-on-startup>
    </servlet>
    
    <servlet-mapping>
    <servlet-name>springServlet</servlet-name>
    <url-pattern>/</url-pattern>
    </servlet-mapping>
    
    
    <listener>
    <listener-class>
    org.springframework.web.context.ContextLoaderListener
    </listener-class>
    </listener>
    
    <servlet-mapping>
    <servlet-name>default</servlet-name>
    <url-pattern>*.md</url-pattern>
    </servlet-mapping>
    
    <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value> classpath:spring/applicationContext.xml</param-value>
    </context-param>
    
    <welcome-file-list>
    <welcome-file>/WEB-INF/views/index.jsp</welcome-file>
    </welcome-file-list>
    
    
    
    
    
    
    <session-config>
    <session-timeout>600</session-timeout>
    </session-config>
    </web-app>

#### tomcat ####

![70 8][]  
点击并选择`Edit Configurations...`后弹出  
![70 9][]  
点击`+`\->`tomcat`\->`local`(当然也可以选择Remote)  
![70 10][]  
选择`Development`\->`+`\->`Artifact...`  
![70 11][]  
![70 12][]  
选择`helloword:war`\->`ok`  
![70 13][]  
点击运行  
![70 14][]  
OK，配置成功！

#### Mybatise ####

##### ApplicationContext.xml #####

在spring文件里（ApplicationContext.xml）要新增SQL session的配置。代码如下：

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            
            <property name="dataSource" ref="dataSource"/>
             <property name="mapperLocations" value="classpath:sqlmap/*Mapper.xml"/>
            <property name="typeAliasesPackage" value="com.springmvc.entity" />
    
        </bean>
    
        
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            
            <property name="basePackage" value="com.springmvc.dao"/>
            
            <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
        </bean>

##### generatorConfig.xml #####

配置Mybatise-generator。编辑generatorCongig.xml

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN" "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
    <generatorConfiguration>
        
        <properties resource="generator.properties"/>
    
        <classPathEntry location="****************************mysql-connector-java-5.1.29.jar" />
        <context id="context1">
            
            <commentGenerator>
                <property name="suppressAllComments" value="true" />
                <property name="suppressDate" value="true" /> 
            </commentGenerator>
    
            <jdbcConnection driverClass="${driver}" connectionURL="${url}" userId="${username}" password="${password}" />
    
            
            <javaTypeResolver>
                
                <property name="forceBigDecimals" value="false" />
            </javaTypeResolver>
    
            <javaModelGenerator targetPackage="${modelPackage}" targetProject="${modelProject}" />
            <sqlMapGenerator targetPackage="${sqlPackage}" targetProject="${sqlProject}" />
            <javaClientGenerator targetPackage="${mapperPackage}" targetProject="${mapperProject}" type="XMLMAPPER" />
    
            
            <table schema="" tableName="${table}" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"/>
    
        </context>
    </generatorConfiguration>

要注意把以上的`classPathEntry location`换成本地的数据库连接驱动（mysql-connector-java.jar）所在位置。maven已经帮我们下载好了，只需要在左边栏的`external libraries`寻找即可。  
![70 15][]  
右键->`Copy Path`复制在`classPathEntry location`那边，  
![70 16][]

##### generator.properties #####

driver=com.mysql.jdbc.Driver
    url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8
    username=root
    password=*************
    
    #entity 包名和 java目录
    modelPackage=com.springmvc.entity
    modelProject=src/main/java
    #sqlmap包名 和resources目录
    sqlPackage=sqlmap
    sqlProject=src/main/resources
    #mapper包名和 java目录
    mapperPackage=com.springmvc.dao
    mapperProject=src/main/java
    
    table=user

这里我用到了已经创建的`test`数据库名以及`user`表。要把`username`和`password`换成自己的。  
接下来讲用`Mybatis-generator`自动生成代码.  
![70 17][]  
双击  
![70 18][]  
OK! 成功！最后的页面为  
![70 19][]

#### jniut测试 ####

##### 生成测试函数 #####

![70 20][]  
`@Repository`表明是数据库的访问组件，也可以说成DAO组件。  
![70 21][]  
![70 22][]  
在类名`UserMapper`之前，右键->`Creat Test`\->`setUp/tearDown`选择要测试的函数

##### 编辑测试函数 #####

public class UserMapperTest { 
        @Autowired
        private UserMapper userMapper;
        private ApplicationContext applicationContext;
        @Before
        public void setUp() throws Exception {
            applicationContext = new ClassPathXmlApplicationContext("classpath:spring/applicationContext.xml");
            userMapper = applicationContext.getBean(UserMapper.class);
        }
    
        @After
        public void tearDown() throws Exception {
        }
    
        @Test
        public void deleteByPrimaryKey() throws Exception {
        }
    
        @Test
        public void insert() throws Exception {
            User user = new User();
            user.setId(2);
            user.setName("TEST");
            user.setSex(1);//1 == man
            userMapper.insert(user);
        }
    
        @Test
        public void insertSelective() throws Exception {
        }
    
        @Test
        public void selectByPrimaryKey() throws Exception {
            User user;
            user = userMapper.selectByPrimaryKey(2);
            System.out.println(user.getName());
        }
    
        @Test
        public void updateByPrimaryKeySelective() throws Exception {
        }
    
        @Test
        public void updateByPrimaryKey() throws Exception {
        }
    
    }

先执行`insert()`再执行`selectByPrimaryKey()`

`insert()`的结果  
![70 23][]  
`selectByPrimaryKey()`的结果  
![70 24][]

OK，至此所有的内容全部配置完成啦！接下来就是数据库联系前台的具体操作啦！

**有任何问题记得email给我哦**

[https_blog.csdn.net_babybabyup_article_details_79711028]: https://blog.csdn.net/babybabyup/article/details/79711028
[70]: /images/20220529/9773c821524541c1a9d480e048bb66eb.png
[70 1]: /images/20220529/8a5952249e8943a2969f31ecd98f11d6.png
[70 2]: /images/20220529/2104e001fc69450dbba6f8020a57caa4.png
[70 3]: /images/20220529/a7b6019f19034e49871019cdeae60777.png
[70 4]: /images/20220529/4dfb4fa2a88a44f2b99a6e12c3991235.png
[70 5]: /images/20220529/6f472f43fdb44f73bac788757851c37c.png
[70 6]: /images/20220529/58a54916881e47c582d3267521217b7b.png
[70 7]: /images/20220529/dd58a65847564dee85129451481e5fce.png
[70 8]: /images/20220529/7762b3b418754fcdbabe983b67d7cf15.png
[70 9]: /images/20220529/6e01daf444d749b092f7d29b9fe548e0.png
[70 10]: /images/20220529/74fd81ec86944612b0169ff7ea8b8e58.png
[70 11]: /images/20220529/625b80d5dfaa4541a81cadfd9137baea.png
[70 12]: /images/20220529/549c719ac9f54f0ca2c2397190d6d5d3.png
[70 13]: /images/20220529/67692423bba94c1796f0a0aafbebc5db.png
[70 14]: /images/20220529/c2b63de25e234e6eb06894d6ba34f741.png
[70 15]: /images/20220529/fd848ddeddfe407cade625312828b97d.png
[70 16]: /images/20220529/9ba74326475b444c960dd2aed4d6abfa.png
[70 17]: /images/20220529/a8b8d349ac754e3abb95d46bd0c000fb.png
[70 18]: /images/20220529/11410252528a4ee4af12c7efcc9224cd.png
[70 19]: /images/20220529/13837e4a5761423b84f8a634a50a4cf4.png
[70 20]: /images/20220529/a953c878feb346bbbc005dc6e6adb79f.png
[70 21]: /images/20220529/0c09edd8d28f496e803a61f0ae455afc.png
[70 22]: /images/20220529/788e466a05364e9bab7a69522a6278b9.png
[70 23]: /images/20220529/755369541d244c22bf3e6263f4fd6fbf.png
[70 24]: /images/20220529/232a03278b394bc2a512b203c225fa58.png