10_mybatis与Spring的整合

CREATE TABLE s_user(
	user_id INT AUTO_INCREMENT PRIMARY KEY,
	user_name VARCHAR(30),
	user_birthday DATE,
	user_salary DOUBLE
)

public class User {
	private int id;
	private String name;
	private Date birthday;
	private double salary;
...
}

• get/set方法
• 有参数构造方法和无参数的构造方法
• toString方法

4 Dao接口:UserMapper

public interface UserMapper {
	void save(User user);
	void update(User user);
	void delete(int id);
	User findById(int id);
	List<User> findAll();
}

<mapper namespace="cn.imentor.mybatis.mapper.UserMapper">
	<resultMap type="User" id="userResult">
		<result column="user_id" property="id"/>
		<result column="user_name" property="name"/>
		<result column="user_birthday" property="birthday"/>
		<result column="user_salary" property="salary"/>
	</resultMap>
	<!-- 取得插入数据后的id -->
	<insert id="save" keyColumn="user_id" keyProperty="id" useGeneratedKeys="true">
		insert into s_user(user_name,user_birthday,user_salary)
		values(#{name},#{birthday},#{salary})
	</insert>
	<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>
	<select id="findById" resultMap="userResult">
		select * from s_user where user_id = #{id}
	</select>
	
	<select id="findAll" resultMap="userResult">
		select * 
		from s_user
	</select>
</mapper>

<?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">
</beans>

<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="root"/>
</bean>

<!--2. mybatis的SqlSession的工厂: SqlSessionFactoryBean 
    两个属性：dataSource ：数据源
     typeAliasesPackage：实体文件存储的包，别名为类的名称
-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
	<property name="dataSource" ref="datasource"/>
	<property name="typeAliasesPackage" value="cn.imentor.mybatis.bean"/>
</bean>

<bean id="mapperConfig" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<property name="basePackage" value="cn.imentor.mybatis.mapper"/>
		<property name="sqlSessionFactory" ref="sqlSessionFactory"/>
</bean>

• 配置的class:org.mybatis.spring.mapper.MapperScannerConfigurer
• sqlSessionFactory:引用上面的定义的sessionFactory
  
•  basePackage：指定sql映射文件和接口所在包（自动扫描）
  

<!-- 4. 事务管理 : DataSourceTransactionManager 
			dataSource:数据源
		-->
		<bean id="manager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
			<property name="dataSource" ref="datasource"/>
		</bean>

• datasource:上面定义的数据源
  

6.6 使用声明式事务：transaction-manager

<!-- 5. 使用声明式事务 ：transaction-manager-->
<tx:annotation-driven transaction-manager="manager" />

<?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("/bean.xml")	//加载spring配置文件：bean.xml
public class SMTest {
	@Autowired //自动注入
    private UserMapper userMapper;
}

@Test
public void  testAdd() {
	User user = new User(-1, "tom", new Date(), 1234);
	userMapper.save(user);
	int id = user.getId();
	System.out.println(id);
}