ibatis 查询数据的设置_ibatis控制查询条数-优快云博客

本文链接：https://blog.youkuaiyun.com/xiaxiaorui2003/article/details/6481356

本文介绍使用ibatis进行数据库查询的方法，包括如何查询单条记录及多条记录，并提供了相应的XML配置示例和Java代码实现。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1. ibatis 查询单条数据

XML中设置

view plaincopy to clipboardprint?
<select id="login" parameterClass="User" resultMap="user">
SELECT * FROM users where userName=#userName# and password=#password#
</select>
<select id="login" parameterClass="User" resultMap="user">
SELECT * FROM users where userName=#userName# and password=#password#
</select>

JAVA代码

view plaincopy to clipboardprint?
public User login(User user) throws Exception {
    user = (User) this.getSqlMapClient().queryForObject(
            user.getClass().getName() + ".login", user);
    return user;
}
public User login(User user) throws Exception {
  user = (User) this.getSqlMapClient().queryForObject(
    user.getClass().getName() + ".login", user);
  return user;
}

2. 查询多条数据，返回LIST

XML设置

view plaincopy to clipboardprint?
<select id="registerCheck" parameterClass="User" resultMap="user">
SELECT * FROM users where userName=#userName#
</select>
<select id="registerCheck" parameterClass="User" resultMap="user">
SELECT * FROM users where userName=#userName#
</select>

JAVA代码

view plaincopy to clipboardprint?
List list = (List) this.getSqlMapClient().queryForList(
user.getClass().getName() + ".registerCheck", user);

本文来自优快云博客，转载请标明出处：http://blog.youkuaiyun.com/xiaxiaorui2003/archive/2009/11/24/4867033.aspx