【Spring框架与MyBatis框架整合】

1、配置文件

<?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:aop="http://www.springframework.org/schema/aop"

       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.xsd
        http://www.springframework.org/schema/aop
        http://www.springframework.org/schema/aop/spring-aop.xsd">

    <!--创建连接池-->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://127.0.0.1:3306/zyp?useSSL=false"/>
        <property name="username" value="root"/>
        <property name="password" value="123456"/>
    </bean>

    <!--创建SqlSessionFactory 依附于SqlSessionFactoryBean-->
    <bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <property name="typeAliasesPackage" value="com.zyp.mybatis.entity"/>
        <property name="mapperLocations">
            <list>
                <value>classpath:com.zyp.mapper/*Mapper.xml</value>
            </list>
        </property>
    </bean>
    
    <!--创建DAO对象-->
    <bean id="scanner" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactoryBean"/>
        <property name="basePackage" value="com.zyp.mybatis.dao"/>
    </bean>

</beans>

配置文件详细说明：

<bean id="dataSource" class=""/>
<!--创建SqlSessionFactory-->
<bean id="ssfb" class="SqlSessionFactoryBean">
 <property name="dataSource" ref=""/>
 <property name="typeAliasesPackage">
 指定 实体类所在的包 com.baizhiedu.entity User
 Product
 </property>
 <property name="mapperLocations">
 指定 配置⽂件(映射⽂件)的路径 还有通⽤配置
 com.baizhiedu.mapper/*Mapper.xml
 </property>
</bean>
<!--DAO接⼝的实现类
 session ---> session.getMapper() --- xxxDAO实现类对象
 XXXDAO ---> xXXDAO
-->
<bean id="scanner" class="MapperScannerConfigure">
 <property name="sqlSessionFactoryBeanName" value="ssfb"/>
 <property name="basePacakge">
 指定 DAO接⼝放置的包 com.baizhiedu.dao
 </property>
</bean>

 

 2、类、接口、包、表的创建

UserDAO接口：

@Mapper
public interface UserDAO {
    public void save(User user);
}

User实体类：

public class User implements Serializable {
    private Integer id;
    private String name;
    private String password;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }
}

xxxMapper.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.zyp.mybatis.dao.UserDAO">

    <insert id="save" parameterType="com.zyp.mybatis.entity.User">
        insert into t_user (name,password) values (#{name},#{password})
    </insert>
</mapper>

表：

create table t_user (
id int primary key auto_increment,
name varchar(12),
password varchar(12));

 

3、测试代码以及效果

public class test1 {
    public static void main(String[] args) {
        ApplicationContext ctx = new ClassPathXmlApplicationContext("applicationContext2.xml");
        UserDAO userDAO = (UserDAO) ctx.getBean("userDAO");
        User user = new User();
        user.setName("Lisa");
        user.setPassword("123456789");
        userDAO.save(user);
    }
}