Spring整合Mybatis实现对数据库的增删改查

1.实现架构关系：三层架构

2.项目类型为Maven，首先在pom.xml项目部署描述文件里配置相关的依赖包：

    <!-- junit单元测试依赖包-->
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.11</version>
    </dependency>

    <!-- log4j日志依赖包-->
    <dependency>
        <groupId>log4j</groupId>
        <artifactId>log4j</artifactId>
        <version>1.2.17</version>
    </dependency>

    <!-- 添加spring相关依赖包-->
    <dependency>
        <groupId>commons-dbcp</groupId>
        <artifactId>commons-dbcp</artifactId>
        <version>1.4</version>
    </dependency>

    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-tx</artifactId>
        <version>4.3.2.RELEASE</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-core</artifactId>
        <version>4.3.2.RELEASE</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>4.3.2.RELEASE</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-test</artifactId>
        <version>4.3.2.RELEASE</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-tx</artifactId>
        <version>4.3.2.RELEASE</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-beans</artifactId>
        <version>4.3.2.RELEASE</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-jdbc</artifactId>
        <version>4.3.2.RELEASE</version>
    </dependency>

    <dependency>
        <groupId>commons-logging</groupId>
        <artifactId>commons-logging</artifactId>
        <version>1.1.1</version>
    </dependency>

    <!-- https://mvnrepository.com/artifact/commons-pool/commons-pool -->
    <dependency>
        <groupId>commons-pool</groupId>
        <artifactId>commons-pool</artifactId>
        <version>1.6</version>
    </dependency>

    <!-- https://mvnrepository.com/artifact/com.oracle/ojdbc14 -->
    <dependency>
        <groupId>com.oracle</groupId>
        <artifactId>ojdbc14</artifactId>
        <version>10.2.0.3.0</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>3.1.12</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis-spring</artifactId>
        <version>1.3.1</version>
    </dependency>
</dependencies>

3.创建spring配置文件：applicationContext.xml

<!-- spring配置文件-->

<!-- 引入db.properties连接数据库配置文件 -->
<bean id="config" class="org.springframework.beans.factory.config.PreferencesPlaceholderConfigurer">
    <property name="locations">
        <value>
            classpath:db.properties
        </value>
    </property>
</bean>

<!-- 配置连接数据库的数据源-->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
  <property name="driverClassName" value="${driver}"></property>
    <property name="url" value="${url}"></property>
    <property name="username" value="${user}"></property>
    <property name="password" value="${pass}"></property>
    <property name="maxActive" value="${maxActive}"></property>
    <property name="maxIdle" value="${maxIdle}"></property>
</bean>

<!-- 引入数据源和mybatis全局配置文件-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    <property name="dataSource" ref="dataSource"></property>
    <property name="configLocation" value="classpath:mybatis-config.xml"></property>
</bean>

<!-- 将Spring配置的sqlSessionFactory对象交给mapper-->
<!-- 引入mapper层的sqlSessionFactory-->
<bean id="studentMapper" class="com.zb.mapper.impl.StudentMapperImpl">
    <property name="sqlSessionFactory" ref="sqlSessionFactory"></property>
</bean>

<!-- 引入service层的studentMapper-->
<bean id="studentService" class="com.zb.service.impl.StudentServiceImpl">
    <property name="studentMapper" ref="studentMapper"></property>
</bean>

4.创建连接数据库需要的参数配置文件：db.properties

分别是连接数据库驱动的全类名、连接数据库的地址、数据库用户名称和密码、以及最大连接数和最大闲置数。
driver=com.mysql.jdbc.Driver 
url=jdbc:mysql://localhost:3306/springmybatis
user=root
pass=xxxxxx
maxIdle=1000
maxActive=500

5.创建mybatis全局配置文件：mybatis-config.xml

6.创建model层实体类的mybatis映射文件：studentMapper.xml
里面是具体对数据库操作

7.创建Mapper数据层(mybatis为mapper层，其它为dao层)，并创建相应的对数据库增删改查的方法
和相应的实现类，里面是对Mapper层方法的具体实现。


8.创建service业务层，并创建service层的实现类以及实现方法


9.使用单元测试在测试类中进行增删改查的测试