mybatis+springmvc整合

项目中一般不会单独使用某一个框架，而是使用几个框架整合。

mybatis+springmvc整合后程序运行顺序:

用户请求界面，然后会根据配置文件向后台发出请求，找到对应的控制器，控制器调用service，service调用dao来与数据库进行交互，dao会寻找对应Mapper，XXXMapper.xml里面写的是sql语句，这时就可以与数据库交互，并将结果一步步返回给用户界面。（说的不专业，大概是这个意思）

解决Spring配置文件xml没有类提示：
https://blog.csdn.net/a_helloword/article/details/80557692

 

这里记录一下mybatis+springmvc的整合步骤：

一、创建一个web项目。

二、使用myeclipse给该项目添加spring框架，这里使用的是spring4.1。

三、添加mybatis以及mybatis和spring整合的jar包：

        

四、编写配置文件：

        配置文件：

       web.xml：

 

<!-- 配置字符编码集过滤器 -->
  <filter>
     <filter-name>EncodingFilter</filter-name>
     <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
     <init-param>
        <param-name>forceEncoding</param-name>
        <param-value>true</param-value>
     </init-param>
     <init-param>
        <param-name>encoding</param-name>
        <param-value>utf-8</param-value>
     </init-param>
  </filter>
  <filter-mapping>
     <filter-name>EncodingFilter</filter-name>
     <url-pattern>/*</url-pattern>
  </filter-mapping>
  
  <!-- 配置监听器，读取spring配置文件 -->
  <listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>
  <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classpath:applicationContext.xml</param-value>
  </context-param>
  
  <!-- 配置中央控制器，读取springmvc配置文件 -->
  <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:springmvc.xml</param-value>
    </init-param>
    <load-on-startup>1</load-on-startup>
  </servlet>
  <servlet-mapping>
    <servlet-name>springmvc</servlet-name>
    <url-pattern>*.do</url-pattern>
  </servlet-mapping>

 

 

 

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:p="http://www.springframework.org/schema/p"
	xmlns:aop="http://www.springframework.org/schema/aop"
	xmlns:tx="http://www.springframework.org/schema/tx"
	xmlns:context="http://www.springframework.org/schema/context"
	xsi:schemaLocation="http://www.springframework.org/schema/beans 
	http://www.springframework.org/schema/beans/spring-beans-4.1.xsd
	http://www.springframework.org/schema/aop 
	http://www.springframework.org/schema/aop/spring-aop-4.1.xsd
	http://www.springframework.org/schema/tx 
	http://www.springframework.org/schema/tx/spring-tx-4.1.xsd
	http://www.springframework.org/schema/context 
	http://www.springframework.org/schema/context/spring-context-4.1.xsd">

	<!-- 启用spring注解 -->
	<context:annotation-config></context:annotation-config>
	<context:component-scan base-package="com.mfc"></context:component-scan>
	
	<!-- 一、配置数据源 -->
	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
		<property name="driverClassName">
		   <value>com.mysql.jdbc.Driver</value>
		</property>
		<property name="url" value="jdbc:mysql://127.0.0.1:3306/mybatis"></property>
		<property name="username" value="root"></property>
		<property name="password" value="root"></property>
	</bean>
	
	<!--二、 配置本地会话工厂 -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<!--注入数据源  -->
		<property name="dataSource" ref="dataSource"></property>
		<!-- 配置mybatis自身属性 -->
		<property name="typeAliasesPackage" value="com.mfc.entity"></property>
		<property name="mapperLocations" value="classpath:com/mfc/mapper/*Mapper.xml"></property>
		<property name="configLocation" value="classpath:conf.xml"></property>
	</bean>
	
	<!--三、配置sqlsession模板  -->
	<bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">
		<constructor-arg index="0" ref="sqlSessionFactory"></constructor-arg>
	</bean>
	
	<!-- 使用aop配置事务 -->
	<bean id="dataSourceTransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource" ref="dataSource"></property>
	</bean>
	<tx:advice id="txAdvice" transaction-manager="dataSourceTransactionManager">
		<tx:attributes>
			<tx:method name="query*" propagation="SUPPORTS" read-only="false" isolation="DEFAULT"/>
			<tx:method name="select*" propagation="SUPPORTS" read-only="true" isolation="DEFAULT"/>
	   		<tx:method name="get*" propagation="SUPPORTS" read-only="true" isolation="DEFAULT"/>
	     	<tx:method name="find*" propagation="SUPPORTS" read-only="true" isolation="DEFAULT"/>
	   		<tx:method name="*"/>
		</tx:attributes>
	</tx:advice>
	
	<aop:config>
	   <aop:pointcut expression="execution(* com.sc.service..*.*(..))" id="service"/>
	   <aop:advisor advice-ref="txAdvice" pointcut-ref="service"/>
	</aop:config>
</beans>

springmvc.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:p="http://www.springframework.org/schema/p"
	xmlns:aop="http://www.springframework.org/schema/aop"
	xmlns:tx="http://www.springframework.org/schema/tx"
	xmlns:mvc="http://www.springframework.org/schema/mvc"
	xmlns:context="http://www.springframework.org/schema/context"
	xsi:schemaLocation="http://www.springframework.org/schema/beans 
	http://www.springframework.org/schema/beans/spring-beans-4.1.xsd
	http://www.springframework.org/schema/aop 
	http://www.springframework.org/schema/aop/spring-aop-4.1.xsd
	http://www.springframework.org/schema/tx 
	http://www.springframework.org/schema/tx/spring-tx-4.1.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">

	<!-- 启用spring注解 -->
	<context:annotation-config></context:annotation-config>
	<context:component-scan base-package="com.mfc.ctrl"></context:component-scan>
	
	<!-- 启用springmvc注解 -->
	<mvc:annotation-driven></mvc:annotation-driven>
	
	<!-- 配置试图解析器 -->
	<bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<property name="viewClass" value="org.springframework.web.servlet.view.JstlView"></property>
		<property name="prefix" value="/WEB-INF/"></property>
		<property name="suffix" value=".jsp"></property>
	</bean>
	
	<!-- 配置拦截器 -->
	<mvc:interceptors>
		<mvc:interceptor>
			<mvc:mapping path="/login/**"/>
			<mvc:exclude-mapping path="/login/userLogin.do"/>
			<bean class="com.mfc.interceptors.LoginInterceptor"></bean>
		</mvc:interceptor>
	</mvc:interceptors>
	
	<!-- 配置文件上传解析器 -->
    <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
       <property name="defaultEncoding" value="utf-8"></property>
       <property name="maxUploadSize" value="10240000"></property>
       <property name="resolveLazily" value="true"></property>
    </bean>
	
	<!-- 配置异常解析器 -->
    <!-- <bean class="com.mfc.exception.MyException"></bean> -->
</beans>

conf.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>
<!-- 设置自身相关属性 -->
	<settings >
	<!-- 开启二级缓存 -->
		<setting name="cacheEnabled" value="true"/>
	<!-- 开启驼峰命名法则 -->
		<setting name="mapUnderscoreToCamelCase" value="true"/>
	</settings>
	 <plugins>
      <!-- 分页插件配置 -->
      <plugin interceptor="com.github.pagehelper.PageHelper">
         <property name="reasonable" value="true"/>
      </plugin>
   </plugins>

</configuration>

登录界面：index.jsp

 

 

<center>
        
        <h2>用户登录</h2>
        <h3 style="color: red">
          ${msg }
        </h3>
        <form action="login/userLogin.do" method="post">
          用户名：<input type="text" name="userName"><br>
          密  码：<input type="password" name="upass"><br>
          <input type="submit"  value="登录">
        </form>
      
      </center>

登录成功界面：main.jsp

 

 

<center>
     
     <h2>欢迎${empty nowuser ? "游客":nowuser.userName },来到我的主页</h2>
     
     <a href="user/userlist.do">查看用户列表</a>
     <br>
     <a href="user/userlistpage.do">查看用户列表分页</a>
     <hr>
      
</center>

LoginCtrl.java:

 

 

package com.mfc.ctrl;

import javax.annotation.Resource;

import org.springframework.context.annotation.Scope;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.SessionAttributes;
import org.springframework.web.servlet.ModelAndView;

import com.mfc.entity.User;
import com.mfc.service.IUserService;

@Controller
@Scope("prototype")
@RequestMapping("login")
@SessionAttributes("nowuser")
public class LoginCtrl {
	@Resource(name="userService")
	IUserService userService;
	
	@RequestMapping("userLogin")
	public ModelAndView userLogin(ModelAndView mav,User user){
		System.out.println("姓名："+user.getUserName()+"   密码："+user.getUpass());
		
		User nowuser = userService.login(user);
		
		if(nowuser != null){
			//属性名和@SessionAttributes中的属性名一致的话，存入session对象
			mav.addObject("nowuser", nowuser);
			mav.setViewName("redirect:../main.jsp");
		}else{
			mav.addObject("msg", "用户名或密码错误！");
			mav.setViewName("forward:../index.jsp");
		}
		return mav;
	}
}

service层：

 

接口：

 

public interface IUserService {
	public User login(User user);
}

实现类：

 

 

@Service("userService")
public class UserService implements IUserService {

	@Resource(name="userDao")
	IUserDao userDao; //面向接口编程
	public User login(User user) {
		User u = null;
		//处理业务逻辑
		if(user != null&&user.getUserName() != null&&user.getUpass() != null){
			u = userDao.login(user);
		}
		return u;
	}

}

dao层：

 

接口：

 

public interface IUserDao {
	
	//用户登录检验
	public User login(User user);
}

实现类：

 

 

package com.mfc.dao;

import java.util.List;

import javax.annotation.Resource;

import org.mybatis.spring.SqlSessionTemplate;
import org.springframework.stereotype.Repository;

import com.mfc.entity.User;
import com.mfc.mapper.UserMapper;

@Repository("userDao")
public class UserDao implements IUserDao {

	@Resource(name="sqlSessionTemplate")
	SqlSessionTemplate sqlSessionTemplate;
	
	public UserMapper getUserMapper(){
		return sqlSessionTemplate.getMapper(UserMapper.class);
	}
	
	public User login(User user) {
		User u = null;
		List<User> list=this.getUserMapper().selectUser(user);
		if(list != null&&list.size() > 0){
			u = list.get(0);
		}
		return u;
	}

}

 

 

 

 

 

mapper：

UserMapper.java：

 

package com.mfc.mapper;

import java.util.List;

import com.mfc.entity.User;

public interface UserMapper {
	
	public List<User> selectUser(User user);
	
	public void addUser(User user);
}

UserMapper.xml：这个文件里面就是写SQl语句的。

 

 

 

 

<?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.mfc.mapper.UserMapper">
	<select id="selectUser"  resultType="User">
      select  * from user 
      <where>
         <if test="userName!=null">
           and userName = #{userName}
         </if>
         <if test="upass!=null">
           and upass = #{upass}
         </if>
      </where>

   </select>
   
   <insert id="addUser" parameterType="User" keyProperty="uid" useGeneratedKeys="true">
      insert into user values
      (null,#{userName},#{userAge},#{userAddress},#{upass})
   </insert>
   
   <!-- <update id="updateUsers" parameterType="Users" >
      update users set uname=#{uname},upass=#{upass},sex=#{sex}
      ,age=#{age},birthday=#{birthday},active=#{active},pic=#{pic}
      where uid=#{uid}
   </update>
   
   <delete id="delUsers" parameterType="int">
      delete from users where uid=#{uid}
   </delete>
   
   
   <select id="selectUsers"  resultType="Users">
      select  * from users
   </select> -->
</mapper>

实体类：

 

 

package com.mfc.entity;

/*
 * 实体类
 * */
public class User {
	private int id;
	private String userName;
	private int userAge;
	private String userAddress;
	private String upass;
        //set,get,构造方法省略
}

五、测试可用！

 

 

 

六、源码下载：http://download.csdn.net/detail/fancheng614/9907891