posted 21 years ago
//create table coffees
query = "create table coffees(cof_name varchar(32)," +
"sup_id integer," +
"price float," +
"sales integer," +
"total integer)";
//Insert data into table coffees
1) stmt.executeUpdate("insert into coffees values('French_Rost',49,8.99,0,0)");
2) stmt.executeUpdate("insert into coffees values('Espresso',150,9.99,0,0)");
3) stmt.executeUpdate("insert into coffees values('Columbian_Decaf',101,8.99,0,0)");
4) stmt.executeUpdate("insert into coffees values('Columbian',101,7.99,0,0)");
5) stmt.executeUpdate("insert into coffees values('French_Rost_Decaf',49,9.99,0,0)");
statement 1),2),3) can execute success, three record been inserted into database. And statement 4),5) return value is 1, but no data be insert into database.
What is the problem?
What cause this problem?
thanks!
[ Edited by Dave to remove special characters ]
[ June 16, 2002: Message edited by: David O'Meara ]
Rome was not built in a day.