public boolean delDjCase(String personid,String caseid,String disposeid,String pcasetime){
String sql = "delete from personcase where personid=? and" +
" caseid=? and disposeid =? and pcasetime = to_date(?,'yyyy-mm-dd hh24:mi:ss')";
conn = db.getConn();
try {
ps = conn.prepareStatement(sql);
ps.setString(1, personid);
ps.setString(2, caseid);
ps.setString(3, disposeid);
ps.setString(4, pcasetime);
ps.executeUpdate();
rs = ps.executeQuery();
while(rs.next()){
flag = true;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
//关闭数据库连接
if(conn!=null){
try {
rs.close();
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
try {
ps.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
return flag;
}
我的日期总是出错。为什么啊?pcasetime是从前面传来的。我这样转换:
pcasetime = to_date(?,'yyyy-mm-dd hh24:mi:ss')
不对吗?