mybatis 注解开发

---------------mybatis configuration 配置文件------------------

<?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>
    <properties resource="jdbcConfig.properties"></properties>

    <environments default="mysql">
        <environment id="mysql">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driver}"></property>
                <property name="url" value="${jdbc.url}"></property>
                <property name="username" value="${jdbc.username}"></property>
                <property name="password" value="${jdbc.password}"></property>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper class="com.sealong.dao.IUserDao"></mapper>
    </mappers>
</configuration>

------------------------------实体类文件User -------------------------

package com.sealong.domain;

import java.io.Serializable;
import java.util.Date;

public class User implements Serializable{
    private Integer id ;
    private String username;
    private String address;
    private String sex;
    private Date birthday;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public Date getBirthday() {
        return birthday;
    }

    public void setBirthday(Date birthday) {
        this.birthday = birthday;
    }

    @Override
    public String toString() {
        final StringBuffer sb = new StringBuffer("User{");
        sb.append("id=").append(id);
        sb.append(", username='").append(username).append('\'');
        sb.append(", address='").append(address).append('\'');
        sb.append(", sex='").append(sex).append('\'');
        sb.append(", birthday=").append(birthday);
        sb.append('}');
        return sb.toString();
    }
}

----------------------------------dao文件-----------------------------

package com.sealong.dao;

import com.sealong.domain.User;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;

public interface IUserDao {
    /**
     * 查询所有用户
     * @return
     */
    @Select("select * from user")
    List<User> findAll();

    /**
     * 保存用户
     * @param user
     */
    @Insert("insert into user(username,address)values(#{username},#{address})")
    void saveUser(User user);

    /**
     * 更新用户
     * @param user
     */
    @Update("update user set username=#{username},address=#{address},sex=#{sex},birthday=#{birthday} where id =#{id}")
    void updateUser(User user);

    /**
     * 通过用户Id查找一个用户
     * @param userId
     * @return
     */
    @Select("select * from user where id = #{id}")
    User findOneById(Integer userId);

    /**
     * 根据userID删除一个用户
     * @param userId
     */
    @Delete("delete from user where id = #{id}")
    void deleteUser(Integer userId);

}
---------------------------------测试类---------------------------------

package com.sealong.dao;

import com.sealong.domain.User;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;

import java.io.InputStream;
import java.util.Date;
import java.util.List;

import static org.junit.Assert.*;

public class IUserDaoTest {
    InputStream inputStream;
    SqlSessionFactory factory;
    SqlSession sqlSession;
    IUserDao dao;

    @Before
    public void open() throws Exception {
        inputStream = Resources.getResourceAsStream("SqlMapConfig.xml");
        factory = new SqlSessionFactoryBuilder().build(inputStream);

        sqlSession = factory.openSession(true);
        dao = sqlSession.getMapper(IUserDao.class);
    }

    @Test
    public void findAll() {
        List<User> users = dao.findAll();
        for (User user : users) {
            System.out.println(user);
        }
    }

    @Test
    public void saveUser() {
        User user = new User();
        user.setUsername("小黄狗");
        user.setAddress("狗窝");
        dao.saveUser(user);
    }

    @Test
    public void updateUser() {
        User user = new User();
        user.setId(21);
        user.setUsername("小黄牛");
        user.setAddress("牛棚");
        user.setSex("男");
        user.setBirthday(new Date());
        dao.updateUser(user);
    }

    @Test
    public void findOneById() {
        User user = dao.findOneById(12);
        System.out.println(user);
    }

    @Test
    public void deleteUser() {
        dao.deleteUser(21);
    }
    @After
    public void destory() throws Exception {
        sqlSession.commit();
        sqlSession.close();
        inputStream.close();
    }
}