This tutorial will teach you how to make a Batch Processing Java JDBC Gui application.
Establish the database Connection
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | 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) { } } |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 | 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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 | 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) { } |
