Mybatis,Ibatis,添加,修改,刪除,獲得結果集
1.獲得結果集
java代碼
<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> Java代碼 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.添加數據 Java代碼 <insert id="insertNewOneUser" keyProperty="id" parameterType="com.zakisoft.ibt.UserVo" useGeneratedKeys="true"> insert into user (name, passWord) values (#{name},#{password}) </insert> Java代碼 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.更新數據 Java代碼 <update id="updateUser" parameterType="com.zakisoft.ibt.UserVo"> update user set name = #{name}, password = #{password} where id = #{id} </update> Java代碼 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.刪除數據 Java代碼 <delete id="deleteUserById" parameterType="int"> delete from user where id = #{id} </delete> Java代碼 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新聞熱點
疑難解答
