MyBatis注解之增删改查（CRUD）

1、Mapper接口
在接口中声明的方法上，加上注解。
对比配置文件Category.xml，其实就是把SQL语句从XML挪到了注解上来。

public interface CategoryMapper {

    @Insert(" insert into category_ ( name ) values (#{name}) ") 
    public int add(Category category); 

    @Delete(" delete from category_ where id= #{id} ") 
    public void delete(int id); 

    @Select("select * from category_ where id= #{id} ") 
    public Category get(int id); 

    @Update("update category_ set name=#{name} where id=#{id} ") 
    public int update(Category category);  

    @Select(" select * from category_ ") 
    public List<Category> list(); 
}

2、matbayis-config.xml

<mappers>
        <mapper class="com.how2java.mapper.CategoryMapper"/> 
    </mappers>

3、Test类

public class TestMybatis {
    public static void main(String[] args) throws IOException {
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        SqlSession session = sqlSessionFactory.openSession();
        CategoryMapper mapper = session.getMapper(CategoryMapper.class);

//        add(mapper);
//        delete(mapper);
//        get(mapper);
//        update(mapper);

        listAll(mapper);      
        session.commit();
        session.close();
    }

    private static void update(CategoryMapper mapper) {
        Category c= mapper.get(8);
        c.setName("修改了的Category名稱");
        mapper.update(c);
        listAll(mapper);
    }

    private static void get(CategoryMapper mapper) {
        Category c= mapper.get(8);
        System.out.println(c.getName());
    }

    private static void delete(CategoryMapper mapper) {
        mapper.delete(2);
        listAll(mapper);
    }

    private static void add(CategoryMapper mapper) {
        Category c = new Category();
        c.setName("新增加的Category");
        mapper.add(c);
        listAll(mapper);
    }

    private static void listAll(CategoryMapper mapper) {
        List<Category> cs = mapper.list();
        for (Category c : cs) {
            System.out.println(c.getName());
        }
    }
}

之前的xml