用ibatis出现异常,com.ibatis.common.jdbc.exception.NestedSQLException
映射文件
thrme_cz.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 namespace="thrme_cz">
<!--题目+答案的结果集映射 -->
<resultMap id="thrms_map" class="com.ibatis.thrmes">
<result property="thrme_id" column="thrme_id"
jdbcType="int" javaType="java.lang.Integer"
/>
<result property="thrme_name" column="thrme_name"
jdbcType="nvarchar" javaType="java.lang.String"
/>
<result property="thrme_rb" column="thrme_rb"
jdbcType="nvarchar" javaType="java.lang.String"
/>
<result property="thrme_type_name" column="thrme_type_name"
jdbcType="nvarchar" javaType="java.lang.String"
/>
<result property="solution" column="solution"
jdbcType="nvarchar" javaType="java.lang.String"
/>
<result property="A" column="A"
jdbcType="nvarchar" javaType="java.lang.String"
/>
<result property="B" column="B"
jdbcType="nvarchar" javaType="java.lang.String"
/>
<result property="C" column="C"
jdbcType="nvarchar" javaType="java.lang.String"
/>
<result property="D" column="D"
jdbcType="nvarchar" javaType="java.lang.String"
/>
<result property="E" column="E"
jdbcType="nvarchar" javaType="java.lang.String"
/>
</resultMap>
<select id="getThrmes" resultMap="thrms_map">
<![CDATA[
select a.thrme_id,thrme_name,thrme_type_name,thrme_rb,solution,A,B,C,D,E
from thrme_s a,thrme_type b,solution c
where a.thrme_type_id=b.thrme_type_id and a.thrme_id=c.thrme_id
]]>
</select>
</sqlMap>
-------------------调用代码
try{
Reader red=Resources.getResourceAsReader("com/ibatis/SqlMapConfig.xml");
XmlSqlMapClientBuilder xcb=new XmlSqlMapClientBuilder();
SqlMapClient sqlMap=xcb.buildSqlMap(red);
sqlMap.startTransaction();
List ls=sqlMap.queryForList("getThrmes",null);
for(int i=0;i<ls.size();i++){
thrmes t=(thrmes)ls.get(i);
System.out.println(t.getThrme_type_name());
}
sqlMap.endTransaction();
}
catch(Exception e){
e.printStackTrace();
}
----------------我的com.ibatis.thrmes
public class thrmes {
private Integer thrme_id;
private String thrme_name;
private String thrme_rb;
private String solution;
private String A;
private String B;
private String C;
private String D;
private String E;
private String thrme_type_name;
public String getA() {
return A;
}
public void setA(String a) {
A = a;
}
public String getB() {
return B;
}
public void setB(String b) {
B = b;
}
public String getC() {
return C;
}
public void setC(String c) {
C = c;
}
public String getD() {
return D;
}
public void setD(String d) {
D = d;
}
public String getE() {
return E;
}
public void setE(String e) {
E = e;
}
public String getSolution() {
return solution;
}
public void setSolution(String solution) {
this.solution = solution;
}
public Integer getThrme_id() {
return thrme_id;
}
public void setThrme_id(Integer thrme_id) {
this.thrme_id = thrme_id;
}
public String getThrme_name() {
return thrme_name;
}
public void setThrme_name(String thrme_name) {
this.thrme_name = thrme_name;
}
public String getThrme_rb() {
return thrme_rb;
}
public void setThrme_rb(String thrme_rb) {
this.thrme_rb = thrme_rb;
}
public String getThrme_type_name() {
return thrme_type_name;
}
public void setThrme_type_name(String thrme_type_name) {
this.thrme_type_name = thrme_type_name;
}
}