MyBatis之使用注解进行增删改查
1.注意事项
- 我们可以在工具类创建的时候实现事务的自动提交,代码更简洁
public static SqlSession getSqlSession() { return sqlSessionFactory.openSession(true); }
- 💥💥💥必须要将接口注册绑定到我们的核心配置文件中
2.编写接口,增加注解
public interface UserMapper
{
//查询所有
@Select("select * from user")
List<User>getUser();
//根据id查找用户
@Select("select * from user where id = #{id}")
User getUserById(@Param("id") int id);
//添加用户
@Insert("insert into user (username,password) values(#{username},#{pwd})")
int AddUser(User user);
//修改用户
@Update("update user set username = #{username},password = #{pwd} where id =#{id}")
int UpdateUser(User user);
//删除用户
@Delete("delete from user where id = #{id}")
int DelUser(@Param("id") int id);
}
3.测试类
public class UserMapperTest
{
//查询所有
@Test
public void test()
{
//1.获取SqlSession对象
SqlSession sqlSession = MybatisUtils.getSqlSession();
//2.执行SQL
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
List<User> userList = userMapper.getUser();
for (User user : userList)
{
System.out.println(user);
}
//关闭SqlSession
sqlSession.close();
}
//根据id查找
@Test
public void getUserById()
{
//1.获取SqlSession对象
SqlSession sqlSession = MybatisUtils.getSqlSession();
//2.执行SQL
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
User user = userMapper.getUserById(3);
System.out.println(user);
//关闭SqlSession
sqlSession.close();
}
//添加用户
@Test
public void AddUser()
{
//1.获取SqlSession对象
SqlSession sqlSession = MybatisUtils.getSqlSession();
//2.执行SQL
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
int res = userMapper.AddUser(new User("赛文","123456"));
if (res>0)
{
System.out.println("添加成功!");
}
//关闭SqlSession
sqlSession.close();
}
//修改用户
@Test
public void UpdateUser()
{
//1.获取SqlSession对象
SqlSession sqlSession = MybatisUtils.getSqlSession();
//2.执行SQL
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
int res = userMapper.UpdateUser(new User(2,"迪迦奥特曼","556644"));
if (res>0)
{
System.out.println("修改成功!");
}
//关闭SqlSession
sqlSession.close();
}
//删除用户
@Test
public void DelUser()
{
//1.获取SqlSession对象
SqlSession sqlSession = MybatisUtils.getSqlSession();
//2.执行SQL
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
int res = userMapper.DelUser(14);
if (res>0)
{
System.out.println("删除成功!");
}
//关闭SqlSession
sqlSession.close();
}
}
4. 关于@Param()注解的解释
- 基本类型的参数或者String类型,需要加上
- 引用类型不需要加
- 如果只有一个基本类型的话,可以忽略,但是建议大家都加上
- 我们在SQL中引用的就是我们这里的@Param()中设定的属性名
5.扩展延伸之#{}与${}的区别
- #{}是预编译处理,$ {}是字符串替换
- MyBatis在处理#{}时,会将SQL中的#{}替换为?号,使用PreparedStatement的set方法来赋值;MyBatis在处理 $ { } 时,就是把 ${ } 替换成变量的值
- 使用 #{} 可以有效的防止SQL注入,提高系统安全性
OK,今天的学习就结束啦,如果对你有帮助麻烦给个三连(点赞关注加收藏),我是猪猪侠,一个码农,我们在Mybatis06篇再会
往期MyBatis教学地址----->MyBatis文章合集