Mybatis学习笔记-CURD(基于注解的方式)
来源:互联网 发布:sql查询分析器下载 编辑:程序博客网 时间:2024/05/18 03:20
User.java实体类
public class User {private int id;private String username;private int age;//..}
UserMapper.java接口
public interface UserMapper {@Insert("insert into users(username, age) values(#{username}, #{age})")public int insertUser(User user);@Delete("delete from users where id = #{id}")public int deleteUserById(int id);@Update("update users set username = #{username}, age = #{age} where id = #{id}")public int updateUser(User user);@Select("select * from users where id = #{id}")public User getUserById(int id);@Select("select * from users")public List<User>getAllUser();}
将接口类注册到conf.xml文件中
<mappers><mapper class="com.mybatis.test01.UserMapper"/></mappers>
测试方法
@Testpublic void testInsert() {SqlSessionFactory factory = MybatisUtil.getFactory();SqlSession session = factory.openSession(true);UserMapper mapper = session.getMapper(UserMapper.class);User user = new User();user.setUsername("test01");user.setAge(22);int insert = mapper.insertUser(user);System.out.println(insert);session.close();}@Testpublic void testDelete() {SqlSessionFactory factory = MybatisUtil.getFactory();SqlSession session = factory.openSession(true);UserMapper mapper = session.getMapper(UserMapper.class);int delete = mapper.deleteUserById(3);System.out.println(delete);session.close();}@Testpublic void testUpdate() {SqlSessionFactory factory = MybatisUtil.getFactory();SqlSession session = factory.openSession(true);UserMapper mapper = session.getMapper(UserMapper.class);User user = new User();user.setUsername("umgsai");user.setAge(25);user.setId(2);int update = mapper.updateUser(user);System.out.println(update);session.close();}@Testpublic void testSelect() {SqlSessionFactory factory = MybatisUtil.getFactory();SqlSession session = factory.openSession(true);UserMapper mapper = session.getMapper(UserMapper.class);User user = mapper.getUserById(2);System.out.println(user);session.close();}@Testpublic void testSelectAll(){SqlSessionFactory factory = MybatisUtil.getFactory();SqlSession session = factory.openSession(true);UserMapper mapper = session.getMapper(UserMapper.class);List<User>users = mapper.getAllUser();System.out.println(users);session.close();}
本文出自 “优赛工作室” 博客,请务必保留此出处http://shamrock.blog.51cto.com/2079212/1559084
0 0
- Mybatis学习笔记-CURD(基于注解的方式)
- Mybatis学习笔记-CURD(基于配置文件的方式)
- Mybatis注解方式实现CURD
- Spring4学习笔记-AOP(基于注解的方式)
- SpringMVC学习笔记(二):基于注解的方式
- Mybatis学习笔记(三)-使用Mybatis完成CURD
- Mybatis XML和接口注解 两种方式CURD
- Spring4学习笔记-声明式事务(基于注解的方式)
- 基于注解的mybatis
- 基于注解的mybatis
- 基于注解的mybatis
- 基于注解的mybatis
- 基于全注解方式实现MyBatis链接数据库的demo
- MyBatis学习笔记:基于xml和注解对表的基本操作
- Mybatis的CRUD操作(基于注解)
- mybatis学习笔记(二)-- 使用mybatisUtil工具类体验基于xml和注解实现
- MyBatis第二讲学习笔记 ,使用MyBatis对表执行增删改查操作——基于注解的实现
- springMVC学习笔记七(基于注解方式的控制器的数据验证,类型转换和格式化)
- Spring4学习笔记-Spring4整合Struts2(基于配置文件的方式)
- android selector用法
- Spring4学习笔记-Spring4整合Hibernate4
- Mybatis学习笔记-入门
- Mybatis学习笔记-CURD(基于配置文件的方式)
- Mybatis学习笔记-CURD(基于注解的方式)
- Mybatis学习笔记-一对一关联
- Mybatis学习笔记-一对多关联
- Mybatis学习笔记-动态SQL与模糊查询
- Mybatis学习笔记-调用存储过程
- Mybatis学习笔记-一级缓存与二级缓存
- HDU 2509 Be the Winner (Nim博弈)
- Mybatis学习笔记-Mybatis与Spring的整合
- Ajax学习笔记-入门笔记