此项目时通过DAO层接口的方式来调用mybatis的

1：在IDEA中创建一个maven项目

2.maven依赖

<?xml version="1.0" encoding="UTF-8"?><project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"><modelVersion>4.0.0</modelVersion><groupId>org.suda</groupId><artifactId>mybatisStudy_day03</artifactId><version>1.0-SNAPSHOT</version><packaging>war</packaging><name>mybatisStudy_day03 Maven Webapp</name><!-- FIXME change it to the project's website --><url>http://www.example.com</url><properties><project.build.sourceEncoding>UTF-8</project.build.sourceEncoding><maven.compiler.source>1.8</maven.compiler.source><maven.compiler.target>1.8</maven.compiler.target><spring.version>5.2.5.RELEASE</spring.version></properties><dependencies><dependency><groupId>org.springframework</groupId><artifactId>spring-context</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-web</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-webmvc</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-test</artifactId><version>${spring.version}</version></dependency><dependency><groupId>javax.servlet</groupId><artifactId>javax.servlet-api</artifactId><version>4.0.1</version></dependency><dependency><groupId>javax.servlet.jsp</groupId><artifactId>jsp-api</artifactId><version>2.0</version><scope>provided</scope></dependency><dependency><groupId>javax.servlet.jsp.jstl</groupId><artifactId>jstl-api</artifactId><version>1.2</version><exclusions><exclusion><artifactId>jsp-api</artifactId><groupId>javax.servlet.jsp</groupId></exclusion></exclusions></dependency><dependency><groupId>junit</groupId><artifactId>junit</artifactId><version>4.11</version><scope>test</scope></dependency><dependency><groupId>javax.servlet.jsp.jstl</groupId><artifactId>jstl-api</artifactId><version>1.2</version><exclusions><exclusion><artifactId>jsp-api</artifactId><groupId>javax.servlet.jsp</groupId></exclusion></exclusions></dependency><dependency><groupId>org.mybatis</groupId><artifactId>mybatis-spring</artifactId><version>1.3.1</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-tx</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-jdbc</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.mybatis</groupId><artifactId>mybatis</artifactId><version>3.2.8</version></dependency><dependency><groupId>org.mybatis.generator</groupId><artifactId>mybatis-generator-core</artifactId><version>1.4.0</version></dependency><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>5.1.28</version></dependency><dependency><groupId>com.mchange</groupId><artifactId>c3p0</artifactId><version>0.9.5</version></dependency><dependency><groupId>com.fasterxml.jackson.core</groupId><artifactId>jackson-core</artifactId><version>2.9.5</version></dependency><dependency><groupId>com.fasterxml.jackson.core</groupId><artifactId>jackson-databind</artifactId><version>2.9.5</version><exclusions><exclusion><artifactId>jackson-annotations</artifactId><groupId>com.fasterxml.jackson.core</groupId></exclusion></exclusions></dependency><dependency><groupId>com.fasterxml.jackson.core</groupId><artifactId>jackson-annotations</artifactId><version>2.9.5</version></dependency><dependency><groupId>com.fasterxml.jackson.module</groupId><artifactId>jackson-module-jaxb-annotations</artifactId><version>2.9.5</version><exclusions><exclusion><artifactId>jackson-annotations</artifactId><groupId>com.fasterxml.jackson.core</groupId></exclusion></exclusions></dependency><dependency><groupId>log4j</groupId><artifactId>log4j</artifactId><version>1.2.17</version></dependency><!-- 分页插件 --><dependency><groupId>com.github.pagehelper</groupId><artifactId>pagehelper-spring-boot-starter</artifactId><version>1.2.9</version><exclusions><exclusion><artifactId>spring-boot-starter</artifactId><groupId>org.springframework.boot</groupId></exclusion><exclusion><artifactId>spring-boot-autoconfigure</artifactId><groupId>org.springframework.boot</groupId></exclusion><exclusion><artifactId>mybatis-spring</artifactId><groupId>org.mybatis</groupId></exclusion><exclusion><artifactId>spring-jdbc</artifactId><groupId>org.springframework</groupId></exclusion><exclusion><artifactId>mybatis</artifactId><groupId>org.mybatis</groupId></exclusion></exclusions></dependency></dependencies><build><finalName>mybatisStudy_day03</finalName><pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) --><plugins><plugin><artifactId>maven-clean-plugin</artifactId><version>3.1.0</version></plugin><!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging --><plugin><artifactId>maven-resources-plugin</artifactId><version>3.0.2</version></plugin><plugin><artifactId>maven-compiler-plugin</artifactId><version>3.8.0</version></plugin><plugin><artifactId>maven-surefire-plugin</artifactId><version>2.22.1</version></plugin><plugin><artifactId>maven-war-plugin</artifactId><version>3.2.2</version></plugin><plugin><artifactId>maven-install-plugin</artifactId><version>2.5.2</version></plugin><plugin><artifactId>maven-deploy-plugin</artifactId><version>2.8.2</version></plugin></plugins></pluginManagement></build>
</project>

