10.1. 添加Jar包
【mybatis】
mybatis-3.2.0.jar
mybatis-spring-1.1.1.jar
log4j-1.2.17.jar
【spring】
spring-aop-3.2.0.RELEASE.jar
spring-beans-3.2.0.RELEASE.jar
spring-context-3.2.0.RELEASE.jar
spring-core-3.2.0.RELEASE.jar
spring-expression-3.2.0.RELEASE.jar
spring-jdbc-3.2.0.RELEASE.jar
spring-test-3.2.4.RELEASE.jar
spring-tx-3.2.0.RELEASE.jar
aopalliance-1.0.jar
cglib-nodep-2.2.3.jar
commons-logging-1.1.1.jar
【MYSQL驱动包】
mysql-connector-java-5.0.4-bin.jar
10.2. 数据库表
CREATE TABLE s_user(
user_id INT AUTO_INCREMENT PRIMARY KEY,
user_name VARCHAR(30),
user_birthday DATE,
user_salary DOUBLE
)
10.3. 实体类: User
public class User {
private int id;
private String name;
private Date birthday;
private double salary;
//set,get方法
}
10.4. DAO接口: UserMapper (XXXMapper)
public interface UserMapper {
void save(User user);
void update(User user);
void delete(int id);
User findById(int id);
List<User> findAll();
}
10.5. SQL映射文件: 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">
<!-- namespace必须与接口的全类名一致
id:必须与对应接口的某个对应的方法名一致
-->
<mapper namespace="com.spring_mybatis.dao.UserMapper">
<insert id="save" parameterType="User">
insert into s_user(user_name,user_birthday,user_salary)
values(#{name},#{birthday},#{salary})
</insert>
<!-- 参数类型可写可不写,save写了,这里不写,都可以 -->
<update id="update">
update s_user set user_name=#{name},user_birthday=#{birthday},user_salary=#{salary} where user_id=#{id}
</update>
<delete id="delete">
delete from s_user where user_id=#{id}
</delete>
<!-- sql语句用别名的方式 -->
<select id="findById" resultType="com.spring_mybatis.entity.User">
select user_id id,user_name name,user_birthday birthday,user_salary salary from s_user where user_id=#{id}
</select>
<select id="findAll" resultType="com.spring_mybatis.entity.User">
select user_id id,user_name name,user_birthday birthday,user_salary salary from s_user
</select>
</mapper>
10.6. spring的配置文件: beans.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"
xmlns:p="http://www.springframework.org/schema/p"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.2.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-3.2.xsd">
<!-- 1. 数据源 : DriverManagerDataSource
ctrl+shift+T找到类的相关信息,要先关联源码
右键copyQualifiedName复制全类名填入class
-->
<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/mybatis"/>
<property name="username" value="root"/>
<property name="password" value="123456"/>
</bean>
<!--
2. mybatis的SqlSession的工厂: SqlSessionFactoryBean
dataSource:这里 ref="dataSource"就是引用的上面的数据源bean id="dataSource"
typeAliasesPackage:类型别名包,指定实体类的包名,自动扫描实体类的包,把简单类
名映射为别名 com.spring_mybatis.entity.User就可以直接写为User
-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"/>
<property name="typeAliasesPackage" value="com.spring_mybatis.entity"/>
</bean>
<!--
3. mybatis自动扫描加载Sql映射文件/接口 : MapperScannerConfigurer
sqlSessionFactory:引用上面定义的sqlSessionFactory
basePackage:指定sql映射文件/接口所在的包(自动扫描)
-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.spring_mybatis.mapper"/>
<property name="sqlSessionFactory" ref="sqlSessionFactory"/>
</bean>
<!-- 4. 事务管理 : DataSourceTransactionManager ,引用上面定义的数据源-->
<bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>
<!-- 5. 使用声明式事务 ,使用刚才定义的事务管理器-->
<tx:annotation-driven transaction-manager="txManager" />
</beans>
10.7. mybatis的配置文件: mybatis-config.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>
<!-- Spring整合myBatis后,这个配置文件基本可以不要了-->
<!-- 设置外部配置文件 -->
<!-- 设置类别名 -->
<!-- 设置数据库连接环境 -->
<!-- 映射文件 -->
</configuration>
测试类:
@RunWith(SpringJUnit4ClassRunner.class) //使用spring的测试框架
@ContextConfiguration("classpath:beans.xml") //加载spring的配置文件
public class SMTest {
@Autowired
private UserMapper userMapper; //自动注入
@Test
public void testAdd() {
User user = new User(-1,"B",new Date(),12345); //id是自动生成的,设为-1
userMapper.save(user); //userMapper是一个接口,通过它调用在userMapper.xml中配置的方法
}
@Test
public void testUpdate() {
User user = new User(1,"Tom2",new Date(),12345);
userMapper.update(user);
}
public void testDelete() {
userMapper.delete(1);
}
@Test
public void findById() {
User user = userMapper.findById(1);
System.out.println(user);
}
@Test
public void findAll() {
List<User> users = userMapper.findAll();
System.out.println(users);
}
}
【mybatis】
mybatis-3.2.0.jar
mybatis-spring-1.1.1.jar
log4j-1.2.17.jar
【spring】
spring-aop-3.2.0.RELEASE.jar
spring-beans-3.2.0.RELEASE.jar
spring-context-3.2.0.RELEASE.jar
spring-core-3.2.0.RELEASE.jar
spring-expression-3.2.0.RELEASE.jar
spring-jdbc-3.2.0.RELEASE.jar
spring-test-3.2.4.RELEASE.jar
spring-tx-3.2.0.RELEASE.jar
aopalliance-1.0.jar
cglib-nodep-2.2.3.jar
commons-logging-1.1.1.jar
【MYSQL驱动包】
mysql-connector-java-5.0.4-bin.jar
10.2. 数据库表
CREATE TABLE s_user(
user_id INT AUTO_INCREMENT PRIMARY KEY,
user_name VARCHAR(30),
user_birthday DATE,
user_salary DOUBLE
)
10.3. 实体类: User
public class User {
private int id;
private String name;
private Date birthday;
private double salary;
//set,get方法
}
10.4. DAO接口: UserMapper (XXXMapper)
public interface UserMapper {
void save(User user);
void update(User user);
void delete(int id);
User findById(int id);
List<User> findAll();
}
10.5. SQL映射文件: 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">
<!-- namespace必须与接口的全类名一致
id:必须与对应接口的某个对应的方法名一致
-->
<mapper namespace="com.spring_mybatis.dao.UserMapper">
<insert id="save" parameterType="User">
insert into s_user(user_name,user_birthday,user_salary)
values(#{name},#{birthday},#{salary})
</insert>
<!-- 参数类型可写可不写,save写了,这里不写,都可以 -->
<update id="update">
update s_user set user_name=#{name},user_birthday=#{birthday},user_salary=#{salary} where user_id=#{id}
</update>
<delete id="delete">
delete from s_user where user_id=#{id}
</delete>
<!-- sql语句用别名的方式 -->
<select id="findById" resultType="com.spring_mybatis.entity.User">
select user_id id,user_name name,user_birthday birthday,user_salary salary from s_user where user_id=#{id}
</select>
<select id="findAll" resultType="com.spring_mybatis.entity.User">
select user_id id,user_name name,user_birthday birthday,user_salary salary from s_user
</select>
</mapper>
10.6. spring的配置文件: beans.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"
xmlns:p="http://www.springframework.org/schema/p"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.2.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-3.2.xsd">
<!-- 1. 数据源 : DriverManagerDataSource
ctrl+shift+T找到类的相关信息,要先关联源码
右键copyQualifiedName复制全类名填入class
-->
<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/mybatis"/>
<property name="username" value="root"/>
<property name="password" value="123456"/>
</bean>
<!--
2. mybatis的SqlSession的工厂: SqlSessionFactoryBean
dataSource:这里 ref="dataSource"就是引用的上面的数据源bean id="dataSource"
typeAliasesPackage:类型别名包,指定实体类的包名,自动扫描实体类的包,把简单类
名映射为别名 com.spring_mybatis.entity.User就可以直接写为User
-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"/>
<property name="typeAliasesPackage" value="com.spring_mybatis.entity"/>
</bean>
<!--
3. mybatis自动扫描加载Sql映射文件/接口 : MapperScannerConfigurer
sqlSessionFactory:引用上面定义的sqlSessionFactory
basePackage:指定sql映射文件/接口所在的包(自动扫描)
-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.spring_mybatis.mapper"/>
<property name="sqlSessionFactory" ref="sqlSessionFactory"/>
</bean>
<!-- 4. 事务管理 : DataSourceTransactionManager ,引用上面定义的数据源-->
<bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>
<!-- 5. 使用声明式事务 ,使用刚才定义的事务管理器-->
<tx:annotation-driven transaction-manager="txManager" />
</beans>
10.7. mybatis的配置文件: mybatis-config.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>
<!-- Spring整合myBatis后,这个配置文件基本可以不要了-->
<!-- 设置外部配置文件 -->
<!-- 设置类别名 -->
<!-- 设置数据库连接环境 -->
<!-- 映射文件 -->
</configuration>
测试类:
@RunWith(SpringJUnit4ClassRunner.class) //使用spring的测试框架
@ContextConfiguration("classpath:beans.xml") //加载spring的配置文件
public class SMTest {
@Autowired
private UserMapper userMapper; //自动注入
@Test
public void testAdd() {
User user = new User(-1,"B",new Date(),12345); //id是自动生成的,设为-1
userMapper.save(user); //userMapper是一个接口,通过它调用在userMapper.xml中配置的方法
}
@Test
public void testUpdate() {
User user = new User(1,"Tom2",new Date(),12345);
userMapper.update(user);
}
public void testDelete() {
userMapper.delete(1);
}
@Test
public void findById() {
User user = userMapper.findById(1);
System.out.println(user);
}
@Test
public void findAll() {
List<User> users = userMapper.findAll();
System.out.println(users);
}
}