In this tutorial will teach jdbc record insertion into mysql database step by step.
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(); } }
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(); }
Conditional statements in Python allow us to control the flow of execution based on conditions.…
A Java Bean is a reusable software component that follows a specific set of conventions.…
Java provides a rich set of built-in methods for handling String operations efficiently. Since strings…
Java remains one of the most in-demand programming languages worldwide, powering everything from enterprise applications…
Java provides multiple ways to convert an integer (int) to a string (String). Whether you're…
Java Server Pages (JSP) is a powerful technology used to develop dynamic web applications by…