Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void AddbtActionPerformed(java.awt.event.ActionEvent evt) {
- String id = idFld.getText() ;
- String item = ADDfld.getText();
- String amount = AMOUNTfld.getText();
- try {
- con=DriverManager.getConnection("jdbc:mysql://localhost:3306/isdb","root","");
- String query = "Insert into item (id,NAME,AMOUNT) values (?,?,?)";
- pst = con.prepareStatement(query);
- pst.setInt(1, Integer.parseInt(id));
- pst.setString(2, item);
- pst.setString(3,amount);
- pst.execute();
- } catch (SQLException ex ) {
- JOptionPane.showMessageDialog(null, ex);
- }
- ADDfld.setText("");
- idFld.setText("");
- AMOUNTfld.setText("");
- updateCombo();
- update_Table();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement