mybatis的CRUD(注解版)

mybatis注解实现CRUD

接上：

1.User表及实体类、工具类、配置文件config.xml

2.建立接口UserMapper.java

package com.mybits_01.test2;

import java.util.List;

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 com.mybits_01.test1.User;

public interface UserMapper {

@Insert("insert into users(name, age) values(#{name},#{age})")

public int add(User user);

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

public int deleteById(int id);

@Update("update users set name=#{name},age=#{age} where id=#{id}")

public int update(User user);

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

public User findById(int id);

@Select("select * from users")

public List<User> findAll();

}

3在config中注册UserMapper

<mappers>

<mapper class="com.mybits_01.test3.UserMapper"/>

</mappers>

4.编写测试类

package com.mybits_01.test3;

import org.apache.ibatis.session.SqlSession;

import org.junit.Test;

import com.mybits_01.test1.User;

import com.mybits_01.util.MybatisUtil;

public class Test3 {

@Test

public void testAdd2() {

SqlSession session = MybatisUtil.getSession();

UserMapper userMap =  session.getMapper(UserMapper.class);

int n = userMap.add(new User(-1, "SS", 22));

System.out.println(n);

session.commit();

session.close();

}

}