This tutorial will teach you how to make a Batch Processing Java JDBC Gui application.
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); } }
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) { }
In this tutorial will teach Laravel 11 Api MVC with Repository Pattern Crud Application step…
In this tutorial will teach Laravel 11 CRUD Application step by step. Laravel 11 CRUD…
in this tutorials we will be talk about how to make a times table in…
In this tutorials will teach How to add two numbers in Laravel 10. (more…)
In this tutorial, we will teach the process of building a full-stack application using Node.js,…
In this tutorial, we will explin you through the process of building a Hospital Management…