This tutorials will teach Cab Services System using Java and Mysql step by step process. This project will help you to do the java assignment projects and java best practices.
Lets do the Project step by step
First Step Establish the database connection
import the sql namespace
1 | import java.sql.*; |
1 2 | Connection con; PreparedStatement pst; |
1 2 3 4 5 6 7 8 9 10 11 | public void Connect() { try { Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection("jdbc:mysql://localhost/gvccabs","root",""); } catch (ClassNotFoundException ex) { ex.printStackTrace(); } catch (SQLException ex) { ex.printStackTrace(); } } |
Connect method then Connection will be loaded.
1 2 3 4 | public Journey() { initComponents(); Connect(); } |
Paste 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 28 29 30 31 32 33 34 | String time,point,des,pname,phone,driver,amount; time = txtTime.getText(); point = txtPoint.getText(); des = txtDes.getText(); pname = txtPname.getText(); phone = txtNo.getText(); driver = txtDriver.getText(); amount = txtAmount.getText(); try { pst = con.prepareStatement("insert into records (time,pickup,Destination,pname,phoneno,driver,amount)values(?,?,?,?,?,?,?)"); pst.setString(1,time); pst.setString(2,point); pst.setString(3,des); pst.setString(4,pname); pst.setString(5,phone); pst.setString(6,driver); pst.setString(7,amount); pst.executeUpdate(); JOptionPane.showMessageDialog(this, "Journey Started"); txtTime.setText(""); txtPoint.setText(""); txtDes.setText(""); txtPname.setText(""); txtNo.setText(""); txtDriver.setText(""); txtAmount.setText(""); txtTime.requestFocus(); } catch (SQLException ex) { ex.printStackTrace(); } |
View the Data to JTable
Create the method table() and load the data from the database.
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 28 29 30 31 32 33 34 35 | public void table() { try { pst = con.prepareStatement("SELECT * FROM records"); ResultSet Rs = pst.executeQuery(); 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("id")); v2.add(Rs.getString("time")); v2.add(Rs.getString("pickup")); v2.add(Rs.getString("Destination")); v2.add(Rs.getString("pname")); v2.add(Rs.getString("phoneno")); v2.add(Rs.getString("driver")); v2.add(Rs.getString("amount")); } DFT.addRow(v2); } jTable1.setModel(DFT); } catch (SQLException ex) { ex.printStackTrace(); } } |