please use preparedstatement.
sql = "insert into tab_xx(int_co1, date_co2) values(?, ?)"
pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, 1);
pstmt.setDate(2, Your_Date);
//or use timestamp
//pstmt.setTimestamp(2, your_timestamp);
pstmt.executeUpdate();
sql = "insert into tab_xx(int_co1, date_co2) values(?, ?)"
pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, 1);
pstmt.setDate(2, Your_Date);
//or use timestamp
//pstmt.setTimestamp(2, your_timestamp);
pstmt.executeUpdate();
where date_co=?
pstmt.setDate(1,nowDate)
是这样吗?
java.sql.PreparedStatement的api说明吧