Spring(五）：使用mybatis

一.增加Dao接口和xml映射文件
UserDao.java

package spittr.dao;

import spittr.data.User;
public interface UserDao {
    public User getUserByName(String name);

    public void addUser(User user);

    public void  deleteUser(String name);
}

UserDao.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="spittr.dao.UserDao">  
<select id="getUserByName"  resultType="spittr.data.User">  
    SELECT name, password, date  FROM user WHERE name=#{name}
</select>  
<insert id="addUser" parameterType="spittr.data.User" flushCache="true">  
   INSERT INTO user (name,password,date) VALUES (#{name},#{password}, #{date})  
</insert>  
<delete id="deleteUser" >  
    DELETE FROM user WHERE name=#{name}  
</delete>  
</mapper>

建表

create table `user`(
`name` varchar(32) DEFAULT NULL,
`password` varchar(32) DEFAULT NULL,
`update_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP'
)

二.增加mybatis相关的bean配置
在application-config.xml中配置bean jdbcDataSource、sqlSessionFactory、userDao

<?xml version="1.0" encoding="UTF-8"?>
<beans  
    xmlns="http://www.springframework.org/schema/beans"  
    xmlns:tx="http://www.springframework.org/schema/tx"  
    xmlns:p="http://www.springframework.org/schema/p"  
    xmlns:aop="http://www.springframework.org/schema/aop"   
    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-4.0.xsd   
    http://www.springframework.org/schema/tx   
    http://www.springframework.org/schema/tx/spring-tx-4.0.xsd">
<!-- 配置数据源-->  
    <bean id="jdbcDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">  
    <property name="driverClassName">  
        <value>org.gjt.mm.mysql.Driver</value>  
    </property>  
    <property name="url">  
        <value>jdbc:mysql://localhost:3306/test?useUnicode=true&amp;characterEncoding=UTF-8</value>  
       <!--本地数据库  -->
    </property>  
    <property name="username">  
        <value>root</value>  
    </property>  
    <property name="password">  
        <value>testtest</value>  
    </property>  
</bean>  
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">  
    <property name="dataSource" ref="jdbcDataSource" />  
    <property name="mapperLocations" value="classpath:spittr/dao/UserDao.xml"/>
</bean>  


<bean id="userDao" class="org.mybatis.spring.mapper.MapperFactoryBean">  
    <property name="mapperInterface" value="spittr.dao.UserDao"></property>  
    <property name="sqlSessionFactory" ref="sqlSessionFactory"></property>  
</bean>  

</beans>

修改RootConfig.java，增加注解@ImportResource(“classpath:application-config.xml”)，在java config中导入xml配置；

三.修改控制器代码

@Autowired 
    private ApplicationContext  applicationContext;
........
    @RequestMapping(value="/register", method=POST)
    public String registerUser(String name,  String password){
        User user = new User(name, password, new Date());

        UserDao userDao = (UserDao)applicationContext.getBean("userDao");
        userDao.addUser(user);
        return "redirect:/registerok/"+user.getName();
    }

三.测试
增加用户：

查询用户信息：