HI ,
Thankx for reply.
is this right and efficent way to code SQL queries in an application.
Who maintains compiled prepared statements? is it
JDBC driver ?
regards
Vivek
public void updateSales(String CoffeName,float sales)
{
PreparedStatement updateSales;
String updateString = "update COFFEES " +
"set SALES = ? where COF_NAME like ?";
updateSales = con.prepareStatement(updateString);
updateSales.setInt(1, sales);
updateSales.setString(2, CoffeName);
updateSales.executeUpdate();
}
[ May 29, 2006: Message edited by: vivekkumar sharma ]