This tutorial will teach you how to make a house rest system step by step. This system helpful you to learn JDBC connective and learn crud operation.
First Establish the Database Connection
Add the Sql Namespace
import java.sql.*;
Database Connection
Connection con;
PreparedStatement pst;
public void Connect()
{
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/houserent","root","");
} catch (ClassNotFoundException ex) {
Logger.getLogger(HouseRent.class.getName()).log(Level.SEVERE, null, ex);
} catch (SQLException ex) {
Logger.getLogger(HouseRent.class.getName()).log(Level.SEVERE, null, ex);
}
}
Paste following code inside the Save Button
String hno,address,kit,bath,rooms,rent;
hno = txtNo.getText();
address = txtAddress.getText();
kit = txtKit.getText();
rooms = txtRooms.getText();
bath = txtBath.getText();
rent = txtRent.getText();
try {
pst = con.prepareStatement("insert into records (houseno,address,kitchen,rooms,bathroom,Rent)values(?,?,?,?,?,?)");
pst.setString(1,hno);
pst.setString(2,address);
pst.setString(3,kit);
pst.setString(4,rooms);
pst.setString(5,bath);
pst.setString(6,rent);
pst.executeUpdate();
JOptionPane.showMessageDialog(this, "Record Saved");
txtNo.setText("");
txtAddress.setText("");
txtKit.setText("");
txtRooms.setText("");
txtBath.setText("");
txtRent.setText("");
txtNo.requestFocus();
Table();
}
catch (SQLException ex)
{
ex.printStackTrace();
}Load the Table
public void Table()
{
try {
pst = con.prepareStatement("SELECT * FROM records");
ResultSet Rs = pst.executeQuery();
DefaultTableModel model = (DefaultTableModel) jTable1.getModel();
ResultSetMetaData RSMD = Rs.getMetaData();
int CC = RSMD.getColumnCount();
DefaultTableModel DFT = (DefaultTableModel) jTable1.getModel();
DFT.setRowCount(0);
while(Rs.next())
{
Vector v2 = new Vector();
for (int ii = 1; ii <= CC; ii++) {
v2.add(Rs.getString("houseno"));
v2.add(Rs.getString("address"));
v2.add(Rs.getString("kitchen"));
v2.add(Rs.getString("rooms"));
v2.add(Rs.getString("bathroom"));
v2.add(Rs.getString("Rent"));
}
DFT.addRow(v2);
}
jTable1.setModel(model);
} catch (SQLException ex) {
ex.printStackTrace();
}
}i have attached the video link below. which will do this tutorials step by step.
