Mybatsi注解开发-基础操作

1.导入坐标

<dependency>

      <groupId>com.github.pagehelper</groupId>

      <artifactId>pagehelper</artifactId>

      <version>3.7.5</version>

    </dependency>

    <dependency>

<!--      解析器-->

      <groupId>com.github.jsqlparser</groupId>

      <artifactId>jsqlparser</artifactId>

      <version>0.9.1</version>

    </dependency>

2.创建实体类User

public class User {

    private int id;

    private String username;

    private String password;

    private Date birthday;

    public Date getBirthday() {

        return birthday;

    }

    public void setBirthday(Date birthday) {

        this.birthday = birthday;

    }

    public int getId() {

        return id;

    }

    public void setId(int id) {

        this.id = id;

    }

    public String getUsername() {

        return username;

    }

    public void setUsername(String username) {

        this.username = username;

    }

    public String getPassword() {

        return password;

    }

    public void setPassword(String password) {

        this.password = password;

    }

    @Override

    public String toString() {

        return "User{" +

                "id=" + id +

                ", username='" + username + '\'' +

                ", password='" + password + '\'' +

                ", birthday=" + birthday +

                '}';

    }

}

3.创建UserMapper（dao）接口

public interface UserMapper {

    @Insert("insert into user values(#{id},#{username},#{password},#{birthday})")

    public void save(User user);

    @Update("update user set  username=#{username},password=#{password},birthday=#{birthday} where id=#{id}")

    public void update(User user);

    @Delete("delete from user where id=#{id}")

    public void delete(int id);

    @Select("select * from user where id=#{id}")

    public User findById(int id);

    @Select("select * from user")

    public List<User> findAll();

}

4.配置Mybatis核心配置文件SqlMapConfig.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>

<!--    加载jdbc.properties配置文件-->

    <properties resource="jdbc.properties"/>

<!--    定义别名-->

    <typeAliases>

        <typeAlias type="com.hao.domain.User" alias="user"/>

    </typeAliases>

    <!--    配置数据源环境-->

    <environments default="development"><!-- 表示默认情况下使用id为development的环境-->

        <environment id="development">

            <transactionManager type="JDBC"></transactionManager>

            <dataSource type="POOLED">

                <property name="driver" value="${jdbc.driver}"/>

                <property name="url" value="${jdbc.url}"/>

                <property name="username" value="${jdbc.username}"/>

                <property name="password" value="${jdbc.password}"/>

            </dataSource>

        </environment>

    </environments>

<!--    加载映射关系-->

    <mappers>

<!--        指定接口所在的包-->

        <package name="com.hao.mapper"/>

    </mappers>

</configuration>

5.测试

public class MapperTest {

    private UserMapper userMapper;

    @Before

    public void before() throws IOException {

        InputStream stream = Resources.getResourceAsStream("SqlMapConfig.xml");

        SqlSessionFactory build = new SqlSessionFactoryBuilder().build(stream);

        SqlSession sqlSession = build.openSession(true);

        userMapper = sqlSession.getMapper(UserMapper.class);

    }

    @Test

    public void testSave(){

        User user=new User();

        user.setUsername("tom");

        user.setPassword("123");

        userMapper.save(user);

    }

    @Test

    public void testUpdate(){

        User user = new User();

        user.setId(2);

        user.setUsername("dou");

        user.setPassword("bi");

        userMapper.update(user);

    }

    @Test

    public void testDelete(){

        User user = new User();

        userMapper.delete(3);

    }

    @Test

    public void testFindById(){

        User user=userMapper.findById(2);

        System.out.println(user);

    }

    @Test

    public void testFindAll(){

        List<User> list = userMapper.findAll();

        for (User user : list) {

            System.out.println(user);

        }

    }

}

6.结果