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