62,614
社区成员
发帖
与我相关
我的任务
分享
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD sql Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap namespace="test/test_user">
<typeAlias alias="user" type="test.entity.User" />
<!-- Use primitive wrapper type (e.g. Integer) as parameter and allow results
to be auto-mapped results to Person object (Java Bean) properties -->
<select id="getUser" parameterClass="int" resultClass="user">
SELECT id,name,descs,address
FROM test_user
WHERE id = #value#
</select>
</sqlMap>
public static void main(String[] args) {
try {
com.ibatis.sqlmap.client.SqlMapClient sqlMap = null;
String resource = "sqlmap.xml";
Reader reader = Resources.getResourceAsReader(resource);
sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
// 显示一条记录
//getNameSpace() + "." + sqlName
//第一种方式,
List<User> list = (List<User>) sqlMap.queryForList("test/test_user.getUser","10");
System.out.println(list.get(0).getName());
//第二种方式
// User user = (User) sqlMap.queryForObject("test/test_user.getUser","10");
// System.out.println(user.getName());
} catch (Exception e) {
e.printStackTrace();
}
}
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD sql Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap namespace="test/test_user">
<typeAlias alias="user" type="" />
<!-- Use primitive wrapper type (e.g. Integer) as parameter and allow results
to be auto-mapped results to Person object (Java Bean) properties -->
<resultMap id="user" class="test.entity.User" >
<result column="id" property="id" jdbcType="DOUBLE" />
<result column="name" property="name" jdbcType="VARCHAR" />
<result column="descs" property="descs" jdbcType="VARCHAR" />
<result column="address" property="address" jdbcType="VARCHAR" />
</resultMap>
<select id="getUser" parameterClass="int" resultClass="user">
SELECT id,name,descs,address
FROM test_user
WHERE id = #value#
</select>
<select id="getUser" parameterClass="int" resultMap="user">
SELECT id,name,descs,address
FROM test_user
WHERE id = #value#
</select>
</sqlMap>
resultClass 改成 resultMap
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD sql Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap namespace="test/test_user">
<typeAlias alias="user" type="test.entity.User" />
<!-- Use primitive wrapper type (e.g. Integer) as parameter and allow results
to be auto-mapped results to Person object (Java Bean) properties -->
<select id="getUser" parameterClass="int" resultClass="user">
SELECT id,name,descs,address
FROM test_user
WHERE id = #value#
</select>
<select id="getUser" parameterClass="int" resultMap="user">
SELECT id,name,descs,address
FROM test_user
WHERE id = #value#
</select>
</sqlMap>
resultClass 改成 resultMap