Calendar cal = Calendar.getInstance();
SimpleDateFormat formatter = new SimpleDateFormat("yyyyMMdd");
String mDateTime=formatter.format(cal.getTime()); String ctestSql="insert into message(sdate) values("+mDateTime+")";
PreparedStatement prepare = conn.prepareStatement(ctestSql);
boolean b_sucess = prepare.execute(ctestSql);
SimpleDateFormat formatter = new SimpleDateFormat("yyyyMMdd");
String mDateTime=formatter.format(cal.getTime()); String ctestSql="insert into message(sdate) values("+mDateTime+")";
PreparedStatement prepare = conn.prepareStatement(ctestSql);
boolean b_sucess = prepare.execute(ctestSql);
用PreparedStatement,然后用setDate来将当前日期插入进去
pstat.setDate( 1, new java.sql.Date( System.currentTimeMillis() ) );