ibatis初级问题

Question

本人刚开始学iBATIS 一个小例子有错误如下：
--- The error occurred in employee.xml.

--- The error occurred while applying a parameter map.

--- Check the getEmployee-InlineParameterMap.

--- Check the statement (query failed).

--- Cause: java.sql.SQLException: ORA-00942: 表或视图不存在
表：
create table EMPLOYEE
(
EID NUMBER,
NAME VARCHAR2(32),
SALARY NUMBER,
DEPTID VARCHAR2(32)
)

employeex.xml ：


SELECT * FROM EMPLOYEE WHERE EID=#EID#


INSERT INTO
EMPLOYEE(EID, NAME, SALAY, DEPTID)
VALUES (#eid#, #name#, #salary#, #deptid#)

主要代码：
Employee employee= new Employee();
employee.setEid(15);
employee.setName("oring");
employee.setSalary(1000);
employee.setDeptid("0001");

SqlMapClient sqlMap = Myapp.getSqlMapInstance();
try{
Integer eid= new Integer(2);
Employee employee2 = (Employee) sqlMap.queryForObject ("getEmployee", eid);
catch(Exception e){
e.printStackTrace();
}

} 

Answer 1

SELECT * FROM EMPLOYEE WHERE EID=#EID#

这里错了，你这有传进来的参数，而没有返回的参数，你想下，select语句是要返回数据的吧，那你返回的数据装那去了，所以应该这样写
[code="java"]

SELECT * FROM EMPLOYEE WHERE EID=#EID#

[/code]

还有你的com.ibatis.dao.Employee，他的属性一定要有get set方法