Date date = vo2.getBirthdate();
String sql1 = "Update t_um_userdetail set photoid = '"
+ photoid.toString() + "', phonenum = '"
+ vo2.getPhonenum() + "', birthdate= ?"
+ ", gendercode='" + vo2.getGendercode()
+ "' where userid='" + vo1.getUserid() + "'";
Object[] parmaters = new Object[1] ;
parmaters[0] = date;
dao.executeUpdateSQL(sql1, parmaters);
public int executeUpdateSQL(String sql, Object[] parmaters)
throws DaoException {
log.info("数据层:执行标准更新SQL语句 executeQuerySQL (String ["+sql+"],Object[] "+ parmaters +") ");
int count = 0;
PreparedStatement ps = null;
try {
if (sql == null || sql.trim().length() == 0) {
throw new DaoException(DaoException.ERRORCODE_UPDATE_PARAM);
}
Connection conn = getConnection();
ps = conn.prepareStatement(sql);
Object obj = null;
if (parmaters != null && parmaters.length > 0) {
for (int i = 1; i <= parmaters.length; i++) {
obj = parmaters[i - 1];
if (obj instanceof Date) {
//Timestamp tt = new Timestamp(((Date)obj).getTime());
ps.setTimestamp(i,
new Timestamp(((Date) obj).getTime()));
} else if (obj instanceof Clob) {
ps.setClob(i, (Clob) obj);
} else if (obj instanceof Blob) {
ps.setBlob(i, (Blob) obj);
} else {
ps.setObject(i, parmaters[i - 1]);
}
}
}
count = ps.executeUpdate();
} catch (Exception e) {
throw new DaoException(DaoException.ERRORCODE_UPDATE);
} finally {
if (ps != null) {
try {
ps.close();
ps = null;
} catch (SQLException e) {
e.printStackTrace();
}
}
}
return count;
}
oracle数据库中 该字段是DATE 日期类型。