spring整合mybatis

添加依赖包

mysql依赖包 + 连接池dbcp + mybatis依赖包 +
spring-jdbc依赖包 + mybatis-spring依赖包

<!--mysql数据库连接包-->
<dependency>
  <groupId>mysql</groupId>
  <artifactId>mysql-connector-java</artifactId>
  <version>5.1.44</version>
</dependency>
<!--dbcp连接池包-->
<dependency>
  <groupId>commons-dbcp</groupId>
  <artifactId>commons-dbcp</artifactId>
  <version>1.4</version>
</dependency>
<!--mybatis包-->
<dependency>
  <groupId>org.mybatis</groupId>
  <artifactId>mybatis</artifactId>
  <version>3.4.5</version>
</dependency>
<!--mybati-spring包-->
<dependency>
  <groupId>org.mybatis</groupId>
  <artifactId>mybatis-spring</artifactId>
  <version>1.3.0</version>
</dependency>
<!--spring-jdbc包-->
<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-jdbc</artifactId>
  <version>3.2.8.RELEASE</version>
</dependency>

创建数据库配置文件db.properties

# data-source
url=jdbc:mysql://localhost:3306/xxx?useUnicode=true&characterEncoding=utf8&serverTimezone=UTC
driver=com.mysql.jdbc.Driver
username=root
password=root
initialSize=2
maxActive=10

spring文件中配置

<!--读取db.properties-->
<util:properties id="db" location="classpath:db.properties"/>
<!--配置连接池-->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
    <property name="driverClassName" value="#{db.driver}"/>
    <property name="url" value="#{db.url}"/>
    <property name="username" value="#{db.username}"/>
    <property name="password" value="#{db.password}"/>
    <property name="initialSize" value="#{db.initialSize}"/>
    <property name="maxActive" value="#{db.maxActive}"/>
</bean>
<!--配置接口扫描-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"">
    <properties name="basepackage" value="spring.dao"/>
</bean>
<!--配置mapper文件扫描-->
<bean class="org.mybatis.spring.SqlSessionFactoryBean">
    <properties name="dataSource" ref="dataSource"/>
    <properties name="mapperLocations" ref="classpath:mapper:*.xml"/>
</bean>

创建mapper文件

<?xml version="1.0" encoding="UTF-8" ?>  
<!DOCTYPE mapper PUBLIC "-//ibatis.apache.org//DTD Mapper 3.0//EN"      
"http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd">

<mapper namespace="spring.dao.UserDao">
    <insert id="insert" parameterType="spring.enitity.User">
      insert into user (userName, password, age, phone, email) values
      (#{userName}, #{password}, #{age}, #{phone}, #{email})
    </insert>
    <delete id="deleteById" parameterType="java.lang.Integer">
      delete from user where id=#{id}
    </delete>

    <update id="update" parameterType="spring.enitity.User">
      update user set userName=#{userName}, password=#{password},
      age=#{age}, phone=#{phone}, email=#{email}
      where id=#{id}
    </update>

    <select id="findAll" resultType="spring.enitity.User">
        select * from user
    </select>
</mapper>