Mybatis和Spring的整合：动态代理方式的Dao开发

浅浅的花香味﹌ 2022-12-10 03:49 161阅读 0赞

### Mybatis和Spring的整合：动态代理方式的Dao开发 ###

创建一个java工程。  
导入jar包。（mybatis与spring整合所有包）  
mybatis的配置文件sqlmapConfig.xml  
编写Spring的配置文件  
复制jdbc.properties配置文件到新工程  
复制log4j.properties配置文件到新工程

--------------------

1、编写Mybatis的核心配置文件：SqlMapConfig.xml

其实不用写任何东西，全部交给Spring管理

<?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>
    
    </configuration>

--------------------

2、编写实体类

public class User { 
    
    	private Integer id;
    	private String username;// 用户姓名
    	private String sex;// 性别
    	private Date birthday;// 生日
    	private String address;// 地址
    	// ......
    }

--------------------

3、编写Spring的核心配置文件：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:p="http://www.springframework.org/schema/p" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.0.xsd">
    
        
        <context:property-placeholder location="classpath:jdbc.properties" />
    
        
        <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
            <property name="driverClassName" value="${jdbc.driver}" />
            <property name="url" value="${jdbc.url}" />
            <property name="username" value="${jdbc.username}" />
            <property name="password" value="${jdbc.password}" />
            
            <property name="maxActive" value="10" />
            
            <property name="maxIdle" value="5" />
        </bean>
    
        
        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            
            <property name="dataSource" ref="dataSource" />
            
            <property name="configLocation" value="classpath:SqlMapConfig.xml" />
            
            <property name="typeAliasesPackage" value="com.pipi.mybatis.pojo" />
        </bean>
    
        
        
        <bean id="baseMapper" class="org.mybatis.spring.mapper.MapperFactoryBean" abstract="true" lazy-init="true">
            <property name="sqlSessionFactory" ref="sqlSessionFactory" />
        </bean>
        
        
        
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            
            <property name="basePackage" value="com.pipi.mybatis.mapper" />
        </bean>
    
    </beans>

--------------------

4、编写接口

// 用户信息持久化接口
    public interface UserMapper { 
    
    	// 根据用户ID查询用户信息
    	User getUserById(Integer id);
    
    	// 根据用户名查找用户列表
    	List<User> getUserByUserName(String userName);
    
    	// 添加用户
    	void insertUser(User user);
    }

--------------------

5、编写映射配置文件

动态代理Dao的开发条件，注意细节。

<?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.pipi.mybatis.mapper.UserMapper">
    
    	
    	<sql id="user_sql">
    		`id`,
    		`username`,
    		`birthday`,
    		`sex`,
    		`address`
    	</sql>
    
    	<select id="getUserById" parameterType="int" resultType="user">
    		SELECT
    		<include refid="user_sql" />
    		FROM `user` WHERE id = #{id2}
    	</select>
    
    	
    	<select id="getUserByUserName" parameterType="string" resultType="user">
    		SELECT
    		<include refid="user_sql" />
    		FROM `user` WHERE username LIKE '%${value}%'
    	</select>
    
    	
    	
    	<insert id="insertUser" parameterType="user" useGeneratedKeys="true" keyProperty="id">
    		INSERT INTO `user`(`username`,`birthday`,`sex`,`address`)
    		VALUES (#{username},#{birthday},#{sex},#{address});
    	</insert>
    
    </mapper>

--------------------

6、编写测试程序

public class TestUserMapper { 
    
        private ApplicationContext applicationContext;
    
        @Before
        public void init() { 
            applicationContext = new ClassPathXmlApplicationContext("classpath:applicationContext.xml");
        }
    
        @Test
        public void testGetUserById() { 
            UserMapper userMapper = applicationContext.getBean(UserMapper.class);
            User user = userMapper.getUserById(1);
            System.out.println(user);  // User{id=1, username='王五', sex='2', birthday=null, address='null', orders=null}
        }
    
        @Test
        public void testGetUserByUserName() { 
            UserMapper userMapper = applicationContext.getBean(UserMapper.class);
            List<User> list = userMapper.getUserByUserName("张");
            for (User u : list) { 
                System.out.println(u);
            }
        }
    
        @Test
        public void testInsertUser() { 
            UserMapper userMapper = applicationContext.getBean(UserMapper.class);
            User user = new User();
            user.setUsername("赵子龙");
            userMapper.insertUser(user);
            System.out.println(user.getId());  // 28
        }
    }

--------------------