3. index.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head><title>Title</title>
</head>
<body><a href="<%=request.getContextPath()%>/userController/queryUserAll">点击查询用户信息</a>
</body>
</html>

4.web.xml

<?xml version="1.0" encoding="utf-8"?>
<web-app xmlns="http://java.sun.com/xml/ns/javaee"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://java.sun.com/xml/ns/javaeehttp://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"version="3.0"metadata-complete="true"><display-name>Archetype Created Web Application</display-name><!--设置配置文件的路径--><context-param><param-name>contextConfigLocation</param-name><param-value>classpath:applicationContext.xml</param-value></context-param><!--配置spring的监听器，默认只加载WEB-INF目录下的applicationContext.xml文件--><listener><listener-class>org.springframework.web.context.ContextLoaderListener</listener-class></listener><!--配置dispatcherServlet--><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-servlet.xml</param-value></init-param></servlet><servlet-mapping><servlet-name>springmvc</servlet-name><url-pattern>/</url-pattern></servlet-mapping><!--配置post请求方式携带中文时的编码格式--><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><init-param><param-name>forceEncoding</param-name><param-value>true</param-value></init-param></filter><filter-mapping><filter-name>characterEncodingFilter</filter-name><url-pattern>/</url-pattern></filter-mapping>
</web-app>

5.springmvc-servlet.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"xmlns:mvc="http://www.springframework.org/schema/mvc"xmlns:context="http://www.springframework.org/schema/context"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns:http="http://www.springframework.org/schema/c"xsi:schemaLocation="http://www.springframework.org/schema/beanshttps://www.springframework.org/schema/beans/spring-beans.xsdhttp://www.springframework.org/schema/mvchttps://www.springframework.org/schema/mvc/spring-mvc.xsdhttp://www.springframework.org/schema/contexthttps://www.springframework.org/schema/context/spring-context.xsd"><!--配置自动化扫描机制，只扫描controlle注解类--><context:component-scan base-package="com.mybatisStudy"><context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/></context:component-scan><!--启用MVC配置--><mvc:annotation-driven/><!--配置视图解析器--><bean id="internalResourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver"><property name="prefix" value="/WEB-INF/com/orderManag"/><property name="suffix" value=".jsp"/></bean><!-- 允许访问静态文件-->
<!--    <mvc:resources mapping="/css/**" location="/css/"/>-->
<!--    <mvc:resources mapping="/js/**" location="/js/"/>-->
<!--    <mvc:resources mapping="/icons/**" location="/icons/"/>-->
<!--    <mvc:resources mapping="/image/**" location="/image/"/>-->
<!--    <mvc:resources mapping="/views/**/*" location="/views/"/>-->
<!--    <mvc:resources mapping="/layuiadmin/**/*" location="/layuiadmin/"/>-->
</beans>

