Spring与Mybatis的整合------原始Dao的整合方式

太过爱你忘了你带给我的痛 2022-07-13 23:06 209阅读 0赞

0.项目目录截图

![20161120154824992][]

1.db.properties

jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://localhost:3306/mybatistest
    jdbc.username=root
    jdbc.password=1234

2.log4j.properties

# Global logging configuration  
    log4j.rootLogger=DEBUG, stdout  
    # Console output...  
    log4j.appender.stdout=org.apache.log4j.ConsoleAppender  
    log4j.appender.stdout.layout=org.apache.log4j.PatternLayout  
    log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

3.SqlMapConfig.xml

<?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>
    	
    	<typeAliases>
    		<package name="com.mybatis.entity" />
    	</typeAliases>
    
    	
    	<mappers>
    		<mapper resource="sqlmap/User.xml" />
    	</mappers>
    
    </configuration>

![20161120154947181][]

4.User.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="user">
    	
    	<select id="findUserById" parameterType="int" resultType="user">
    		select
    		* from user where id = #{id}
    	</select>
    	
    	<select id="findUserByUsername" parameterType="java.lang.String"
    		resultType="user">
    		select * from user where username like '%${value}%'
    	</select>
    
    	
    
    	
    	
    	<insert id="insertUser" parameterType="com.mybatis.entity.User">
    		<selectKey keyProperty="id" order="AFTER" resultType="java.lang.Integer">
    			select
    			LAST_INSERT_ID()
    		</selectKey>
    		insert into user(username,birthday,sex,address)
    		values(#{username},#{birthday},#{sex},#{address})
    	</insert>
    	
    	<delete id="deleteUserById" parameterType="int">
    		delete from user where
    		id=#{id}
    	</delete>
    
    	
    	<update id="updateUser" parameterType="com.mybatis.entity.User">
    		update user set
    		username=#{username},birthday=#{birthday},sex=#{sex},address=#{address}
    		where id=#{id}
    	</update>
    
    </mapper>

![20161120155028620][]

5.applicationContext.xml

6.IUserDao.java

public interface IUserDao {
    	// 根据id查询用户信息
    	public User findUserById(int id);
    
    	// 添加用户信息
    	public void insertUser(User user);
    
    	// 删除用户信息
    	public void deleteUser(int id);
    
    	// 修改用户信息
    	public void updateUser(User user);
    }

7.UserDaoImpl.java

public class UserDaoImpl extends SqlSessionDaoSupport implements IUserDao {
    
    	// SqlSessionDaoSupport中包含了sqlSessionFactory，并进行了一些简单的封装
    	// private SqlSessionFactory sqlSessionFactory;
    
    	@Override
    	public User findUserById(int id) {
    		SqlSession sqlSession = this.getSqlSession();
    		User user = sqlSession.selectOne("user.findUserById", id);
    		return user;
    
    	}
    
    	@Override
    	public void insertUser(User user) {
    		SqlSession sqlSession = this.getSqlSession();
    		// 执行插入操作
    		sqlSession.insert("user.insertUser", user);
    
    	}
    
    	@Override
    	public void deleteUser(int id) {
    		SqlSession sqlSession = this.getSqlSession();
    		// 执行插入操作
    		sqlSession.delete("user.deleteUserById", id);
    
    	}
    
    	@Override
    	public void updateUser(User user) {
    		SqlSession sqlSession = this.getSqlSession();
    		// 执行插入操作
    		sqlSession.update("user.updateUser", user);
    	}
    
    }

![20161120155111864][]

8.测试代码

public class UserDaoImplTest {
    
    	private ApplicationContext applicationContext;
    
    	@Before
    	public void setUp() throws Exception {
    		// 创建spring容器
    
    		applicationContext = new ClassPathXmlApplicationContext(
    				"applicationContext.xml");
    
    	}
    
    	@Test
    	public void testFindUserById() throws Exception {
    
    		// 从spring容器中获取UserDao这个bean
    		IUserDao userDao = (IUserDao) applicationContext.getBean("userDao");
    		User user = userDao.findUserById(1);
    		System.out.println(user);
    
    	}
    
    	@Test
    	public void deleteUser() throws Exception {
    
    		// 从spring容器中获取UserDao这个bean
    		IUserDao userDao = (IUserDao) applicationContext.getBean("userDao");
    		userDao.deleteUser(44);
    
    	}
    
    	@Test
    	public void insertUser() throws Exception {
    
    		// 从spring容器中获取UserDao这个bean
    		IUserDao userDao = (IUserDao) applicationContext.getBean("userDao");
    		User user = new User();
    		user.setUsername("hehe");
    		user.setSex("2");
    		userDao.insertUser(user);
    		System.out.println(user);
    	}
    
    	@Test
    	public void updateUser() throws Exception {
    
    		// 从spring容器中获取UserDao这个bean
    		UserService service = applicationContext.getBean("userService",
    				UserService.class);
    		User user = new User();
    		user.setId(46);
    		user.setUsername("hehe22");
    		user.setSex("2");
    		service.updateUser(user);
    
    	}
    
    }

9.Mybatis与Spring整合，原始DAO的方式的一般步骤

1.采用此种方式，就是 编写DAO接口，编写DAO接口的实现类，编写实体的配置文件，将实体的配置文件加入到Mybatis的全局配置文件中。

2.在sqlMapConfig.xml中配置映射文件的位置

**\[html\]**  [view plain][]   [copy][view plain]

[print][view plain] [?][view plain] [![在CODE上查看代码片][CODE]][CODE_CODE] [![派生到我的代码片][ico_fork.svg]][ico_fork.svg 1]

1.  **<****mappers****>**  
2.    **<****mapper** resource="mapper.xml文件的地址" **/>**  
3.  **<****mapper** resource="mapper.xml文件的地址" **/>**  
4.  **</****mappers****>**

3.定义DAO接口

4.编写实体的配置文件

5.DAO接口的实现，去继承SqlSessionDaoSupport

dao接口实现类中，可以利用this.getSqlSession()进行数据的增删改查

6.Spring配置文件的配置

**\[html\]**  [view plain][]   [copy][view plain]

[print][view plain] [?][view plain] [![在CODE上查看代码片][CODE]][CODE_CODE] [![派生到我的代码片][ico_fork.svg]][ico_fork.svg 1]

1.  **<****bean** id=" "class="mapper接口的实现"**>**  
2.      **<****property** name="sqlSessionFactory" ref="sqlSessionFactory"**>****</****property****>**  
3.  **</****bean****>**

[10.源码下载][10.]

[20161120154824992]: /images/20220714/94daa69015eb4aaeb7dcf970f692ab4b.png
[20161120154947181]: /images/20220714/d2d6351bb2a64da89a33e5882e6d2694.png
[20161120155028620]: /images/20220714/763e3b8cf9b94a9c910566f161a2225b.png
[20161120155111864]: /images/20220714/83f6e9b8b3b34aa3a14c505926950eb0.png
[view plain]: http://blog.csdn.net/zbw18297786698/article/details/51801791#
[CODE]: https://code.csdn.net/assets/CODE_ico.png
[CODE_CODE]: https://code.csdn.net/snippets/1739804
[ico_fork.svg]: https://code.csdn.net/assets/ico_fork.svg
[ico_fork.svg 1]: https://code.csdn.net/snippets/1739804/fork
[10.]: http://download.csdn.net/detail/zbw18297786698/9687983