我毕业设计用的是access数据库,是这样的 CString strSQL; strSQL.Format("UPDATE databasename.tablename SET yourownfield=#%s#",date); You can write it like this: strSQL.Format("UPDATE databasename.tablename SET yourownfield='%d-%d-%d %d:%d:%d'",date.GetYear(),date.Month(), date.GetDay(), date.GetHour(), date.GetMinute(), date.GetSecond()); note: after"%d-%d-%d"there is a space
变成:String sqlStr = "insert into tableTest set date = '"+sqlDate+"'";
stmt.setTimestamp(sqlDate);
stmt.executeUpdate();
stmt.close();
String sqlStr = "insert into tableTest(字段) value(?)";PreparedStatement stmt = conn.preparedStatement(sqlStr);
stmt.setTimestamp(1, sqlDate);
stmt.executeUpdate();
stmt.close();
CString strSQL;
strSQL.Format("UPDATE databasename.tablename SET yourownfield=#%s#",date);
You can write it like this:
strSQL.Format("UPDATE databasename.tablename SET yourownfield='%d-%d-%d %d:%d:%d'",date.GetYear(),date.Month(), date.GetDay(), date.GetHour(), date.GetMinute(), date.GetSecond());
note: after"%d-%d-%d"there is a space