iBatis中通过mysql-connector-odbc访问时,出现如下错误。请问是什么原因?? check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE PER_ID = 1' at line 1sql 写错了吧 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 public static void main(String[] args){SqlMap sqlMap = MyAppSqlConfig.getSqlMapInstance(); Integer id = new Integer(2); try{ //Select Person person = (Person)sqlMap.executeQueryForObject("getPerson", id); System.out.println("....person=" + person); // Update person.setId(3); person.setFirstName("Deny"); person.setLastName("Liu"); person.setBirthDate(new Date()); person.setHeightInMeters(1.83); person.setWeightInKilograms(86.36); System.out.println("....update=" + sqlMap.executeUpdate("updatePerson", person)); // Delete person.setId(4); System.out.println("....delete=" + sqlMap.executeUpdate("deletePerson", person)); // Create Person newPerson = new Person(); newPerson.setId(1); newPerson.setFirstName("Clinton"); newPerson.setLastName("Begin"); newPerson.setBirthDate(new Date()); newPerson.setHeightInMeters(1.83); newPerson.setWeightInKilograms(86.36); System.out.println("....insert=" + sqlMap.executeUpdate ("insertPerson", newPerson)); }catch(Exception e){ e.printStackTrace(); }} 在sqlmap文件里不是java程序里 <mapped-statement name="insertPerson"> <![CDATA[ INSERT INTO PERSON( PER_ID, PER_FIRST_NAME, PER_LAST_NAME, PER_BIRTH_DATE, PER_WEIGHT_KG, PER_HEIGHT_M) VALUES ( #id#, #firstName#, #lastName#, #birthDate#, #weightInKilograms#, #heightInMeters# ) ]]> </mapped-statement> <mapped-statement name="updatePerson"> <![CDATA[ UPDATE PERSON SET PER_FIRST_NAME = #firstName#, PER_LAST_NAME = #lastName#, PER_BIRTH_DATE = #birthDate#, PER_WEIGHT_KG = #weightInKilograms#, PER_HEIGHT_M = #heightInMeters# WHERE PER_ID = #id# ]]> </mapped-statement> <mapped-statement name="deletePerson" > DELETE PERSON WHERE PER_ID = #id# </mapped-statement> 你用的是1.x版本的啊没用过我用的时候都2.x了DELETE PERSON WHERE PER_ID = #id#这个放在数据库里执行以下试试 不对,看id的值,应该是insert的时候出的问题执行以下insert试一下 时间格式 struts2数据源连接sql server2005 JSP或是servelet中如何调用soap的web服务? 一个spring中弱弱但纳闷的问题 vb里combobox取值问题 急!!!!在线等 中国科学院院士今天问我:JSF如何进行表单提交了以后重定向到一个servlet那?急啊 struts启动tomcat报错了 关于hibernate DAO 关于weblogic中的调试问题? 飞鸟 学 Ant ----- 一个实际build.xml中的几点困惑 struts的M层如何设计——请问高人关于struts的设计规范 j2se和j2sdk是不是一个东西
SqlMap sqlMap = MyAppSqlConfig.getSqlMapInstance();
Integer id = new Integer(2);
try{
//Select
Person person =
(Person)sqlMap.executeQueryForObject("getPerson", id);
System.out.println("....person=" + person);
// Update
person.setId(3);
person.setFirstName("Deny");
person.setLastName("Liu");
person.setBirthDate(new Date());
person.setHeightInMeters(1.83);
person.setWeightInKilograms(86.36);
System.out.println("....update=" +
sqlMap.executeUpdate("updatePerson", person));
// Delete
person.setId(4);
System.out.println("....delete=" +
sqlMap.executeUpdate("deletePerson", person));
// Create
Person newPerson = new Person();
newPerson.setId(1);
newPerson.setFirstName("Clinton");
newPerson.setLastName("Begin");
newPerson.setBirthDate(new Date());
newPerson.setHeightInMeters(1.83);
newPerson.setWeightInKilograms(86.36);
System.out.println("....insert=" +
sqlMap.executeUpdate ("insertPerson", newPerson));
}catch(Exception e){
e.printStackTrace();
}
}
在sqlmap文件里
不是java程序里
<![CDATA[
INSERT INTO PERSON(
PER_ID,
PER_FIRST_NAME,
PER_LAST_NAME,
PER_BIRTH_DATE,
PER_WEIGHT_KG,
PER_HEIGHT_M)
VALUES (
#id#,
#firstName#,
#lastName#,
#birthDate#,
#weightInKilograms#,
#heightInMeters#
)
]]>
</mapped-statement> <mapped-statement name="updatePerson">
<![CDATA[
UPDATE PERSON SET
PER_FIRST_NAME = #firstName#,
PER_LAST_NAME = #lastName#,
PER_BIRTH_DATE = #birthDate#,
PER_WEIGHT_KG = #weightInKilograms#,
PER_HEIGHT_M = #heightInMeters#
WHERE PER_ID = #id#
]]>
</mapped-statement> <mapped-statement name="deletePerson" >
DELETE PERSON WHERE PER_ID = #id#
</mapped-statement>
没用过
我用的时候都2.x了DELETE PERSON WHERE PER_ID = #id#这个放在数据库里执行以下试试
执行以下insert试一下