try {
Class.forName(xml.getDriver());
Connection conn = DriverManager.getConnection(xml.getUrl(),xml.getUser(),xml.getPassWord());
PreparedStatement ps = conn .prepareStatement("insert into scrap (nickname,name,text,upload,modify) values (?,?,?,?,?)"); ps.setString(1, nickname);
ps.setString(2, name);
ps.setString(3, text_);
ps.setString(4, date);
ps.setString(5, date);
ps.executeUpdate(); ps.close();
conn.close();
} catch (Exception e) {
out.print("异常!");
System.out.println(e.getMessage());
}
Class.forName(xml.getDriver());
Connection conn = DriverManager.getConnection(xml.getUrl(),xml.getUser(),xml.getPassWord());
PreparedStatement ps = conn .prepareStatement("insert into scrap (nickname,name,text,upload,modify) values (?,?,?,?,?)"); ps.setString(1, nickname);
ps.setString(2, name);
ps.setString(3, text_);
ps.setString(4, date);
ps.setString(5, date);
ps.executeUpdate(); ps.close();
conn.close();
} catch (Exception e) {
out.print("异常!");
System.out.println(e.getMessage());
}
异常![Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。 java.util.Date Now = new java.util.Date();
String date = Now.toLocaleString();
这个是date 是取出来的系统时间
调试了下,应该是时间错误,
JSP中怎么获取系统时间存入数据库啊?
格式是 yyyy-mm-dd hh:mm:ss
sdf.format("yyyy-mm-dd hh:mm:ss");
sdf.format("yyyy-MM-dd hh:mm:ss");