SSM整合一些问题以及异常的解决

org.apache.ibatis.executor.ExecutorException: There was no TypeHandler found for parameter department of statement com.zyl.SSM.Mapper.EmployeeMapper.add

在添加数据的时候显示的,数据库中有两张表(Department和Employee),是常见的一对多关联关系,在添加数据的时候发生了这个异常,多半是传入的数据类型和Jdbc类型不匹配导致的:

	<insert id="add" parameterType="Employee" >
		Insert into employee( lastName,email,birth,createTime,Department_ID) 
		Values(#{lastName},#{email},#{birth},#{createTime},#{department});
	</insert>

用直接类似EL表达式的方式即可绑定你想给定的数据类型 

	<insert id="add" parameterType="Employee" >
		Insert into employee( lastName,email,birth,createTime,Department_ID) 
		Values(#{lastName},#{email},#{birth},#{createTime},#{department.id});
	</insert>

 

转载于:https://my.oschina.net/ZYLzzz/blog/835555