Mybatis和Spring的整合：传统方式的Dao开发

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

### Mybatis和Spring的整合 ###

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

*  数据库连接及连接池
 *  sqlsessionFactory对象，配置到spring容器中
 *  编写Spring的配置文件

jdbc.properties配置文件  
log4j.properties配置文件

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

##### 传统模式的Dao开发 #####

1、Spring的配置文件

<?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="userDao" class="com.pipi.mybatis.dao.UserDaoImpl">
            
            <property name="sqlSessionFactory" ref="sqlSessionFactory" />
        </bean>
    
    </beans>

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

2、Mybatis的核心配置文件

<?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>
    
        
        <mappers>
            <mapper resource="mybatis/user.xml" />
        </mappers>
    
    </configuration>

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

3、编写UserDao

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

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

4、编写映射文件

<?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="user">
    
    	
    	<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="com.pipi.mybatis.pojo.User" useGeneratedKeys="true" keyProperty="id">
    		INSERT INTO `user`(`username`,`birthday`,`sex`,`address`)
    		VALUES (#{username},#{birthday},#{sex},#{address});
    	</insert>
    
    </mapper>

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

5、编写实现类

package com.pipi.mybatis.dao;
    
    import com.pipi.mybatis.pojo.User;
    import org.apache.ibatis.session.SqlSession;
    import org.mybatis.spring.support.SqlSessionDaoSupport;
    import java.util.List;
    
    public class UserDaoImpl extends SqlSessionDaoSupport implements UserDao { 
    
        @Override
        public User getUserById(Integer id) { 
            SqlSession sqlSession = getSqlSession();
            User user = sqlSession.selectOne("user.getUserById", id);
            return user;
        }
    
        @Override
        public List<User> getUserByUserName(String userName) { 
            SqlSession sqlSession = getSqlSession();
            List<User> list = sqlSession.selectList("user.getUserByUserName", userName);
            return list;
        }
    
        @Override
        public void insertUser(User user) { 
            SqlSession sqlSession = getSqlSession();
            sqlSession.insert("user.insertUser", user);
            // 事务交给spring管理，不需要再关闭sqlSession，否则会报错
        }
    }

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

6、编写测试程序

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

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