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

2019-11-08 02:50:58

字体：大中小

来源：转载

供稿：网友

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

上一篇：三门问题

下一篇：Eclipse / MyEclipse中断点调试的基本使用