Mybatis/Ibatis例子(添加,修改,删除)

来源：互联网发布：淘宝客定向推广计划编辑：程序博客网时间：2024/06/05 09:01

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代码

<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;      }

3.添加数据
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;      }

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;      }

0 0