晕,Oracle不能直接把string当成date用的,又不是sqlserver
String sql="update repository set name='"+sName+"',type='"+sType+"',caption='"+sCaption+"',"+
"description='"+sDescription+"',filesize='"+fileSize+"',uploadDate=to_date('"+uploadDate+"', 'yyyy-mm-dd hh24:mi:ss'),filePath='"+fileName+"'"+
"where id='"+id+"'";
或者说还是用你1的方式,用占位符加上setTimestamp来做也可以
String sql="update repository set name='"+sName+"',type='"+sType+"',caption='"+sCaption+"',"+
"description='"+sDescription+"',filesize='"+fileSize+"',uploadDate=to_date('"+uploadDate+"', 'yyyy-mm-dd hh24:mi:ss'),filePath='"+fileName+"'"+
"where id='"+id+"'";
或者说还是用你1的方式,用占位符加上setTimestamp来做也可以
Timestamp uploadDate这个值难道做字符串处理嘛?还是用别的办法
String sql="update repository set(name,type,caption,description,filesize,uploaDate,filePth) values(?,?,?,?,?,?,?) where id='"+id+"'";
好像不对哦。。麻烦了大侠
System.out.println(sql);
try{
pstmt = dbconn.getConnection().prepareStatement(sql);
pstmt.setString(1,sName);
pstmt.setString(2,sType);
pstmt.setString(3,sCaption);
pstmt.setString(4,sDescription);
pstmt.setString(5,fileSize);
pstmt.setTimestamp(6,uploadDate);
pstmt.setString(7,fileName);
pstmt.setString(8,sId);
pstmt.executeUpdate() ;
这里uploadDate不就是日期类型的么,还能用to_date么?