接口:无需接口.xml配置文件 及lombok jar包
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.16.16</version>
</dependency>
package com.yyf.dao;
import com.yyf.pojo.User;
import org.apache.ibatis.annotations.*;
import java.util.List;
import java.util.Map;
public interface UserMapper {
@Select ("select * from user")
List<User> getUsers();
@Insert ("insert into user (id,name,pwd) values (#{id},#{name},#{pwd})")
int insertUser(User user);
@Update("update user set name=#{name},pwd=#{pwd} where id=#{id}")
int updateUser(User user);
@Delete ("delete from user where id=#{id1}")
int deleteUser(@Param ("id1") int id);
}
测试类:无需进行事务提交
import com.yyf.dao.UserMapper;
import com.yyf.pojo.User;
import com.yyf.utils.mybatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;
import java.util.List;
public class UserDaoTest {
@Test
public void test(){
SqlSession sqlSession = mybatisUtils.getSqlSession ();
UserMapper mapper = sqlSession.getMapper (UserMapper.class);
int i = mapper.deleteUser (6);
System.out.println ("删除成功");
// int to = mapper.updateUser (new User (4, "to", "123123"));
// System.out.println ("更新成功");
sqlSession.close ();
}
}