iBATIS配置parameterMap外键的写法

0 0

iBATIS配置parameterMap外键的写法5

简单来说，2个POJO，User类包含一个Depart类的引用，现在想询问User.xml里面parameterMap这里怎么写Depart。

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap 
	PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
	"http://ibatis.apache.org//dtd/sql-map-2.dtd">

<sqlMap namespace="User">
	<cacheModel type="MEMORY" id="userCache">
		<flushOnExecute statement="User.add-user" />
		<!-- <flushOnExecute statement="User.update-user" />
		<flushOnExecute statement="delete" />  -->
		<property name="reference-type" value="WEAK" />
	</cacheModel>

	<typeAlias alias="User" type="com.yourcompany.model.User" />
	<typeAlias alias="Depart" type="com.yourcompany.model.Depart" />

	<resultMap class="Depart" id="fulldepart">
		<result property="id" column="id" javaType="int"
			jdbcType="INTEGER" />
		<result property="name" column="name" javaType="string"
			jdbcType="VARCHAR" />
		<result property="manager" column="manager" javaType="string"
			jdbcType="VARCHAR" />
	</resultMap>
	<resultMap class="User" id="UserDepart">
		<result property="id" column="id" javaType="int"
			jdbcType="INTEGER" />
		<result property="username" column="loginName" javaType="string"
			jdbcType="VARCHAR" />
		<result property="truename" column="trueName" javaType="string"
			jdbcType="VARCHAR" />
		<result property="delflag" column="delflag" javaType="boolean"
			jdbcType="TINYINT" />
		<result property="depart" column="depart" resultMap="fulldepart" jdbcType="INTEGER"/>
	</resultMap>


	<parameterMap class="User" id="minUser">
		<parameter property="username" javaType="string"
			jdbcType="VARCHAR" />
		<parameter property="truename" javaType="string"
			jdbcType="VARCHAR" />
		<parameter property="password" javaType="string"
			jdbcType="VARCHAR" />
		<parameter property="depart" javaType="Depart" jdbcType="int"/>
	</parameterMap>


	<sql id="select-user">SELECT * FROM USERS</sql>
	<sql id="where-uid">WHERE id=#ID:INTEGER#</sql>
	<sql id="where-name">WHERE loginName=#username:VARCHAR#</sql>


	<insert id="add-user" parameterMap="minUser"
		parameterClass="User">
		INSERT INTO onlineexam.users
		(loginName,trueName,password,depart) VALUES(?,?,?,?)
		<selectKey keyProperty="id" resultClass="int">
			SELECT LAST_INSERT_ID()
		</selectKey>
	</insert>
</sqlMap>

现在情况是
<parameter property="depart" javaType="Depart" jdbcType="int"/>
这句这里，我不知道该怎么写才能让ibatis能插入。

另外
<result property="depart" column="depart" resultMap="fulldepart" jdbcType="INTEGER"/>
是否有错？

报错信息
Exception in thread "main" com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/yourcompany/model/xml/User.xml.
--- The error occurred while applying a parameter map.
--- Check the User.minUser.
--- Check the parameter mapping for the 'depart' property.
--- Cause: java.lang.NullPointerException

iBATIS