Ibatis的1对多把我搞疯了

0 0

Ibatis的1对多把我搞疯了5

先看错误

Exception in thread "main" org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];   
--- The error occurred in com/User.xml.  
--- The error occurred while applying a result map.  
--- Check the handr.  
--- Check the result mapping for the 'fingers' property.  
--- Cause: java.lang.NullPointerException; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in com/User.xml.  
--- The error occurred while applying a result map.  
--- Check the handr.  
--- Check the result mapping for the 'fingers' property.

发代码前先说一下，这是测试用代码，所以结构凑合吧

package com;

import java.util.List;

public class Hand {
	private int handId;
	private List fingers;
	public int getHandId() {
		return handId;
	}
	public void setHandId(int handId) {
		this.handId = handId;
	}
	public List getFingers() {
		return fingers;
	}
	public void setFingers(List fingers) {
		this.fingers = fingers;
	}
}

package com;

public class Finger {
	private int fingerId;

	public int getFingerId() {
		return fingerId;
	}

	public void setFingerId(int fingerId) {
		this.fingerId = fingerId;
	}
	
}

package com;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.FileSystemXmlApplicationContext;
import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;

public class Dao extends SqlMapClientDaoSupport {
	public Hand get(int i){
		return (Hand) this.getSqlMapClientTemplate().queryForObject("getHand", i);
	}
	public static void main(String[] args){
		ApplicationContext app = new FileSystemXmlApplicationContext("src/com/ApplicationContext.xml");
		Dao dao = (Dao)app.getBean("dao");
		Hand h = dao.get(1);
		System.out.println(h);
	}
}

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "http://ibatis.apache.org/dtd/sql-map-2.dtd" "http://ibatis.apache.org/dtd/sql-map-2.dtd" >
<sqlMap>
	<resultMap class="com.Hand" id="handr">
		<result property="handId" column="h_id"/>
		<result property="fingers" select="getFingers" column="h_id"/>
	</resultMap>
	<resultMap class="com.Finger" id="fingerr">
		<result property="fingerId" column="f_id"/>
	</resultMap>
	<select id="getHand" resultMap="handr" parameterClass="int">
		select * from hand where h_id = #value#
	</select>	
	<select id="getFingers" resultMap="fingerr" parameterClass="int">
		select * from finger where h_id = #value#
	</select>	
</sqlMap>

表hand 里就一个h_id
finger h_id和f_id

简单的不能再简单了
但是我搞不定晕死了

iBATIS