user.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap
PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap>
<typeAlias alias="user" type="com.test.pojo.User" />
<insert id="insertUser" parameterClass="user">
<selectKey keyProperty="id" resultClass="int" type="pre">
select user_seq.nextval from Users
</selectKey>
insert into Users values(#id#,#username#,#password#)
</insert>
<select id="verlidateUser" resultClass="user" parameterClass="com.xinrui.pojo.User">
select * from Users where username=#username#
</select>
</sqlMap>
其中,parameterClass=“user”,表示在DaoImpl中传入的是对象,
user = (User) sqlMapclient.queryForObject("verlidateUser", u);
另外,insert into Users values(#id#,#username#,#password#)中,username,password也是pojo中的字段,也就是pojo的字段必须保持和数据库中的字段相同,这样ibatis才能拿到字段并注入到pojo类中。