我在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="ireport">
<resultMap id="userObject" class="com.hgs.iReportTest.db.userObject">
<result property="id" column="id"/>
<result property="name" column="name"/>
<result property="sex" column="sex"/>
<result property="description" column="description"/>
<result property="value" column="value"/>
<result property="dept_name" column="dept_name"/>
</resultMap>
<!-- 横向分组和普通 -->
<select id="getUserInfo" resultMap="userObject">
select * from testtable order by sex,name
</select>
<select id="getUserInfo2" resultMap="userObject">
select * from testtable1 order by sex,name
</select>
<!-- 横向分组包含分组 -->
<select id="groupgroup" resultMap="userObject">
select * from testtable order by dept_name,sex
</select>
<select id="groupgroup2" resultMap="userObject">
select * from testtable1 order by dept_name,sex
</select>
<!-- 纵向分组 -->
<select id="zxgroup" resultMap="userObject">
select * from testtable group by dept_name
</select>
<select id="zxgroup2" resultMap="userObject">
select * from testtable1 group by dept_name
</select>
<insert id="InsertUserObject" parameterClass="java.util.Map">
INSERT INTO testtable(
name,
sex,
description,
value)
VALUES(
#Name#,
#Sex#,
#Des#,
#Value#
)
</insert>
</sqlMap>
报Invalid byte 3 of 3-byte UTF-8 sequence
解决办法一:
把所有汉字删除
解决办法二:
将<?xml version="1.0" encoding="UTF-8"?>中的UTF-8改成gbk