Spring MVC整合MaBatis

Spring MVC整合MaBatis

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

创建数据库mybatis、数据表t_user

创建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">
<!-- 读取 db.properties-->
<context:property-override location="classpath:db.properties"/>

<!-- 配置c3p0数据源 -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"/>
	
<!-- 配置SqlSessionFactory -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
	<property name="dataSource" ref="dataSource"></property>
	<property name="configLocation" value="classpath:mybatis-config.xml"></property>
</bean>
	
<!-- JDBC事务管理器 -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
	<property name="dataSource" ref="dataSource"></property>
</bean>

<!-- mybatis自动扫描包 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
	<property name="basePackage" value="com.mapper"></property>
</bean>

<!-- 启用支持annotation注解方式事务管理 -->
<tx:annotation-driven transaction-manager="transactionManager"/>

<!-- 设置默认配置方案-->
<mvc:annotation-driven/>

<!-- 使用默认的Servlet来响应静态文件 -->
<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>
   <!-- spring mvc前端控制器 -->
  <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