6.applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"xmlns:context="http://www.springframework.org/schema/context"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns:http="http://www.springframework.org/schema/c"xsi:schemaLocation="http://www.springframework.org/schema/beanshttps://www.springframework.org/schema/beans/spring-beans.xsdhttp://www.springframework.org/schema/contexthttps://www.springframework.org/schema/context/spring-context.xsd"><!--配置自动化扫描机制，controlle注解不扫描--><context:component-scan base-package="com.mybatisStudy"><context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/></context:component-scan><bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"><property name="driverClass" value="com.mysql.jdbc.Driver"/><property name="jdbcUrl" value="jdbc:mysql://localhost:3306/order?useUnicode=true&amp;characterEncoding=UTF-8"/><property name="user" value="root"/><property name="password" value="root"/></bean><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><property name="configLocation" value="classpath:mybatis-config.xml"/><property name="dataSource" ref="dataSource"/><!-- 当mybatis的xml文件和mapper接口不在相同包下时，需要用mapperLocations属性指定xml文件的路径。*是个通配符，代表所有的文件，**代表所有目录下 --><property name="mapperLocations"><array><value>classpath:mybatisStudy/mybatisMappers/*.xml</value></array></property></bean><!--通过扫描的形式镜像配置Mapper的接口类--><bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer"><!--指定让spring自动扫描什么包，他会逐层深入扫描，如果遇到多个包可以使用逗号隔开--><property name="basePackage" value="com.**"/><!--如果类被@Repository注解标识的时候才会进行扫描。--><property name="annotationClass" value="org.springframework.stereotype.Repository"/></bean>
</beans>

7.mybatis-config.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configurationPUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration><!-- logImple属性配置指定使用LOG4J输出日志 --><settings><setting name="logImpl" value="LOG4J"/></settings>
</configuration>

8.log4j.properties

#全局配置
log4j.rootLogger=info, stdout
#MyBatis 日志配置
log4j.logger.com.mybatisStudy.dao=TRACE
#控制台输出配置
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern= %d{yyyy-MM-dd HH:mm:ss} <%p> %l %m%n

9.UserController.java

@Controller
@RequestMapping("/userController")
public class UserController {private static final Logger log = Logger.getLogger("UserController.class");@Autowired@Qualifier("userServiceImpl")private IUserService userServiceImpl;@RequestMapping(value = "/queryUserAll",method = RequestMethod.GET)public void queryUserAll(){log.info("UserController queryUserAll begin");userServiceImpl.queryUserAll();}
}

10.IUserService.java

public interface IUserService {void queryUserAll();
}

11.UserServiceImpl.java

@Service(value = "userServiceImpl")
public class UserServiceImpl implements IUserService {private static final Logger log = Logger.getLogger("UserServiceImpl.class");@Autowiredprivate IUserDao userDaoImpl;@Overridepublic void queryUserAll() {log.info("UserServiceImpl queryUserAll begin");List<UserVO> userVOList = userDaoImpl.queryUserAll();if(null != userVOList && userVOList.size()>0){for(UserVO userVo : userVOList){System.out.println(userVo.toString());}}}
}

12.IUserDao.java

@Repository("userDaoImpl")
public interface IUserDao {int deleteUserInfo(String[] idArray);int deleteByPrimaryKey(@Param("id") String id, @Param("userNum") String userNum);int insert(UserVO record);int insertSelective(UserVO record);UserVO selectByPrimaryKey(@Param("id") String id);List<UserVO> queryUserAll();List<UserVO> queryUserAllOffPage(UserVO UserVO);Integer queryUserAllOffPageCount(UserVO UserVO);int updateByPrimaryKeySelective(UserVO record);int updateByPrimaryKey(UserVO record);
}

13.UserVO.java

