网上的很多代码都是几年前的,在此更新一下:目录结构如下
需要的包大致如下:
1.首先创建一个数据库test,增加一个用户表user,属性Id,Name和Password;
2.创建实体类User.java
package fzu.bbs.pojo;
public class User {
private int id;
private String name;
private String pwd;
public User() {
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPwd() {
return pwd;
}
public void setPwd(String pwd) {
this.pwd = pwd;
}
@Override
public String toString() {
return "User [id=" + id + ", name=" + name + ", pwd=" + pwd + "]";
}
}
3.创建Dao和Mapper.xml:
UserDao:
package fzu.bbs.mapping;
import java.util.List;
import org.springframework.stereotype.Repository;
import fzu.bbs.pojo.User;
@Repository(value="UserDao")
public interface UserDao {
public int addUser(User user);
public User getUserById(int id);
public List<User> listUser();
}
UserMapper.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="fzu.bbs.mapping.UserDao">
<select id="getUserById" parameterType="int" resultType="fzu.bbs.pojo.User">
select * from user where Id=#{id}
</select>
<select id="listUser" resultType="User">
select * from user
</select>
<insert id="addUser" parameterType="User">
INSERT INTO user VALUES(#{id},#{name},#{pwd});
</insert>
</mapper>
4. 创建service接口以及其实现类:
UserService.java:
package fzu.bbs.service.imp;
import fzu.bbs.pojo.User;
public interface UserService {
User getUserById(int id);
}
UserServiceImp.java:
package fzu.bbs.service.imp;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import fzu.bbs.mapping.UserDao;
import fzu.bbs.pojo.User;
@Service
public class UserServiceImp implements UserService {
@Autowired
private UserDao userDao;
@Override
public User getUserById(int id) {
User user = userDao.getUserById(id);
return user;
}
}
5.代码大概如上,接下来是配置,Spring+mybatis只需要一个配置文件,把mybatis的生命周期交给Spring去管理,配置如下:
<?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"
xmlns:p="http://www.springframework.org/schema/p"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd">
<context:annotation-config />
<context:component-scan base-package="fzu.bbs" />
<!-- 引入配置文件 -->
<bean id="propertyConfigurer"
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="location" value="classpath:jdbc.properties" />
</bean>
<bean id="dataSource"
class="org.apache.commons.dbcp2.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}" />
<!-- 连接初始值,连接池启动时创建的连接数量的初始值 默认值是0 -->
<property name="initialSize" value="${jdbc.initialSize}" />
<!-- 最小空闲值.当空闲的连接数少于阀值时,连接池就会预申请去一些连接,以免洪峰来时来不及申请 默认值是0 -->
<property name="minIdle" value="${jdbc.maxIdle}" />
<!-- 最大空闲值.当经过一个高峰时间后,连接池可以慢慢将已经用不到的连接慢慢释放一部分,一直减少到maxIdle为止 ,0时无限制 默认值是8 -->
<property name="maxIdle" value="${jdbc.minIdle}" />
<!-- 连接池的最大值,同一时间可以从池分配的最多连接数量,0时无限制 默认值是8 -->
<property name="maxTotal" value="${jdbc.maxTotal}" />
</bean>
<!--创建一个sql会话工厂bean,指定数据源-->
<bean id="sqlSessionFactory"
class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="typeAliasesPackage" value="fzu.bbs.pojo" />
<property name="dataSource" ref="dataSource" />
<property name="mapperLocations" value="classpath:fzu/bbs/mapping/*.xml"></property>
</bean>
<!-- DAO接口所在包名,Spring会自动查找其下的类 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="fzu.bbs.mapping" />
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
</bean>
</beans>
注意我的jdbc用的连接池是dbcp2。
jdbc.properties的配置如下:
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&&characterEncoding=UTF-8
jdbc.username=root
jdbc.password=123456
jdbc.initialSize=3
jdbc.maxIdle=20
jdbc.minIdle=1
jdbc.maxTotal=15
6.这样就整合了sping和mybatis,可以测试一下:
package fzu.java.test;
import java.util.List;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import fzu.bbs.mapping.UserDao;
import fzu.bbs.pojo.User;
import fzu.bbs.service.imp.UserService;
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("classpath:spring-mybatis.xml")
public class test {
@Autowired
private UserService userService = null;
@Test
public void testList() {
User user = userService.getUserById(1);
System.out.println(user.toString());
}
}
结果为:
。。到此Sping+Mybatis本地整合就完成了。在中间遇到过一些bug,都是自己不细心导致的:
1.Failed to load ApplicationContext
问题出在Spring+Mybatis的配置文件中,很多综合问题,比如
自动扫描dao接口,注入sqlsessionfactory的时候注意!!要是: <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>,,不要是name="sqlSessionFactory",不然会引发提前初始化问题而报错
等等
2.Cannot find class [org.apache.commons.dbcp.BasicDataSource]
这个错误是缺少commons-dbcp.jar、commons-pool.jar两个包,如果是dbcp2.0版本,参照上方修改xml文档中的class。
3.org.apache.ibatis.binding.BindingException: Invalid bound statement (not found):
我遇到了这个问题,找了半天发现是Mapper.xml的namespace设置有错,一定要与Dao所在的文件名一致!!!!注意大小写是不是错误了
4.Cannot create PoolableConnectionFactory
以这个开头的基本就是jdbc配置文件里的问题了,看看端口号是不是3306,不要和tomcat的8080重合,localhost 最好换成127.0.0.1,再次注意后面有没有空格