Mybatis,Ibatis,添加,修改,删除,获得结果集

 Mybatis,Ibatis,添加,修改,删除,获得结果集 

1.获得结果集 

Java代码  

1. <select id="selectUserFromId" parameterType="int" resultType="com.zakisoft.ibt.UserVo">  
2.         select * from user where id = #{id}  
3.     </select>  
4.       
5.     <select id="selectAllUsers" resultType="com.zakisoft.ibt.UserVo">  
6.         select * from user  
7.     </select>  

Java代码  

1. public List<?> selectUserFromId(int id) {  
2.         SqlSession session = sqlSessionFactory.openSession();  
3.         List<?> users = null;  
4.         try {  
5.             UserOp mapper = session.getMapper(UserOp.class);  
6.             users = mapper.selectUserFromId(id);  
7.             if (0 < users.size()) {  
8.                 UserVo user = (UserVo) users.get(0);  
9.                 System.out.println("Get User Name: " + user.getName());  
10.             }  
11.         } finally {  
12.             session.close();  
13.         }  
14.         return users;  
15.     }  
16.   
17.     public List<?> selectAllUsers() {  
18.         SqlSession session = sqlSessionFactory.openSession();  
19.         try {  
20.             UserOp mapper = session.getMapper(UserOp.class);  
21.             List<?> users = mapper.selectAllUsers();  
22.             if (0 < users.size()) {  
23.                 UserVo user;  
24.                 for (int i = 0; i < users.size(); i++) {  
25.                     user = (UserVo) users.get(i);  
26.                     System.out.println("User Id:" + user.getId() + " --- "  
27.                             + "User Name:" + user.getName());  
28.                 }  
29.             }  
30.         } finally {  
31.             session.close();  
32.         }  
33.         return null;  
34.     }  

2.添加数据  

Java代码  

1. <insert id="insertNewOneUser" keyProperty="id" parameterType="com.zakisoft.ibt.UserVo" useGeneratedKeys="true">  
2.         insert into user (name, password) values (#{name},#{password})  
3.     </insert>  

Java代码  

1. public int insertNewOneUser(UserVo user) {  
2.         user = new UserVo();  
3.         user.setName("username: " + new Random().nextInt());  
4.         user.setPassword("passowrd: " + new Random().nextInt());  
5.   
6.         SqlSession session = sqlSessionFactory.openSession();  
7.         int count = 0;  
8.         try {  
9.             UserOp mapper = session.getMapper(UserOp.class);  
10.             count = mapper.insertNewOneUser(user);  
11.             System.out.println("count: " + count);  
12.             // 请注意一定需要提交。  
13.             session.commit();  
14.         } finally {  
15.             session.close();  
16.         }  
17.   
18.         return count;  
19.     }  

3.更新数据  

Java代码  

1. <update id="updateUser" parameterType="com.zakisoft.ibt.UserVo">  
2.         update user set name = #{name}, password = #{password} where id = #{id}  
3.     </update>  

Java代码  

1. public int updateUser(UserVo user){  
2.         SqlSession session = sqlSessionFactory.openSession();  
3.         int count = 0;  
4.         try {  
5.             UserOp mapper = session.getMapper(UserOp.class);  
6.             count = mapper.updateUser(user);  
7.             System.out.println("count: " + count);  
8.             // 请注意一定需要提交。  
9.             session.commit();  
10.         } finally {  
11.             session.close();  
12.         }  
13.         return count;  
14.     }  

4.删除数据  

Java代码  

1. <delete id="deleteUserById" parameterType="int">  
2.         delete from user where id = #{id}  
3.     </delete>  

Java代码  

1. public int deleteUserById(int id){  
2.         SqlSession session = sqlSessionFactory.openSession();  
3.         int count = 0;  
4.         try {  
5.             UserOp mapper = session.getMapper(UserOp.class);  
6.             count = mapper.deleteUserById(id);  
7.             System.out.println("count: " + count);  
8.             // 请注意一定需要提交。  
9.             session.commit();  
10.         } finally {  
11.             session.close();  
12.         }  
13.         return count;  
14.     }  

5.源码和例子下载 
http://www.zakisoft.com/?p=85