Spring MVC整合MaBatis

曾经终败给现在 2022-05-15 12:17 243阅读 0赞

**Spring MVC整合MaBatis**

**项目结构(导入spring、mybatis相关jar包)**

![70][]

**创建数据库mybatis、数据表t\_user**

![70 1][]

**创建User**

package com.po;
    /**
     * User实体类
     * @author Administrator
     *
     */
    public class User {
    	private Integer userId;
    	private String userName;
    	private String passWord;
    	public Integer getUserId() {
    		return userId;
    	}
    	//省略get、set方法
    }

**创建UserService**

package com.service;
    import com.po.User;
    /**
     * User服务层接口
     * @author Administrator
     *
     */
    public interface UserService {
    	User login(User user);
    }

**创建UserServiceImpl**

package com.service;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    import org.springframework.transaction.annotation.Isolation;
    import org.springframework.transaction.annotation.Propagation;
    import org.springframework.transaction.annotation.Transactional;
    
    import com.mapper.UserMapper;
    import com.po.User;
    /**
     * User服务层接口实现类
     * @author Administrator
     *
     */
    @Transactional(propagation=Propagation.REQUIRED,isolation=Isolation.DEFAULT)
    @Service("userService")
    public class UserServiceImpl implements UserService{
    	/**
    	 * 自动注入UserMapper
    	 */
    	@Autowired
    	private UserMapper userMapper;
    	/**
    	 * UserService接口login方法实现
    	 */
    	@Transactional(readOnly=true)
    	@Override
    	public User login(User user) {
    		return userMapper.login(user);
    	}
    }

**创建UserMapper**

package com.mapper;
    import com.po.User;
    /**
     * UserMapper接口
     * @author Administrator
     *
     */
    public interface UserMapper {
    	User login(User user);
    }

**创建UserMapper.xml**

<?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.mapper.UserMapper">
    	<select id="login" parameterType="com.po.User" resultType="com.po.User">
    		select * from t_user 
    		where userName=#{userName} 
    		and passWord=#{passWord}
    	</select>
    </mapper>

**创建UserController**

package com.controller;
    import javax.servlet.http.HttpSession;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.beans.factory.annotation.Qualifier;
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.ModelAttribute;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.servlet.ModelAndView;
    import com.po.User;
    import com.service.UserService;
    /**
     * 处理用户请求控制器
     * @author Administrator
     *
     */
    @Controller
    public class UserController {
    	@Autowired
    	@Qualifier("userService")
    	private UserService userService;
    	@RequestMapping("/loginForm")
    	public String loginForm() {
    		return "login";
    	}
    	@RequestMapping("/userLogin")
    	public ModelAndView userLogin(@ModelAttribute User user,ModelAndView mv,HttpSession session) {
    		User us=userService.login(user);
    		if(us!=null) {
    			session.setAttribute("user", us);
    			mv.setViewName("success");
    		}else {
    			mv.addObject("msg","用户名和密码不正确");
    			mv.setViewName("login");
    		}
    		return mv;
    	}
    }

**创建db.properties**

dataSource.driverClass=com.mysql.jdbc.Driver
    dataSource.jdbcUrl=jdbc:mysql://127.0.0.1:3306/mybatis
    dataSource.user=root
    dataSource.password=root
    dataSource.maxPoolSize=20
    dataSource.maxIdleTime = 1000
    dataSource.minPoolSize=6
    dataSource.initialPoolSize=5

**创建mybatis-config.xml(mybatis-config.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>

**创建springmvc-config.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:c="http://www.springframework.org/schema/c"
        xmlns:context="http://www.springframework.org/schema/context"
        xmlns:mvc="http://www.springframework.org/schema/mvc"
        xmlns:tx="http://www.springframework.org/schema/tx"
        xsi:schemaLocation="http://www.springframework.org/schema/beans 
        					http://www.springframework.org/schema/beans/spring-beans.xsd
            				http://www.springframework.org/schema/context
            				http://www.springframework.org/schema/context/spring-context-4.1.xsd
            				http://www.springframework.org/schema/mvc
            				http://www.springframework.org/schema/mvc/spring-mvc-4.1.xsd
            				http://www.springframework.org/schema/tx  
            				http://www.springframework.org/schema/tx/spring-tx.xsd">
    
    <context:property-override location="classpath:db.properties"/>
    
    
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"/>
    	
    
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    	<property name="dataSource" ref="dataSource"></property>
    	<property name="configLocation" value="classpath:mybatis-config.xml"></property>
    </bean>
    	
    
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    	<property name="dataSource" ref="dataSource"></property>
    </bean>
    
    
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    	<property name="basePackage" value="com.mapper"></property>
    </bean>
    
    
    <tx:annotation-driven transaction-manager="transactionManager"/>
    
    
    <mvc:annotation-driven/>
    
    
    <mvc:default-servlet-handler/>
    
    <context:component-scan base-package="com.*" />
    
    
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    	<property name="prefix" value="/WEB-INF/jsp/"></property>
    	<property name="suffix" value=".jsp" />
    </bean>
    </beans>

**创建web.xml**

<?xml version="1.0" encoding="UTF-8"?>
    <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd" id="WebApp_ID" version="4.0">
      <display-name>HR</display-name>
      <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>
       
      <servlet>
      	<servlet-name>DispatcherServlet</servlet-name>
      	<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
      	<init-param>
      		<param-name>contextConfigLocation</param-name>
      		<param-value>Classpath:springmvc-config.xml</param-value>
      	</init-param>
      	<load-on-startup>1</load-on-startup>
      </servlet>
      <servlet-mapping>
      	<servlet-name>DispatcherServlet</servlet-name>
      	<url-pattern>/</url-pattern>
      </servlet-mapping>
    </web-app>

**创建login.jsp**

<form action="userLogin" method="post">
    		<font color="red">${requestScope.msg }</font>
    		<table>
    			<tr>
    				<td>用户名：</td>
    				<td><input type="text" name="userName"></td>
    			</tr>
    			<tr>
    				<td>密码：</td>
    				<td><input type="password" name="passWord"></td>
    			</tr>
    			<tr>
    				<td></td>
    				<td><input type="submit" value="登录"></td>
    			</tr>
    		</table>
    	</form>

**创建success.jsp**

<body>
    	<p>欢迎[${sessionScope.user.userName }]访问</p>
    	
    </body>

**启动Tomcat访问:[http://localhost:8080/ssm/loginForm][http_localhost_8080_ssm_loginForm]**

![70 2][]

![70 3][]

[70]: /images/20220515/8caa0a7da053467ca16ed69b1cd42a9d.png
[70 1]: /images/20220515/9caf4cab7da44d4e81fff73f4a829a2f.png
[http_localhost_8080_ssm_loginForm]: http://localhost:8080/ssm/loginForm
[70 2]: /images/20220515/6aad568c907c455db5c55e29cb416f62.png
[70 3]: /images/20220515/1e50a32d61254c92863d921d60a59585.png