Mybatis,Ibatis,添加,修改,删除,获得结果集
来源:互联网 发布:java response json 编辑:程序博客网 时间:2024/05/16 03:55
Mybatis,Ibatis,添加,修改,删除,获得结果集
1.获得结果集
- <select id="selectUserFromId" parameterType="int" resultType="com.zakisoft.ibt.UserVo">
- select * from user where id = #{id}
- </select>
- <select id="selectAllUsers" resultType="com.zakisoft.ibt.UserVo">
- select * from user
- </select>
- public List<?> selectUserFromId(int id) {
- SqlSession session = sqlSessionFactory.openSession();
- List<?> users = null;
- try {
- UserOp mapper = session.getMapper(UserOp.class);
- users = mapper.selectUserFromId(id);
- if (0 < users.size()) {
- UserVo user = (UserVo) users.get(0);
- System.out.println("Get User Name: " + user.getName());
- }
- } finally {
- session.close();
- }
- return users;
- }
- public List<?> selectAllUsers() {
- SqlSession session = sqlSessionFactory.openSession();
- try {
- UserOp mapper = session.getMapper(UserOp.class);
- List<?> users = mapper.selectAllUsers();
- if (0 < users.size()) {
- UserVo user;
- for (int i = 0; i < users.size(); i++) {
- user = (UserVo) users.get(i);
- System.out.println("User Id:" + user.getId() + " --- "
- + "User Name:" + user.getName());
- }
- }
- } finally {
- session.close();
- }
- return null;
- }
2.添加数据
- <insert id="insertNewOneUser" keyProperty="id" parameterType="com.zakisoft.ibt.UserVo" useGeneratedKeys="true">
- insert into user (name, password) values (#{name},#{password})
- </insert>
- public int insertNewOneUser(UserVo user) {
- user = new UserVo();
- user.setName("username: " + new Random().nextInt());
- user.setPassword("passowrd: " + new Random().nextInt());
- SqlSession session = sqlSessionFactory.openSession();
- int count = 0;
- try {
- UserOp mapper = session.getMapper(UserOp.class);
- count = mapper.insertNewOneUser(user);
- System.out.println("count: " + count);
- // 请注意一定需要提交。
- session.commit();
- } finally {
- session.close();
- }
- return count;
- }
3.更新数据
- <update id="updateUser" parameterType="com.zakisoft.ibt.UserVo">
- update user set name = #{name}, password = #{password} where id = #{id}
- </update>
- public int updateUser(UserVo user){
- SqlSession session = sqlSessionFactory.openSession();
- int count = 0;
- try {
- UserOp mapper = session.getMapper(UserOp.class);
- count = mapper.updateUser(user);
- System.out.println("count: " + count);
- // 请注意一定需要提交。
- session.commit();
- } finally {
- session.close();
- }
- return count;
- }
4.删除数据
- <delete id="deleteUserById" parameterType="int">
- delete from user where id = #{id}
- </delete>
- public int deleteUserById(int id){
- SqlSession session = sqlSessionFactory.openSession();
- int count = 0;
- try {
- UserOp mapper = session.getMapper(UserOp.class);
- count = mapper.deleteUserById(id);
- System.out.println("count: " + count);
- // 请注意一定需要提交。
- session.commit();
- } finally {
- session.close();
- }
- return count;
- }
5.源码和例子下载
http://www.zakisoft.com/?p=85
0 0
- Mybatis,Ibatis,添加,修改,删除,获得结果集
- Mybatis/Ibatis例子(添加,修改,删除)
- Ibatis批量添加修改删除方法
- myBatis批量添加,修改和删除
- myBatis批量添加,修改和删除
- myBatis批量添加,修改和删除
- myBatis批量添加,修改和删除
- myBatis批量添加,修改和删除
- MyBatis批量添加,修改和删除
- myBatis批量添加,修改和删除
- myBatis批量添加,修改和删除
- myBatis批量添加,修改和删除
- Mybatis中批量添加、修改、删除
- myBatis批量添加,修改和删除
- myBatis批量添加,修改和删除
- myBatis批量添加,修改和删除
- myBatis批量添加,修改和删除
- mybatis 中的批量添加、删除、修改
- SQL Server-聚焦事务对本地变量、临时表、表变量影响以及日志文件存满时如何收缩(三十一)
- CMS,全称Concurrent Low Pause Collector gc
- poj 1651Multiplication Puzzle dp
- 关关于android 微信sdk 分享 图片 到 朋友圈 的问题
- JAVA多线程通信之wait和notify的使用
- Mybatis,Ibatis,添加,修改,删除,获得结果集
- 三门问题
- 琐碎资料
- 希尔排序(Shell Sort)
- 莫对算法
- 数位dp 洛谷P2602 [ZJOI2010]数字计数
- codeforces 4c Registration system 字符串 map应用
- 基础数学算法
- Minor GC、Major GC和Full GC之间的区别