Mybatis/Ibatis例子(添加,修改,删除,获得结果集)

最新推荐文章于 2025-09-22 13:08:28 发布

原创最新推荐文章于 2025-09-22 13:08:28 发布 · 146 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#iBATIS #Java

本文通过具体示例介绍了如何使用 MyBatis 框架进行数据的增删改查操作，包括 SQL 映射文件配置及 Java 代码实现。

[b]关键词： Mybatis,Ibatis,添加,修改,删除,获得结果集[/b]

[b]1.获得结果集[/b]


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

[b]2.添加数据[/b]


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

[b]3.更新数据[/b]


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

[b]4.删除数据[/b]


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