本文主要介绍了如何将mybatis和spring整合在一起使用,本人使用的是mybatis3.05 + spring3.1.0M2 ,使用dbcp作为数据库连接池。
1.编写数据访问接口(UserDao.java)
package com.mybatis; public interface UserDao { public int countAll(); }
2.编写数据访问接口映射文件(UserDaoMapper.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.mybatis.UserDao"> <select id="countAll" resultType="int"> select count(*) c from user; </select> </mapper>
3.编写mybatis配置文件(MyBatis-Configuration.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> <mappers> <mapper resource="com/mybatis/UserDaoMapper.xml"/> </mappers> </configuration>
4.编写服务层接口(UserService.java)
package com.mybatis; public interface UserService { public int countAll(); }
5.编写服务层实现代码(UserServiceImpl.java)
package com.mybatis; public class UserServiceImpl implements UserService { private UserDao userDao; public UserDao getUserDao() { return userDao; } public void setUserDao(UserDao userDao) { this.userDao = userDao; } public int countAll() { return this.userDao.countAll(); } }
6.编写spring配置文件(applicationContext.xml)
<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" 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-3.0.xsd"> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"> <property name="driverClassName" value="com.mysql.jdbc.Driver"></property> <property name="url" value="jdbc:mysql://localhost:3306/hlp?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull"></property> <property name="username" value="root"></property> <property name="password" value="1234"></property> <property name="maxActive" value="100"></property> <property name="maxIdle" value="30"></property> <property name="maxWait" value="500"></property> <property name="defaultAutoCommit" value="true"></property> </bean> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="configLocation" value="classpath:MyBatis-Configuration.xml"></property> <property name="dataSource" ref="dataSource" /> </bean> <bean id="userDao" class="org.mybatis.spring.mapper.MapperFactoryBean"> <property name="mapperInterface" value="com.mybatis.UserDao"></property> <property name="sqlSessionFactory" ref="sqlSessionFactory"></property> </bean> <bean id="userService" class="com.mybatis.UserServiceImpl"> <property name="userDao" ref="userDao"></property> </bean> </beans>
7.测试代码(UserServiceTest.java)
package com.mybatis; import org.junit.Test; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; public class UserServiceTest { @Test public void userServiceTest(){ ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml"); UserService userService = (UserService)context.getBean("userService"); System.out.println(userService.countAll()); } }
附录:需要导入的库:
相关推荐
这是一个小型的项目,关于spring和mybatis整合的小项目,直接可运行,无错误
Spring和mybatis整合
spring_mybatis 整合jar包,基本常用jar包的整合,。。。。。。。。。。。。。。。
spring和mybatis整合.zip
spring和mybatis整合 jar包 spring和mybatis整合 jar包
spring与mybatis的整合,改文档详细介绍了如何整合,代码完整。
spring和mybatis整合所需的jar包
spring和mybatis框架整合,采用mapper代理自动扫描方式实现,已添加junit测试类。建议参照我的另一资源spring和mybatis整合(原始dao方式实现)对比
spring和Mybatis整合jar包,各个jar包的分类已经做好了。
spring和mybatis整合框架搭建成功,仅实现登录功能,数据库是mysql,需要自己建User对象对应的user表。
spring和mybatis整合配置文件
spring和mybatis整合所需的jar包,将这些jar包导入到lib文件夹中即可
spring整合Mybatis纯净项目,基础搭建,下载就用,包含整套源码,jar包
Spring和Mybatis整合案例,里面有说明和注释。
Spring和Mybatis整合英文文档翻译.docxSpring和Mybatis整合英文文档翻译.docx
Spring和Mybatis整合英文文档翻译.pdfSpring和Mybatis整合英文文档翻译.pdf
spring-mybatis整合jar包spring-mybatis整合jar包spring-mybatis整合jar包
spring mvc mybatis 整合源码,带数据库脚本,带详细注释,适合初、中、高各级开发人员使用