package com.mybatisStudy.vo;import java.util.Date;public class UserVO {private String id;private String userNum;private String userName;private String password;private String userMotto;private String telephone;private String address;private String eMail;private String iconNum;private String userSex;private Date lastSiginTime;private Integer loginNumbers;private String createName;private String createNum;private String updateName;private String updateNum;private Date creatTime;private Date updateTime;private String state;private static final long serialVersionUID = 1L;public String getId() {return id;}public void setId(String id) {this.id = id == null ? null : id.trim();}public String getUserNum() {return userNum;}public void setUserNum(String userNum) {this.userNum = userNum == null ? null : userNum.trim();}public String getUserName() {return userName;}public void setUserName(String userName) {this.userName = userName == null ? null : userName.trim();}public String getPassword() {return password;}public void setPassword(String password) {this.password = password == null ? null : password.trim();}public String getUserMotto() {return userMotto;}public void setUserMotto(String userMotto) {this.userMotto = userMotto == null ? null : userMotto.trim();}public String getTelephone() {return telephone;}public void setTelephone(String telephone) {this.telephone = telephone == null ? null : telephone.trim();}public String getAddress() {return address;}public void setAddress(String address) {this.address = address == null ? null : address.trim();}public String getEMail() {return eMail;}public void setEMail(String eMail) {this.eMail = eMail == null ? null : eMail.trim();}public String getIconNum() {return iconNum;}public void setIconNum(String iconNum) {this.iconNum = iconNum == null ? null : iconNum.trim();}public String getUserSex() {return userSex;}public void setUserSex(String userSex) {this.userSex = userSex == null ? null : userSex.trim();}public Date getLastSiginTime() {return lastSiginTime;}public void setLastSiginTime(Date lastSiginTime) {this.lastSiginTime = lastSiginTime;}public Integer getLoginNumbers() {return loginNumbers;}public void setLoginNumbers(Integer loginNumbers) {this.loginNumbers = loginNumbers;}public String getCreateName() {return createName;}public void setCreateName(String createName) {this.createName = createName == null ? null : createName.trim();}public String getCreateNum() {return createNum;}public void setCreateNum(String createNum) {this.createNum = createNum == null ? null : createNum.trim();}public String getUpdateName() {return updateName;}public void setUpdateName(String updateName) {this.updateName = updateName == null ? null : updateName.trim();}public String getUpdateNum() {return updateNum;}public void setUpdateNum(String updateNum) {this.updateNum = updateNum == null ? null : updateNum.trim();}public Date getCreatTime() {return creatTime;}public void setCreatTime(Date creatTime) {this.creatTime = creatTime;}public Date getUpdateTime() {return updateTime;}public void setUpdateTime(Date updateTime) {this.updateTime = updateTime;}public String getState() {return state;}public void setState(String state) {this.state = state == null ? null : state.trim();}@Overridepublic String toString() {return "UserVO{" +"id='" + id + '\'' +", userNum='" + userNum + '\'' +", userName='" + userName + '\'' +", password='" + password + '\'' +", userMotto='" + userMotto + '\'' +", telephone='" + telephone + '\'' +", address='" + address + '\'' +", eMail='" + eMail + '\'' +", iconNum='" + iconNum + '\'' +", userSex='" + userSex + '\'' +", lastSiginTime=" + lastSiginTime +", loginNumbers=" + loginNumbers +", createName='" + createName + '\'' +", createNum='" + createNum + '\'' +", updateName='" + updateName + '\'' +", updateNum='" + updateNum + '\'' +", creatTime=" + creatTime +", updateTime=" + updateTime +", state='" + state + '\'' +'}';}
}

