public class CategoryMapperTest {

    private static final Logger logger = LoggerFactory.getLogger(CategoryMapperTest.class);

    public static void main(String[] args) {

        SqlSession session = null;

        try {
            String resource = "mybatis.xml";
            InputStream inputStream = Resources.getResourceAsStream(resource);
            SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
            session = sqlSessionFactory.openSession();
            CategoryMapper categoryMapper = session.getMapper(CategoryMapper.class);

            System.out.println("显示");
            listAll(categoryMapper);

            System.out.println("增加");
            saveCategory(categoryMapper);

            System.out.println("删除");
            deleteCategory(categoryMapper, 1);

            System.out.println("修改");
            updateCategory(categoryMapper);
            logger.info("SOSOSOS");

        } catch (IOException e) {
            e.printStackTrace();
        } finally {

            session.commit();
            session.close();

        }


    }

    /**
     * 查询
     * @param categoryMapper
     * @return
     */

    public static List<Category> listAll(CategoryMapper categoryMapper) {

        List<Category> categories = categoryMapper.listCategory();
        for (Category category : categories
                ) {
            System.out.println(category.getId()+"--------->"+category.getName());

        }
        return categories;
    }

    /**
     * 更新
     * @param categoryMapper
     *
     */
    public static void updateCategory(CategoryMapper categoryMapper) {

        Category category2 = new Category();
        category2.setId(1);
        category2.setName("修category");
        categoryMapper.updateCategory(category2);
        listAll(categoryMapper);
    }

    /**
     * 删除
     * @param categoryMapper
     * @param id
     */
    public static void deleteCategory(CategoryMapper categoryMapper, Integer id) {


        categoryMapper.deleteCategory(id);
        listAll(categoryMapper);
    }

    /**
     * 增加
     *
     * @param categoryMapper
     *
     */
    public static void saveCategory(CategoryMapper categoryMapper) {
        Category category = new Category();
        category.setId(5);
        category.setName("NAMECATEGORY");
        categoryMapper.addCategory(category);
        listAll(categoryMapper);
    }



}

public interface CategoryMapper {


    @Insert("INSERT INTO category_ (name) values(#{name})")
    void addCategory(Category category);

    @Update("UPDATE category_ SET name=#{name} WHERE id=#{id}")
    void updateCategory(Category category);

    @Delete("DELETE FROM category_ WHERE id=#{id}")
    void deleteCategory(Integer id);

    @Select("SELECT * FROM category_ WHERE id=#{id}")
    void get(Integer id);

    @Select("SELECT * FROM category_")
    List<Category> listCategory();




}

实现对数据库的增删改查经典操作