Mybatis/Ibatis例子(添加,修改,删除,获得结果集)
关键词： 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 1 楼 bubiaiyou 2011-09-14 请问,你用Mapper时 更新和添加都成功么
为什么我这里都不可以呢 你知道什么原因么
2 楼 bubiaiyou 2011-09-14 兄弟,你的demo写的是swing 只有一个配置文件是Mybatis的 ,
忽悠人的 3 楼 bubiaiyou 2011-09-14 不过我还是对你的这些更新 和添加 感兴趣,希望你能帮我一下,
bubiaiyou@msn.cn 这是我的邮箱 有时间帮帮我 4 楼 午饭OTZ 2012-04-25 浅显易懂非常感谢，转到我空间了，会在开篇说明出处