继承 org.springframework.orm.ibatis.support.SqlMapClientDaoSupport类
例如:
public class UserLoginDao extends
SqlMapClientDaoSupport(){
public UserInfo getItemById(String userId) {
Map<String, String> params = new HashMap<String, String>(1);
params.put("userId",
userId);
return (UserInfo)
getSqlMapClientTemplate().queryForObject(
user.
getItemById ,
params);
}
}
同时建立 sqlMap 配置文件 :
同时建立 sqlMap 配置文件 :
<sqlMap namespace="
user">
<sql id="
select_xxx_user">
select xxx.user_id,xxx.login,xxx.mobile FROM GOME_USER gome
</sql>
<select id="
getItemById" resultMap="UserInfo" parameterClass="java.util.Map">
<include refid="
select_xxx_user"/>
<![CDATA[
where USER_ID=#
userId# and removed IS NULL
]]>
</select>
</sqlMap>