<sqlMap>
<typeAlias alias="emp" type="com.resunly.ibatis.Emp"/>
<resultMap id="empMAPResult" class="emp">
<result property="id" column="id" />
<result property="empName" column="empname"/>
<result property="empAddr" column="empaddr"/>
<result property="empSex" column="empsex"/>
<result property="departName" column="depart.depname"/>
<result property="des" column="depart.des"/>
</resultMap>
<select id="getEmp" parameterClass="java.lang.String" resultMap="empMAPResult" >
<![CDATA[
select a.empName as empName,
a.empAddr as empAddr,
a.empSex as empSex,
b.depName as departName,
b.des as des
from emp a, depart as b where a.departNo=b.depNo
]]>
</select>
</sqlMap>老被提示ORA-00933: SQL command not properly ended
不真的是哪裡的錯誤，幫忙看下
[quote]resultMap 里是6个字段， select 里是 5个字段[/quote]
我自己模拟试了下，不会报错啊
[quote]select a.empName as empName,
a.empAddr as empAddr,
a.empSex as empSex,
b.depName as departName,
b.des as des
from emp a, depart as b where a.departNo=b.depNo [/quote]
depart as b 错在这里， oracle表的表名不让用as 这边把as去掉就行了
[quote]<select id="getEmp" parameterClass="java.lang.String" [/quote]
你sql语句里的parameter呢？
<![CDATA[
select password from user where username = #username#
]]>
这种带参数的语句才需要parameterClass吧
[quote] 這一部份會再xml文件里報紅色錯誤，不真的爲什麽 。。。 [/quote]
报什么错呢？[code="java"]select a.empName as empName,
a.empAddr as empAddr,
a.empSex as empSex,
b.depName as departName,
b.des as des
from emp a, depart b where a.departNo=b.depNo [/code]
这是个正常的SQL语句
[quote]Make sure that all result coumns in a resultMap are in the field list of select statement[/quote]
select里少了select id
[code="java"]select a.id as id, a.empName as empName,
a.empAddr as empAddr,
a.empSex as empSex,
b.depName as departName,
b.des as des
from emp a, depart b where a.departNo=b.depNo [/code]
[quote]
[/quote]
[quote]
select a.empName as empName,
a.empAddr as empAddr,
a.empSex as empSex,
b.depName as departName,
b.des as des
from emp a, depart b where a.departNo=b.depNo
[/quote]
resultMap 里是6个字段， select 里是 5个字段