MyBatis的注解开发

先实现一些简单的增删改查 

新建一个工程项目

只有实体类 user  接口 Userpammer 和Mybatis核心配置文件

接下来编写代码

在接口的方法上面直接加上注解实现SQL语句

package com.cong.mapper;


import com.cong.pojo.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 UserMapper {
    @Select(" select * from tb_user")
    public List<User> findAll();

    @Insert("insert into tb_user values (#{id},#{username},#{password})")
    public void save(User user);

    @Update("update tb_user set username=#{username},password=#{password} where id=#{id}")
    public void update(User user);

    @Delete("delete from tb_user where id=#{id}")
    public User findById(int id);
}

测试 先来抽取一下公共代码 用注解@before

private UserMapper userMapper;
    @Before
    public void before() throws IOException {
        InputStream resourceAsStream = Resources.getResourceAsStream("mybatis-config.xml");
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
        SqlSession sqlSession = sqlSessionFactory.openSession(true);
        userMapper = sqlSession.getMapper(UserMapper.class);
    }

 

测试

package com.cong.test;

import com.cong.mapper.UserMapper;
import com.cong.pojo.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.Before;

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


public class Test {
    private UserMapper userMapper;
    @Before
    public void before() throws IOException {
        InputStream resourceAsStream = Resources.getResourceAsStream("mybatis-config.xml");
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
        SqlSession sqlSession = sqlSessionFactory.openSession(true);
        userMapper = sqlSession.getMapper(UserMapper.class);
    }
    @org.junit.Test
    public void test01(){
        List<User> all = userMapper.findAll();
        for (User user : all) {
            System.out.println(user);
        }
    }

    @org.junit.Test
    public void test02(){
        User user = new User();
        user.setUsername("ll");
        user.setPassword("132");
        userMapper.save(user);
    }

}