14.SysUserMapper.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.mybatisStudy.dao.IUserDao"><resultMap id="BaseResultMap" type="com.mybatisStudy.vo.UserVO"><id column="ID" jdbcType="VARCHAR" property="id" /><result column="USER_NUM" jdbcType="VARCHAR" property="userNum" /><result column="USER_NAME" jdbcType="VARCHAR" property="userName" /><result column="PASSWORD" jdbcType="VARCHAR" property="password" /><result column="USER_MOTTO" jdbcType="VARCHAR" property="userMotto" /><result column="TELEPHONE" jdbcType="VARCHAR" property="telephone" /><result column="ADDRESS" jdbcType="VARCHAR" property="address" /><result column="EMAIL" jdbcType="VARCHAR" property="eMail" /><result column="ICON_NUM" jdbcType="VARCHAR" property="iconNum" /><result column="USER_SEX" jdbcType="CHAR" property="userSex" /><result column="LAST_SIGIN_TIME" jdbcType="DATE" property="lastSiginTime" /><result column="LOGIN_NUMBERS" jdbcType="INTEGER" property="loginNumbers" /><result column="CREATE_NAME" jdbcType="VARCHAR" property="createName" /><result column="CREATE_NUM" jdbcType="VARCHAR" property="createNum" /><result column="UPDATE_NAME" jdbcType="VARCHAR" property="updateName" /><result column="UPDATE_NUM" jdbcType="VARCHAR" property="updateNum" /><result column="CREAT_TIME" jdbcType="DATE" property="creatTime" /><result column="UPDATE_TIME" jdbcType="DATE" property="updateTime" /><result column="STATE" jdbcType="CHAR" property="state" /></resultMap><sql id="Base_Column_List">ID, USER_NUM, USER_NAME, PASSWORD, USER_MOTTO, TELEPHONE, ADDRESS, EMAIL, ICON_NUM, USER_SEX, LAST_SIGIN_TIME, LOGIN_NUMBERS, CREATE_NAME, CREATE_NUM, UPDATE_NAME, UPDATE_NUM, CREAT_TIME, UPDATE_TIME, STATE</sql><select id="queryUserAll" resultMap="BaseResultMap">select<include refid="Base_Column_List" />from sys_user</select><select id="queryUserAllOffPage" resultMap="BaseResultMap">selectID, USER_NUM, USER_NAME, PASSWORD, USER_MOTTO, TELEPHONE, ADDRESS, EMAIL, ICON_NUM,USER_SEX, LAST_SIGIN_TIME, LOGIN_NUMBERS, CREATE_NAME, CREATE_NUM, UPDATE_NAME, UPDATE_NUM,CREAT_TIME, UPDATE_TIME, STATEfrom sys_user<where><if test="userNum != null and userNum != ''"> and USER_NUM = #{userNum} </if><if test="userName != null and userName != ''"> and USER_NAME like concat(concat('%',#{userName}),'%')</if><if test="userSex != null and userSex != ''"> and USER_SEX = #{userSex} </if></where>limit #{startIndex},#{queryCount}</select><select id="queryUserAllOffPageCount" resultType="int">select count(id) from sys_user<where><if test="userNum != null and userNum != ''"> and USER_NUM = #{userNum} </if><if test="userName != null and userName != ''"> and USER_NAME like concat(concat('%',#{userName}),'%')</if><if test="userSex != null and userSex != ''"> and USER_SEX = #{userSex} </if></where></select><select id="selectByPrimaryKey" parameterType="map" resultMap="BaseResultMap">select <include refid="Base_Column_List" />from sys_user where ID = #{id,jdbcType=VARCHAR}</select><delete id="deleteByPrimaryKey" parameterType="map">delete from sys_userwhere ID = #{id,jdbcType=VARCHAR}and USER_NUM = #{userNum,jdbcType=VARCHAR}</delete><delete id="deleteUserInfo" parameterType="java.lang.String">delete from sys_user where id in<foreach collection="array" item="id" open="(" close=")" separator="," index="i">#{id}</foreach></delete><insert id="insert" parameterType="com.mybatisStudy.vo.UserVO">insert into sys_user (ID, USER_NUM, USER_NAME, PASSWORD, USER_MOTTO, TELEPHONE, ADDRESS, EMAIL, ICON_NUM, USER_SEX, LAST_SIGIN_TIME, LOGIN_NUMBERS, CREATE_NAME, CREATE_NUM, UPDATE_NAME, UPDATE_NUM, CREAT_TIME, UPDATE_TIME, STATE)values (#{id,jdbcType=VARCHAR}, #{userNum,jdbcType=VARCHAR}, #{userName,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR}, #{userMotto,jdbcType=VARCHAR}, #{telephone,jdbcType=VARCHAR}, #{address,jdbcType=VARCHAR}, #{eMail,jdbcType=VARCHAR}, #{iconNum,jdbcType=VARCHAR}, #{userSex,jdbcType=CHAR}, #{lastSiginTime,jdbcType=DATE}, #{loginNumbers,jdbcType=INTEGER}, #{createName,jdbcType=VARCHAR}, #{createNum,jdbcType=VARCHAR}, #{updateName,jdbcType=VARCHAR}, #{updateNum,jdbcType=VARCHAR}, #{creatTime,jdbcType=DATE}, #{updateTime,jdbcType=DATE}, #{state,jdbcType=CHAR})</insert><insert id="insertSelective" parameterType="com.mybatisStudy.vo.UserVO">insert into sys_user<trim prefix="(" suffix=")" suffixOverrides=","><if test="id != null">ID,</if><if test="userNum != null">USER_NUM,</if><if test="userName != null">USER_NAME,</if><if test="password != null">PASSWORD,</if><if test="userMotto != null">USER_MOTTO,</if><if test="telephone != null">TELEPHONE,</if><if test="address != null">ADDRESS,</if><if test="eMail != null">EMAIL,</if><if test="iconNum != null">ICON_NUM,</if><if test="userSex != null">USER_SEX,</if><if test="lastSiginTime != null">LAST_SIGIN_TIME,</if><if test="loginNumbers != null">LOGIN_NUMBERS,</if><if test="createName != null">CREATE_NAME,</if><if test="createNum != null">CREATE_NUM,</if><if test="updateName != null">UPDATE_NAME,</if><if test="updateNum != null">UPDATE_NUM,</if><if test="creatTime != null">CREAT_TIME,</if><if test="updateTime != null">UPDATE_TIME,</if><if test="state != null">STATE,</if></trim><trim prefix="values (" suffix=")" suffixOverrides=","><if test="id != null">#{id,jdbcType=VARCHAR},</if><if test="userNum != null">#{userNum,jdbcType=VARCHAR},</if><if test="userName != null">#{userName,jdbcType=VARCHAR},</if><if test="password != null">#{password,jdbcType=VARCHAR},</if><if test="userMotto != null">#{userMotto,jdbcType=VARCHAR},</if><if test="telephone != null">#{telephone,jdbcType=VARCHAR},</if><if test="address != null">#{address,jdbcType=VARCHAR},</if><if test="eMail != null">#{eMail,jdbcType=VARCHAR},</if><if test="iconNum != null">#{iconNum,jdbcType=VARCHAR},</if><if test="userSex != null">#{userSex,jdbcType=CHAR},</if><if test="lastSiginTime != null">#{lastSiginTime,jdbcType=DATE},</if><if test="loginNumbers != null">#{loginNumbers,jdbcType=INTEGER},</if><if test="createName != null">#{createName,jdbcType=VARCHAR},</if><if test="createNum != null">#{createNum,jdbcType=VARCHAR},</if><if test="updateName != null">#{updateName,jdbcType=VARCHAR},</if><if test="updateNum != null">#{updateNum,jdbcType=VARCHAR},</if><if test="creatTime != null">#{creatTime,jdbcType=DATE},</if><if test="updateTime != null">#{updateTime,jdbcType=DATE},</if><if test="state != null">#{state,jdbcType=CHAR},</if></trim></insert><update id="updateByPrimaryKeySelective" parameterType="com.mybatisStudy.vo.UserVO">update sys_user<set><if test="userName != null">USER_NAME = #{userName,jdbcType=VARCHAR},</if><if test="password != null">PASSWORD = #{password,jdbcType=VARCHAR},</if><if test="userMotto != null">USER_MOTTO = #{userMotto,jdbcType=VARCHAR},</if><if test="telephone != null">TELEPHONE = #{telephone,jdbcType=VARCHAR},</if><if test="address != null">ADDRESS = #{address,jdbcType=VARCHAR},</if><if test="eMail != null">EMAIL = #{eMail,jdbcType=VARCHAR},</if><if test="iconNum != null">ICON_NUM = #{iconNum,jdbcType=VARCHAR},</if><if test="userSex != null">USER_SEX = #{userSex,jdbcType=CHAR},</if><if test="lastSiginTime != null">LAST_SIGIN_TIME = #{lastSiginTime,jdbcType=DATE},</if><if test="loginNumbers != null">LOGIN_NUMBERS = #{loginNumbers,jdbcType=INTEGER},</if><if test="createName != null">CREATE_NAME = #{createName,jdbcType=VARCHAR},</if><if test="createNum != null">CREATE_NUM = #{createNum,jdbcType=VARCHAR},</if><if test="updateName != null">UPDATE_NAME = #{updateName,jdbcType=VARCHAR},</if><if test="updateNum != null">UPDATE_NUM = #{updateNum,jdbcType=VARCHAR},</if><if test="creatTime != null">CREAT_TIME = #{creatTime,jdbcType=DATE},</if><if test="updateTime != null">UPDATE_TIME = #{updateTime,jdbcType=DATE},</if><if test="state != null">STATE = #{state,jdbcType=CHAR},</if></set>where ID = #{id,jdbcType=VARCHAR}and USER_NUM = #{userNum,jdbcType=VARCHAR}</update><update id="updateByPrimaryKey" parameterType="com.mybatisStudy.vo.UserVO">update sys_userset USER_NAME = #{userName,jdbcType=VARCHAR},PASSWORD = #{password,jdbcType=VARCHAR},USER_MOTTO = #{userMotto,jdbcType=VARCHAR},TELEPHONE = #{telephone,jdbcType=VARCHAR},ADDRESS = #{address,jdbcType=VARCHAR},EMAIL = #{eMail,jdbcType=VARCHAR},ICON_NUM = #{iconNum,jdbcType=VARCHAR},USER_SEX = #{userSex,jdbcType=CHAR},LAST_SIGIN_TIME = #{lastSiginTime,jdbcType=DATE},LOGIN_NUMBERS = #{loginNumbers,jdbcType=INTEGER},CREATE_NAME = #{createName,jdbcType=VARCHAR},CREATE_NUM = #{createNum,jdbcType=VARCHAR},UPDATE_NAME = #{updateName,jdbcType=VARCHAR},UPDATE_NUM = #{updateNum,jdbcType=VARCHAR},CREAT_TIME = #{creatTime,jdbcType=DATE},UPDATE_TIME = #{updateTime,jdbcType=DATE},STATE = #{state,jdbcType=CHAR}where ID = #{id,jdbcType=VARCHAR}and USER_NUM = #{userNum,jdbcType=VARCHAR}</update>
</mapper>

