58,454
社区成员
发帖
与我相关
我的任务
分享
DynaValidatorForm f = (DynaValidatorForm) form;
SimpleDateFormat time = new SimpleDateFormat("yyyy-mm-dd hh:MM:ss");
String sql="insert into message(id, name, title, content,time, email)values(seq_messg.nextval,?,?,?,?,?);";
String params[]={(String) f.get("name"),(String) f.get("title"),(String) f.get("content"),time.format(new Date()),(String) f.get("email")};
Object[] params2={f.get("name"),f.get("title"),f.get("content"),time.format(new Date()),f.get("email")};
try {
Context context =new InitialContext();
DataSource ds =(DataSource) context.lookup("java:/comp/env/jdbc/oracleds");
QueryRunner qr = new QueryRunner(ds);
qr.update(sql, params);
qr.update(sql, params2);
} catch (NamingException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return null;
java.sql.SQLException: ORA-00911: 无效字符
Query: insert into message(id, name, title, content,time, email)values(seq_messg.nextval,?,?,?,?,?); Parameters: [s, bc, a, 2014-11-29 10:06:11, x]
at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:363)