1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| try {
String aDateString = "16/02/2005";
SimpleDateFormat aFormatter = new SimpleDateFormat("dd/MM/yyyy");
Date aDate = aFormatter.parse(aDateString);
Connection base=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:bd1","system","manager");
PreparedStatement aPreparedStatement = base.prepareStatement("INSERT INTO commande(no_cde,date_cde,adr_livr,cp_liv,ville_livr,date_deb_prod,date_livr_prev,client) values (?,?,?,?,?,?,?,?,?)");
aPreparedStatement.setString(1,"seqcde.NEXTVAL");
aPreparedStatement.setDate(2, new java.sql.Date(aDate.getTime()));
aPreparedStatement.setString(3,"");
aPreparedStatement.setString(4,"");
aPreparedStatement.setString(5,"");
aPreparedStatement.setDate(6, new java.sql.Date(aDate.getTime()));
aPreparedStatement.setDate(7, new java.sql.Date(aDate.getTime()));
aPreparedStatement.setInt(8,1);
int aNrOfRows = aPreparedStatement.executeUpdate();
aPreparedStatement.close();
base.close();
} catch (Exception sqle) {
sqle.printStackTrace();
} |
Partager