spring集成mybatis方式的知识点。

关键代码分析

使用C3P0链接池获取dataSouce

    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"><property name="driverClass" value="com.mysql.jdbc.Driver"/><property name="jdbcUrl" value="jdbc:mysql://localhost:3306/order?useUnicode=true&amp;characterEncoding=UTF-8"/><property name="user" value="root"/><property name="password" value="root"/></bean>

在jdbcUrl中的需要配置useUnicode=true&characterEncoding=UTF-8，可以达到在查询中文时不会乱码

使用org.mybatis.spring.SqlSessionFactoryBean类配置sqlSessionFactory

    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><property name="configLocation" value="classpath:mybatis-config.xml"/><property name="dataSource" ref="dataSource"/><!-- 当mybatis的xml文件和mapper接口不在相同包下时，需要用mapperLocations属性指定xml文件的路径。*是个通配符，代表所有的文件，**代表所有目录下 --><property name="mapperLocations"><array><value>classpath:mybatisStudy/mybatisMappers/*.xml</value></array></property></bean>

1：在内部可以通过参数的形式引入mybatis-config.xml文件
2：dataSource参数为必填项
3：当mybatis的xml文件和mapper接口不在同一个包时，需要使用mapperLocations属性指定xml文件的路径。 *是个通配符，代表所有的文件，**代表所有目录下。我是把映射文件放到了resources文件夹下，自定义的文件夹路径。可以达到映射文件和Dao层的接口类不放到同一个包中，做到映射文件的独立管理
4：如果报没有找到映射文件，需要刷新下maven项目，重新编译整个项目，然后查看下编译后的文件夹中是否有映射文件。
5：如果是把映射文件和DAO层接口放到同一个包内，可以把映射文件的扫描配置配置到myabtis-config.xml文件中。

使用org.mybatis.spring.mapper.MapperScannerConfigurer来扫描DAO层接口类。

    <!--通过扫描的形式镜像配置Mapper的接口类--><bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer"><!--指定让spring自动扫描什么包，他会逐层深入扫描，如果遇到多个包可以使用逗号隔开--><property name="basePackage" value="com.**"/><!--如果类被@Repository注解标识的时候才会进行扫描。--><property name="annotationClass" value="org.springframework.stereotype.Repository"/></bean>

关于spring和数据库的编程各种详细配置请阅读我编写的其他文章