Mybatis3+Spring4+SpringMVC4 整合，新手练手

比眉伴天荒 2022-05-20 06:18 175阅读 0赞

首先在整合这个框架的时候，想想其一般的步骤是怎样的，先有个步骤之后，不至于在后面的搞混了，这样在整合的时候也比较清晰些。

然后我们就细细的一步一步来整合。

1  创建一个Web项目。

2  导入Mybatis3、Spring4、SpringMVC4、连接数据库（我使用的数据库是mysql）的jar包。spring-websocket-4.2.0.RELEASE.jar

我所用的包：

![70][]

3  创建Mybatis3、Spring4、SpringMVC4、连接数据库的配置文件。

![70 1][]

4  配置web.xml

<?xml version="1.0" encoding="UTF-8"?>
     2 <web-app version="2.5" 
     3     xmlns="http://java.sun.com/xml/ns/javaee" 
     4     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
     5     xsi:schemaLocation="http://java.sun.com/xml/ns/javaee 
     6     http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
     7     
     8     
     9     <context-param>
    10         <param-name>contextConfigLocation</param-name>
    11         <param-value>
    12         /WEB-INF/classes/applicationContext.xml,
    13         
    14         </param-value>
    15     </context-param> 
    16     
    17     
    18     
    19     <context-param>
    20         <param-name>log4jConfigLocation</param-name>
    21         <param-value>/WEB-INF/log4j.xml</param-value>
    22     </context-param>
    23     
    24     <context-param>
    25         <param-name>log4jRefreshInterval</param-name>
    26         <param-value>60000</param-value>
    27     </context-param>
    28     
    29     
    30     <context-param>
    31         <param-name>webAppRootKey</param-name>
    32         <param-value>ssm.root</param-value>
    33     </context-param>
    34     
    35     
    36     <servlet-mapping>
    37         <servlet-name>default</servlet-name>
    38         <url-pattern>/static/*</url-pattern>
    39     </servlet-mapping>
    40     
    41     
    42     
    43     <servlet>
    44         <servlet-name>mvc</servlet-name>
    45         <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    46          
    48     <init-param>
    49        <param-name>contextConfigLocation</param-name>
    50        <param-value>/WEB-INF/classes/mvc-servlet.xml</param-value>
    51     </init-param>
    52     </servlet>
    53     <servlet-mapping>
    54         <servlet-name>mvc</servlet-name>
    55         <url-pattern>/</url-pattern>
    56     </servlet-mapping>
    57     
    58     
    59     
    60     <filter>
    61         <filter-name>encodingFilter</filter-name>
    62         <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
    63         <init-param>
    64             <param-name>encoding</param-name>
    65             <param-value>UTF-8</param-value>
    66         </init-param>
    67         
    68         <init-param>
    69             <param-name>forceEncoding</param-name>
    70             <param-value>true</param-value>
    71         </init-param>
    72     </filter>
    73     <filter-mapping>
    74         <filter-name>encodingFilter</filter-name>
    75         <url-pattern>/*</url-pattern>
    76     </filter-mapping>
    77     
    78     
    79     <filter>
    80         <filter-name>loginFilter</filter-name>
    81         <filter-class>com.cy.ssm.filter.LoginFilter</filter-class>
    82     </filter>
    83     <filter-mapping>
    84         <filter-name>loginFilter</filter-name>
    85         <url-pattern>/*</url-pattern>
    86     </filter-mapping>
    87     
    88     <listener>
    89         <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    90     </listener>
    91     
    92     <listener>
    93         <listener-class>org.springframework.web.util.Log4jConfigListener</listener-class>
    94     </listener>
    95     
    96   <welcome-file-list>
    97     <welcome-file>index.jsp</welcome-file>
    98   </welcome-file-list>
    99 </web-app>

5 datasource.properties 连接数据库

1 jdbc.driver=com.mysql.jdbc.Driver
    2 jdbc.url=jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=UTF-8
    3 jdbc.username=root
    4 jdbc.password=root

6 mybatis.cfg.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>
        
    </configuration>

7  mvc-servlet.xml

![复制代码][copycode.gif]

8 applicationContext.xml

![复制代码][copycode.gif]

1 <?xml version="1.0" encoding="UTF-8"?>
     2 <beans xmlns="http://www.springframework.org/schema/beans"
     3     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
     4     xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
     5     xsi:schemaLocation="http://www.springframework.org/schema/beans
     6     http://www.springframework.org/schema/beans/spring-beans-3.0.xsd 
     7     http://www.springframework.org/schema/aop 
     8     http://www.springframework.org/schema/aop/spring-aop-3.0.xsd 
     9     http://www.springframework.org/schema/tx
    10     http://www.springframework.org/schema/tx/spring-tx-3.1.xsd
    11     http://www.springframework.org/schema/context
    12     http://www.springframework.org/schema/context/spring-context-4.2.xsd">
    13     
    14     
    15      
    16      <context:component-scan base-package="com.cy.ssm">
    17        
    18          <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    19      </context:component-scan>
    20     
    21     
    22     <aop:aspectj-autoproxy/>
    23     
    24     
    25     <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
    26         <property name="locations">
    27             <value>classpath:datasource.properties</value>
    28         </property>
    29     </bean>
    30     
    31     
    32     <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    33         <property name="driverClassName" value="${jdbc.driver}"></property>
    34         <property name="url" value="${jdbc.url}"></property>
    35         <property name="username" value="${jdbc.username}"></property>
    36         <property name="password" value="${jdbc.password}"></property>
    37     </bean>
    38     
    39     
    40     
    41     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    42         <property name="dataSource" ref="dataSource"></property>
    43         
    44         <property name="configLocation" value="classpath:mybatis.cfg.xml"></property>
    45         
    46         <property name="typeAliasesPackage" value="com.cy.ssm.beans"></property>
    47     </bean>
    48     
    49     
    50     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    51         <property name="basePackage" value="com.cy.ssm.mapper"></property>
    52     </bean>
    53     
    54     
    55     <bean id="txManager"
    56         class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    57         <property name="dataSource" ref="dataSource"></property>
    58     </bean>
    59     
    60     
    61     <tx:advice id="txAdvice" transaction-manager="txManager">
    62         <tx:attributes>
    63             <tx:method name="delete*" propagation="REQUIRED" read-only="false"
    64                 rollback-for="java.lang.Exception" />
    65             <tx:method name="save*" propagation="REQUIRED" read-only="false"
    66                 rollback-for="java.lang.Exception" />
    67             <tx:method name="insert*" propagation="REQUIRED" read-only="false"
    68                 rollback-for="java.lang.Exception" />
    69             <tx:method name="update*" propagation="REQUIRED" read-only="false"
    70                 rollback-for="java.lang.Exception" />
    71             <tx:method name="load*" propagation="SUPPORTS" read-only="true"/>
    72             <tx:method name="find*" propagation="SUPPORTS" read-only="true"/>
    73             <tx:method name="search*" propagation="SUPPORTS" read-only="true"/>
    74             <tx:method name="select*" propagation="SUPPORTS" read-only="true"/>
    75             <tx:method name="get*" propagation="SUPPORTS" read-only="true"/>
    76         </tx:attributes>
    77     </tx:advice>
    78     
    79     <aop:config>
    80         
    81         <aop:pointcut id="serviceMethods" expression="execution(* com.cy.ssm.service.impl.*ServiceImpl.*(..))" />
    82         <aop:advisor advice-ref="txAdvice" pointcut-ref="serviceMethods" />
    83     </aop:config>
    84     
    85 </beans>

9  配置文件都差不多配置好了，接下来就写个测试的。

UserMapper.java

![ExpandedBlockStart.gif][]

![复制代码][copycode.gif]

1 package com.cy.ssm.mapper;
      2 
      3 import java.util.List;
      4 import java.util.Map;
      5 
      6 
      7 import org.apache.ibatis.annotations.Delete;
      8 import org.apache.ibatis.annotations.Insert;
      9 import org.apache.ibatis.annotations.Options;
     10 import org.apache.ibatis.annotations.Param;
     11 import org.apache.ibatis.annotations.Result;
     12 import org.apache.ibatis.annotations.ResultMap;
     13 import org.apache.ibatis.annotations.Results;
     14 import org.apache.ibatis.annotations.Select;
     15 import org.apache.ibatis.annotations.Update;
     16 
     17 import com.cy.ssm.beans.UserBean;
     18 
     19 
     20 public interface UserMapper {
     21     
     22     
     23     /**
     24      * 登录
     25      * @param userName
     26      * @param password
     27      * @return
     28      * @throws Exception
     29      */
     30     @Select("select * from t_user where username=#{un} and password=#{pw}")
     31     @Results({
     32         
     33         @Result(id=true,property="id",column="id",javaType=Integer.class),
     34         @Result(property="username",column="username",javaType=String.class),
     35         @Result(property="password",column="password",javaType=String.class),
     36         @Result(property="account",column="account",javaType=Double.class)
     37     })
     38     public UserBean login(@Param("un")String username,@Param("pw")String password);
     39     /**
     40      * 新增用戶
     41      * @param user
     42      * @return
     43      * @throws Exception
     44      */
     45     @Insert("insert into t_user value (null,user.username,user.password,user.account)")
     46     @Options(useGeneratedKeys=true,keyProperty="user.id")
     47     public int insertUser(@Param("user")UserBean user) throws Exception;
     48     
     49     
     50     /**
     51      * 修改用戶
     52      * @param user
     53      * @param id
     54      * @return
     55      * @throws Exception
     56      */
     57     @Update(" update t_user set username=#{u.username},password=#{u.password},account=#{u.account} where id=#{id}")
     58     public int updateUser (@Param("u")UserBean user,@Param("id")int id) throws Exception;
     59     
     60      /**
     61       * 刪除用戶
     62       * @param id
     63       * @return
     64       * @throws Exception
     65       */
     66     @Delete(" delete from t_user where id=#{id}  ")
     67     public int deleteUser(int id) throws Exception;
     68     
     69     
     70     /**
     71      * 根据id查询用户信息
     72      * @param id
     73      * @return
     74      * @throws Exception
     75      */
     76     
     77     @Select(" select * from t_user where id=#{id}")
     78     @Results({
     79         
     80         @Result(id=true,property="id",column="id",javaType=Integer.class),
     81         @Result(property="username",column="username",javaType=String.class),
     82         @Result(property="password",column="password",javaType=String.class),
     83         @Result(property="account",column="account",javaType=Double.class)
     84     })
     85     public UserBean selectUserById(int id) throws Exception;
     86      /**
     87       * 查询所有的用户信息
     88       * @return
     89       * @throws Exception
     90       */
     91     
     92     @Select(" select * from t_user")
     93     @ResultMap("userMap")
     94     public List<UserBean> selectAllUser() throws Exception;
     95     
     96     
     97     /**
     98      * 批量增加
     99      * @param user
    100      * @return
    101      * @throws Exception
    102      */
    103    public int batchInsertUser(@Param("users")List<UserBean> user) throws Exception;
    104    
    105    /**
    106     * 批量删除
    107     * @param list
    108     * @return
    109     * @throws Exception
    110     */
    111    public int batchDeleteUser(@Param("list")List<Integer> list) throws Exception;
    112    
    113    
    114    /**
    115     * 分页查询数据
    116     * @param parma
    117     * @return
    118     * @throws Exception
    119     */
    120    public List<UserBean> pagerUser(Map<String, Object> parmas) throws Exception;
    121    
    122    /**
    123     * 
    124     * 分页统计数据
    125     * @param parma
    126     * @return
    127     * @throws Exception
    128     */
    129     public int countUser(Map<String, Object> parmas) throws Exception;
    130     
    131   
    132     
    133     
    134 }

