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(); }
Relationships: Hotel ↔ Rooms (One-to-Many) A hotel can have many rooms, but a room belongs…
Introduction to Grocery Inventory Apps Managing grocery inventory can be a daunting task, but with…
This article explain how to make a Fish Inventory Management App in Angular.this app explain…
Introduction to Fish Inventory Management In the aquaculture industry, managing fish inventory is crucial for…
Introduction to Java GUI CRUD Java is a powerful programming language widely used for building…
Introduction to Login Form Design Designing an effective and beautiful login form is crucial for…