Spring+SpringMVC+mybatis入门（环境搭建+crud）

ゝ一纸荒年。 2022-07-24 11:26 228阅读 0赞

大学毕业快一年了，在学校里做了一个android APP的项目，一直都只是熟悉android后台开发是最大的短板，工作后，公司都是自己的框架，这种开源框架基本也没时间去接触。app和后台都是基于公司的平台开发，我觉得一个人做也没有啥难度。一直在混日子，把整个app的架构分析了一遍。后来公司业务需求，我被迫PC端和android客户端都的做。真心现在啥都不是研究的很深。心累。吐槽完毕。接下来，记录我自己学习ssm框架完成crud的整个过程。

# **一、开发环境搭建** #

## 1、新建一个动态web项目 ##

![SouthEast][]

![SouthEast 1][]

![SouthEast 2][]

![SouthEast 3][]

点击完成工程就创建完毕。本文是以ssm为工程的如下：

![SouthEast 4][]

## 2、配置基于SSM的开发环境 ##

### 2,1添加springmvc和mybatis的整合需要的所有jar包 ###

![SouthEast 5][]

jar包下载将在后面提供。

### **2.2配置web.xml** ###

#### **2.2.1****加载****spring****容器** ####

如下所示是spring配置的类所在的路径:

![SouthEast 6][]

![SouthEast 7][]

<context-param>
    		<param-name>contextConfigLocation</param-name>
    		<param-value>/WEB-INF/classes/spring/applicationContext-*.xml</param-value>
    	</context-param>
    	<listener>
    	                   
    		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    	</listener>

#### 2.2.2springmvc前端控制器 ####

![SouthEast 8][]

<servlet>
    		<servlet-name>springmvc</servlet-name>
    		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    		
    		<init-param>
    			<param-name>contextConfigLocation</param-name>
    			<param-value>classpath:spring/springmvc.xml</param-value>
    		</init-param>
    	</servlet>
    
    	<servlet-mapping>
    		<servlet-name>springmvc</servlet-name>
    		
    		<url-pattern>*.action</url-pattern>
    	</servlet-mapping>

#### 2.2.3post乱码过虑器 ####

![SouthEast 9][]

<filter>
    		<filter-name>CharacterEncodingFilter</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>
    	</filter>
    	<filter-mapping>
    		<filter-name>CharacterEncodingFilter</filter-name>
    		<url-pattern>/*</url-pattern>
    	</filter-mapping>

#### **2.2.4整个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" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">
      <display-name>SSM</display-name>
      
      
    	<context-param>
    		<param-name>contextConfigLocation</param-name>
    		<param-value>/WEB-INF/classes/spring/applicationContext-*.xml</param-value>
    	</context-param>
    	<listener>
    	                   
    		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    	</listener>
    	
    	
    	<servlet>
    		<servlet-name>springmvc</servlet-name>
    		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    		
    		<init-param>
    			<param-name>contextConfigLocation</param-name>
    			<param-value>classpath:spring/springmvc.xml</param-value>
    		</init-param>
    	</servlet>
    
    	<servlet-mapping>
    		<servlet-name>springmvc</servlet-name>
    		
    	</servlet-mapping>
      
      
      
      
    	<filter>
    		<filter-name>CharacterEncodingFilter</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>
    	</filter>
    	<filter-mapping>
    		<filter-name>CharacterEncodingFilter</filter-name>
    		<url-pattern>/*</url-pattern>
    	</filter-mapping>
      
      
      
      
      
      
      
      
      
      <welcome-file-list>
        <welcome-file>index.html</welcome-file>
        <welcome-file>index.htm</welcome-file>
        <welcome-file>index.jsp</welcome-file>
        <welcome-file>default.html</welcome-file>
        <welcome-file>default.htm</welcome-file>
        <welcome-file>default.jsp</welcome-file>
      </welcome-file-list>
    </web-app>

## 2.3**创建配置文件** ##

工程下建立源文件夹

![SouthEast 10][]

创建spring相关的配置文件夹:

**首先在config文件夹下创建如下文件：**

**db.properties**

jdbc.driver=com.mysql.jdbc.Driver

jdbc.url=jdbc:mysql://localhost:3306/mybatis

jdbc.username=root

jdbc.password=mysql

**log4j.properties**

\# Global logging configuration\\uff0c\\u5efa\\u8bae\\u5f00\\u53d1\\u73af\\u5883\\u4e2d\\u8981\\u7528debug

log4j.rootLogger=DEBUG, stdout

\# Console output...

log4j.appender.stdout=org.apache.log4j.ConsoleAppender

log4j.appender.stdout.layout=org.apache.log4j.PatternLayout

log4j.appender.stdout.layout.ConversionPattern=%5p \[%t\] \- %m%n

**然后在spring文件夹下配置如下文件**

applicationContext-dao.xml
    
    
    <beans xmlns="http://www.springframework.org/schema/beans"
    	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:mvc="http://www.springframework.org/schema/mvc"
    	xmlns:context="http://www.springframework.org/schema/context"
    	xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
    	xsi:schemaLocation="http://www.springframework.org/schema/beans 
    		http://www.springframework.org/schema/beans/spring-beans-3.2.xsd 
    		http://www.springframework.org/schema/mvc 
    		http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd 
    		http://www.springframework.org/schema/context 
    		http://www.springframework.org/schema/context/spring-context-3.2.xsd 
    		http://www.springframework.org/schema/aop 
    		http://www.springframework.org/schema/aop/spring-aop-3.2.xsd 
    		http://www.springframework.org/schema/tx 
    		http://www.springframework.org/schema/tx/spring-tx-3.2.xsd ">
    
    	
    	<context:property-placeholder location="classpath:db.properties" />
    	
    
    	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
    		destroy-method="close">
    		<property name="driverClassName" value="${jdbc.driver}" />
    		<property name="url" value="${jdbc.url}" />
    		<property name="username" value="${jdbc.username}" />
    		<property name="password" value="${jdbc.password}" />
    		<property name="maxActive" value="30" />
    		<property name="maxIdle" value="5" />
    	</bean>
    	
    	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    		
    		<property name="dataSource" ref="dataSource" />
    		
    		<property name="configLocation" value="classpath:mybatis/sqlMapConfig.xml" />
    	</bean>
    	
    	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    		
    		<property name="basePackage" value="com.yqq.ssm.mapper"></property>
    		<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
    	</bean>
    
    
    
    
    </beans>

applicationContext-service.xml
    
    <beans xmlns="http://www.springframework.org/schema/beans"
    	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:mvc="http://www.springframework.org/schema/mvc"
    	xmlns:context="http://www.springframework.org/schema/context"
    	xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
    	xsi:schemaLocation="http://www.springframework.org/schema/beans 
    		http://www.springframework.org/schema/beans/spring-beans-3.2.xsd 
    		http://www.springframework.org/schema/mvc 
    		http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd 
    		http://www.springframework.org/schema/context 
    		http://www.springframework.org/schema/context/spring-context-3.2.xsd 
    		http://www.springframework.org/schema/aop 
    		http://www.springframework.org/schema/aop/spring-aop-3.2.xsd 
    		http://www.springframework.org/schema/tx 
    		http://www.springframework.org/schema/tx/spring-tx-3.2.xsd ">
    
    <bean id="itemsService" class="com.yqq.ssm.service.impl.ItemsServiceImpl"/>
    </beans>

applicationContext-transaction.xml
    
    
    
    
    <beans xmlns="http://www.springframework.org/schema/beans"
    	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:mvc="http://www.springframework.org/schema/mvc"
    	xmlns:context="http://www.springframework.org/schema/context"
    	xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
    	xsi:schemaLocation="http://www.springframework.org/schema/beans 
    		http://www.springframework.org/schema/beans/spring-beans-3.2.xsd 
    		http://www.springframework.org/schema/mvc 
    		http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd 
    		http://www.springframework.org/schema/context 
    		http://www.springframework.org/schema/context/spring-context-3.2.xsd 
    		http://www.springframework.org/schema/aop 
    		http://www.springframework.org/schema/aop/spring-aop-3.2.xsd 
    		http://www.springframework.org/schema/tx 
    		http://www.springframework.org/schema/tx/spring-tx-3.2.xsd ">
    
    
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    	
    	<property name="dataSource" ref="dataSource"/>
    </bean>
    
    
    <tx:advice id="txAdvice" transaction-manager="transactionManager">
    	<tx:attributes>
    		
    		<tx:method name="save*" propagation="REQUIRED"/>
    		<tx:method name="delete*" propagation="REQUIRED"/>
    		<tx:method name="insert*" propagation="REQUIRED"/>
    		<tx:method name="update*" propagation="REQUIRED"/>
    		<tx:method name="find*" propagation="SUPPORTS" read-only="true"/>
    		<tx:method name="get*" propagation="SUPPORTS" read-only="true"/>
    		<tx:method name="select*" propagation="SUPPORTS" read-only="true"/>
    	</tx:attributes>
    </tx:advice>
    
    <aop:config>
    	<aop:advisor advice-ref="txAdvice" pointcut="execution(* com.yqq.ssm.service.impl.*.*(..))"/>
    </aop:config>
    
    </beans>

创建mybatis相关的文件夹

sqlMapConfig.xml
    <?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE configuration
    PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
    "http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
    	
    	
    	
    	
    	<typeAliases>
    		
    		<package name="com.yqq.ssm.po"/>
    	</typeAliases>
    
    	
    
    	
    </configuration>

逆向工程生成po类和mapper接口

![SouthEast 11][]

**修改数据库连接**

![SouthEast 12][]

![SouthEast 13][]

**运行后生成的代码**

![SouthEast 14][]

**为了生成动态代理对象，servce能自动注入需要确保如下配置。**

![SouthEast 15][]

编写service层类

![SouthEast 16][]

![SouthEast 17][]

![SouthEast 18][]

Service层的方法需要注册到spring容器中

![SouthEast 19][]

# **编写控制层controller** #

![SouthEast 20][]

![SouthEast 21][]

控制层调用service层的方法。通过modeandview返回数据给视图层（视图层通过addobject key取数据）。

![SouthEast 22][]

# **视图层** #

![SouthEast 23][]

调用控制层方法：

**function** queryItems()\{

//提交form

document.itemsForm.action="$\{pageContext.request.contextPath \}/items/getItemInfo.action?id=1";

document.itemsForm.submit();

![SouthEast 24][]

http://localhost:8080/SSM/items/getItemInfo.action？id=1即可访问

至此环境搭建完成。

下面进行crud操作。

1、首先，需要建立一个test2数据库。

jdbc.driver=com.mysql.jdbc.Driver  
jdbc.url=jdbc:mysql://localhost:3306/test2  
jdbc.username=root  
jdbc.password=admin

2、dao开发

便于扩展，定义如下三个类

![Center][]

package com.yqq.ssm.po;
    
    import java.util.Date;
    
    import javax.validation.constraints.Size;
    
    import org.hibernate.validator.constraints.NotEmpty;
    
    public class Items {
    	
        private Integer id;
       
        private String name;
       
        private Float price;
    
        private String pic;
    
        private Date createtime;
    
        private String detail;
    
        public Integer getId() {
            return id;
        }
    
        public void setId(Integer id) {
            this.id = id;
        }
    
        public String getName() {
            return name;
        }
    
        public void setName(String name) {
            this.name = name == null ? null : name.trim();
        }
    
        public Float getPrice() {
            return price;
        }
    
        public void setPrice(Float price) {
            this.price = price;
        }
    
        public String getPic() {
            return pic;
        }
    
        public void setPic(String pic) {
            this.pic = pic == null ? null : pic.trim();
        }
    
        public Date getCreatetime() {
            return createtime;
        }
    
        public void setCreatetime(Date createtime) {
            this.createtime = createtime;
        }
    
        public String getDetail() {
            return detail;
        }
    
        public void setDetail(String detail) {
            this.detail = detail == null ? null : detail.trim();
        }
    }

package com.yqq.ssm.po;
    
    public class ItemsCustom extends Items {
    
    }

package com.yqq.ssm.po;
    
    public class ItemsCustomVO  {
    	private Items items;
    	private ItemsCustom itemsCustom;
    	public Items getItems() {
    		return items;
    	}
    
    	public void setItems(Items items) {
    		this.items = items;
    	}
    
    	
    
    	public ItemsCustom getItemsCustom() {
    		return itemsCustom;
    	}
    
    	public void setItemsCustom(ItemsCustom itemsCustom) {
    		this.itemsCustom = itemsCustom;
    	}
    
    
    
    	
    	
    }

编写ItemCustomMapper.xmll映射文件

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
    <mapper namespace="com.yqq.ssm.mapper.ItemCustomMapper" >
    
    <insert id="saveItems" parameterType="itemsCustomVO" >
    <selectKey keyProperty="itemsCustom.id" order="AFTER" resultType="java.lang.Integer" >
    select LAST_INSERT_ID() 
    </selectKey>
    insert into items(name,price,pic,createtime,detail) values(#{itemsCustom.name},#{itemsCustom.price},
    #{itemsCustom.pic},#{itemsCustom.createtime},#{itemsCustom.detail})
    
    
    </insert>
    
    
    
    
    <insert id="saveItemsUUID" parameterType="itemsCustomVO" >
    <selectKey keyProperty="itemsCustom.id" order="BEFORE" resultType="java.lang.String" >
    select uuid()
    </selectKey>
    insert into items(name,price,pic,createtime,detail) values(#{itemsCustom.name},#{itemsCustom.price},#{itemsCustom.pic},#{itemsCustom.createtime},#{itemsCustom.detail})
    
    
    </insert>
    
    
    <select id="getAllItemsInfos" resultType="itemsCustom">
    
    select * from items
    
    
    </select>
    
    
    
    <update id="updItems" parameterType="itemsCustomVO" >
    
    
    update items set name=#{itemsCustom.name},price=#{itemsCustom.price},pic=#{itemsCustom.pic},createtime=#{itemsCustom.createtime},
    detail=#{itemsCustom.detail}  where id=#{itemsCustom.id}
    
    
    
    
    </update>
    
    
    
    <update id="updItems2" parameterType="itemsCustomVO">
    
    update items set name=#{itemsCustom.name},price=#{itemsCustom.price},pic=#{itemsCustom.pic},createtime=#{itemsCustom.createtime},
    detail=#{itemsCustom.detail}  where id=#{itemsCustom.id}
    
    
    
    
    </update>
    
    
    <delete id="delItembyId" parameterType="int">
    
    
    delete from items where id=#{id}
    
    </delete>
    
    
    
    
    
    
    
    
    
    
    
    
    </mapper>

定义ItemCustomMapper..java接口

package com.yqq.ssm.mapper;
    
    
    
    import java.util.List;
    
    import com.yqq.ssm.po.ItemsCustom;
    import com.yqq.ssm.po.ItemsCustomVO;
    
    public interface ItemCustomMapper {
    	
    	 int saveItems(ItemsCustomVO v) throws Exception;
    	 int  saveItemsUUID(ItemsCustomVO v) throws Exception;
    	 
    
    	 List<ItemsCustom> getAllItemsInfos() throws Exception;
    	 
    	 void updItems(ItemsCustomVO v)throws Exception;
    	 
    	 void delItembyId(int v)throws Exception;
    
    }

编写service层代码

定义service接口，如下：

![Center 1][]

注册服务给controller使用：

![Center 2][]

控制层：

![Center 3][]

整个学习项目访问的地址：http://localhost:8080/SSM/items/getAllItemsInfos.action

代码下载地址：http://download.csdn.net/detail/u014600432/9527779

[SouthEast]: /images/20220722/1ad0267d22a64b7db4f022fafd9063a3.png
[SouthEast 1]: /images/20220722/af84c18fabe54f8b96f48fd7ae8c2a98.png
[SouthEast 2]: /images/20220722/ec4838894f074721b1399cbc53f681e0.png
[SouthEast 3]: /images/20220722/7b6db568d4ba46dcacc90c1ecb2cbe43.png
[SouthEast 4]: /images/20220722/734e211140c14971a16cf1afa28147f2.png
[SouthEast 5]: /images/20220722/cc8282fe5d9c41019b64fad0ec5fea87.png
[SouthEast 6]: /images/20220722/944df1c153dd4bdb8acc5a412b3cb5b8.png
[SouthEast 7]: /images/20220722/6ef600ec8dad4b3092e6469d39e75609.png
[SouthEast 8]: /images/20220722/80f7ced59b54400ea05df257cc1bccb0.png
[SouthEast 9]: /images/20220722/545ba7864a3241eca69dd73e89690b6d.png
[SouthEast 10]: /images/20220722/baeebc402609411bb6735d55b7cc8595.png
[SouthEast 11]: /images/20220722/ba654d4f960f4a99b3ce837eeba96444.png
[SouthEast 12]: /images/20220722/94f54c7b6ee34968a37e790b2b427337.png
[SouthEast 13]: /images/20220722/3edd41eb008b4d32ab8fa4cd41de32b8.png
[SouthEast 14]: /images/20220722/36bf6cbdc32c415e81dd6ddb69ca4f70.png
[SouthEast 15]: /images/20220722/b06d0be7bd244a6c94b43f606e555a33.png
[SouthEast 16]: /images/20220722/da86f7136dc14af9937d217f3a9d6d43.png
[SouthEast 17]: /images/20220722/6abc714b61ad46818580a758c553ca36.png
[SouthEast 18]: /images/20220722/3e8429032cc642a7a5fcf75a7f37ece9.png
[SouthEast 19]: /images/20220722/58dab5e73a6a436cac089e92cd41b1e4.png
[SouthEast 20]: /images/20220722/b0b2655b78fd43c5bc7f383172013260.png
[SouthEast 21]: /images/20220722/04178d10f55d456395ad5fbfc4eb26b3.png
[SouthEast 22]: /images/20220722/35b0a76f6ad1461e98e4d90c2364061f.png
[SouthEast 23]: /images/20220722/368852494b3643938e2a5fb51acdccc1.png
[SouthEast 24]: /images/20220722/003f999b29574772a729a10210fa1c32.png
[Center]: /images/20220722/d85bcf01561249a6ac153c55bd0c53ad.png
[Center 1]: /images/20220722/befd64b3b3114964a984dbd10cae5410.png
[Center 2]: /images/20220722/448558fbc9ad4033ba07a403235bc871.png
[Center 3]: /images/20220722/6f45188ee6a04a298aae090e587a7911.png