UserMapper.xml

![ExpandedBlockStart.gif][]

![复制代码][copycode.gif]

1 <?xml version="1.0" encoding="UTF-8"?>
     2 <!DOCTYPE mapper PUBLIC "-//mybatis.org/DTD Mapper 3.0" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
     3 <mapper namespace="com.cy.ssm.mapper.UserMapper">
     4 
     5    <resultMap id="userMap" type="UserBean">
     6         <id property="id" column="id" javaType="java.lang.Integer"></id>
     7         <result property="username" column="username" javaType="java.lang.String"></result>
     8         <result property="password" column="password" javaType="java.lang.String"></result>
     9         <result property="account" column="account" javaType="java.lang.Double"></result>
    10     </resultMap>
    11     
    12     
    13     
    14     <insert id="batchInsertUser" parameterType="java.util.List">
    15        insert into t_user values 
    16         <foreach collection="users" item="users" separator=",">
    17          (null,#{users.username},#{users.password},#{users.account})
    18         </foreach>
    19     </insert>
    20     
    21     
    22     <delete id="batchDeleteUser">
    23        delete from t_user where id in (
    24          <foreach collection="list" item="list" separator=",">
    25           #{id}
    26          </foreach>
    27        )
    28     </delete>
    29     
    30     
    31     
    32     
    33     
    34     
    37     <select id="pagerUser" parameterType="java.util.Map" resultMap="userMap">
    38       select * from t_user where 1=1
    39       <if test="username!=null">
    40        and username like '%${username}%'
    41       </if>
    42        limit ${index},${pageSize} 
    43     </select>
    44     
    45     <select id="countUser" parameterType="java.util.Map" resultType="int">
    46         select count(*) from t_user where 1=1 
    47         <if test="username != null">
    48             and username like '%${username}%'    
    49         </if>
    50     </select>
    51         
    52 </mapper>

ILoginService.java

![ExpandedBlockStart.gif][]

![复制代码][copycode.gif]

1 package com.cy.ssm.service;
     2 
     3 
     4 import com.cy.ssm.beans.UserBean;
     5 
     6 public interface ILoginService {
     7 
     8     public UserBean Login(String username,String password);
     9     
    10     
    11 }

LoginServiceImpl.java

![ExpandedBlockStart.gif][]

![复制代码][copycode.gif]

1 package com.cy.ssm.service.impl;
     2 
     3 import javax.annotation.Resource;
     4 
     5 import org.springframework.stereotype.Service;
     6 
     7 import com.cy.ssm.mapper.UserMapper;
     8 import com.cy.ssm.beans.UserBean;
     9 import com.cy.ssm.service.ILoginService;
    10 @Service
    11 public class LoginServiceImpl implements ILoginService{
    12     
    13     @Resource
    14     private UserMapper um;
    15 
    16 
    17     @Override
    18     public UserBean Login(String username, String password) {
    19         return um.login(username, password);
    20     }
    21 
    22 }

LoginController .java

![复制代码][copycode.gif]

1 package com.cy.ssm.controller;
     2 
     3 
     4 import javax.annotation.Resource;
     5 import javax.servlet.http.HttpServletRequest;
     6 
     7 import org.apache.log4j.Logger;
     8 import org.springframework.stereotype.Controller;
     9 import org.springframework.web.bind.annotation.RequestMapping;
    10 import org.springframework.web.servlet.ModelAndView;
    11 
    12 import com.cy.ssm.beans.UserBean;
    13 import com.cy.ssm.service.ILoginService;
    14 
    15 
    16 
    17 @Controller
    18 public class LoginController {
    19     private Logger log = Logger.getLogger(this.getClass());
    20     
    21     @Resource
    22     private ILoginService loginServiceImpl;
    23     
    24     @RequestMapping("/login")
    25     public ModelAndView login(HttpServletRequest req,UserBean user){
    26         log.info(user);
    27         
    28         ModelAndView mv = new ModelAndView();
    29         UserBean u=loginServiceImpl.Login(user.getUsername(), user.getPassword());
    30     
    31         if(u != null){
    32                     
    33             req.getSession().setAttribute("user", u);
    34             mv.addObject("password", u.getPassword());
    35             System.out.println(u.getPassword());
    36         }
    37         mv.setViewName("index");
    38         return mv;
    39     }
    40     
    41     
    42     
    43 }

![复制代码][copycode.gif]

jsp页面；

1  <body>
    2     <form action="<%=basePath%>login" method="post">
    3         <input type="text" name="username"/>
    4         <input type="text" name="password"/>
    5         <input type="submit" value="提交"/>
    6     </form>

index.jsp

<body>  
   $\{password \}  
</body>

测试：

![70 2][]

整体大概就这样了！

![70 3][]

我把整个文件上传到：[http://pan.baidu.com/s/1hrB1guo][http_pan.baidu.com_s_1hrB1guo][  
][Link 1]

继续我的作业了！

每件事都需要坚持！

原文地址：https://www.cnblogs.com/hellokitty1/p/5230392.html

[70]: /images/20220520/6fee49f08b4946479276a6e4ef4bafa7.png
[70 1]: /images/20220520/7e569de9f12b4dacafe4786438c0e4f6.png
[copycode.gif]: /images/20220520/e1117e8eb9f34714ae105d297a5f784e.png
[ExpandedBlockStart.gif]: /images/20220520/be35bb0318dd400d83d8108a4b024ebe.png
[70 2]: /images/20220520/8468a4780c6240a9bcdfd777e52abb1c.png
[70 3]: /images/20220520/a1dac2fcdf10486a914abb4e5d7451e2.png
[http_pan.baidu.com_s_1hrB1guo]: http://pan.baidu.com/s/1hrB1guo
[Link 1]: http://pan.baidu.com/disk/home?fr=ibaidu#list/path=%2F