<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
不真的是哪裡的錯誤,幫忙看下