In this tutorial will teach jdbc record insertion into mysql database step by step.
First Step
Establish the database Connection
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | Connection con; PreparedStatement pst; public void Connect() { try { Class.forName("com.mysql.jdbc.Driver"); //Register the mysql driver con = DriverManager.getConnection("jdbc:mysql://localhost/phonebook","root",""); } catch (ClassNotFoundException ex) { ex.printStackTrace(); } catch (SQLException ex) { ex.printStackTrace(); } } |
Put the code inside the Save 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 | try { String friendname,phone,place; friendname = txtFname.getText(); phone = txtphone.getText(); place = txtplace.getText(); pst = con.prepareStatement("insert into records(fname,phone,place)values(?,?,?)"); pst.setString(1,friendname); pst.setString(2,phone); pst.setString(3,place); int status = pst.executeUpdate(); if(status==1) { JOptionPane.showMessageDialog(this, "Record Saved"); txtFname.setText(""); txtphone.setText(""); txtplace.setText(""); txtFname.requestFocus(); } else { JOptionPane.showMessageDialog(this, "Record Failed"); } } catch (SQLException ex) { ex.printStackTrace(); } |
i have attached the video link below. which will do this tutorials step by step.
