This tutorial will teach you how to make a Batch Processing Java JDBC Gui application.
Establish the database Connection
Connection con;
PreparedStatement pst;
ResultSet rs;
public void Connect()
{
try
{
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/vmproducts","root","");
}
catch (ClassNotFoundException ex)
{
}
catch (SQLException ex) {
}
}Select the txtaccountno textfield right click >Key->Event->KeyReleased past the code inside the KeyReleased event
private void txtpidKeyReleased(java.awt.event.KeyEvent evt) {
String pcode = txtpid.getText();
try {
pst = con.prepareStatement("select pname,price from product where id = ?");
pst.setString(1, pcode);
rs = pst.executeQuery();
if(rs.next() == true)
{
String pname = rs.getString(1);
String price = rs.getString(2);
txtpname.setText(pname);
txtprice.setText(price);
}
else
{
txtpname.setText("");
txtprice.setText("");
}
} catch (SQLException ex) {
Logger.getLogger(vmproduct.class.getName()).log(Level.SEVERE, null, ex);
}
}
Save Records
past the code inside the Add button
try {
con.setAutoCommit(false);
String pcode = txtpid.getText();
String pname = txtpname.getText();
String price = txtprice.getText();
String qty = txtqty.getText();
Statement st1=con.createStatement( );
String SQL1="insert into sales(pname,price,qty)values('" + pname + "','" + price + "','" + qty + "')";
String SQL2="update product set qty=qty- '" + qty + "' where id ='" + pcode + "'";
st1.addBatch(SQL1);
st1.addBatch(SQL2);
int[ ] status= st1.executeBatch( );
for(int i=0;i<status.length;i++)
{
System.out.println( status[ i ] );
}
con.commit();
} catch (SQLException ex) {
}