ibatis 查詢資料的設定

 1. ibatis 查詢單條資料

XML中設定

<select id="login" parameterClass="User" resultMap="user"><br />SELECT * FROM users where userName=#userName# and password=#password#<br /></select>

JAVA代碼

public User login(User user) throws Exception {<br />user = (User) this.getSqlMapClient().queryForObject(<br />user.getClass().getName() + ".login", user);<br />return user;<br />} 

 

2. 查詢多條資料，返回LIST 

XML設定

<select id="registerCheck" parameterClass="User" resultMap="user"><br />SELECT * FROM users where userName=#userName#<br /></select>

 

JAVA代碼

List list = (List) this.getSqlMapClient().queryForList(<br />user.getClass().getName() + ".registerCheck", user);