[Microsoft][ODBC Microsoft Access Driver]可选的功能未实现

benben19880813

org.apache.jasper.JasperException: [Microsoft][ODBC Microsoft Access Driver]可选的功能未实现

在这一个方法所在的类中,"查询","插入","删除"功能都可以实现,就是修改功能出现
"org.apache.jasper.JasperException: [Microsoft][ODBC Microsoft Access Driver]可选的功能未实现"这个错误.

修改部分的代码如下:


public void update() throws Exception {
Connection conn = null;
PreparedStatement prep = null;
try {
conn = new DBConnection().getConnection();
String sql =
"UPDATE FROM STUDENT set name=?,studentNumber=?," +
"birthday=?,sex=?,polity=?,brief=? WHERE id = ? ";

prep = conn.prepareStatement(sql, ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
prep.setString(1, studentBean.getName());
prep.setString(2, studentBean.getStudentNumber());
prep.setDate(3, new java.sql.Date(studentBean.getBirthday().getTime()));
prep.setInt(4, studentBean.getSex());
prep.setInt(5, studentBean.getPolity());
prep.setString(6, studentBean.getBrief());
prep.setLong(7, studentBean.getId());
prep.execute();

} finally {
if (prep != null) {
prep.close();
}
if (conn != null) {
conn.close();
}
}

}