This OOP Crud Project will teach you how to do basic database functions that are CREATE RETIEVE, UPDATE and DELETE and SEARCH using mysql Database. The INSERT, SELECT, UPDATE and DELETE statements can be used in any database system, because this is support by all relational database systems.will discuss about how to work with oop using crud operations are (create,read,update,delete).
We will learn how to INSERT, SELECT, UPDATE and DELETE and SEARCH in database by writing code to manage the records table in the database named studentinfo. students table consist of following columns fname,course,fee.
Model
First you have to create package com.example.oop.model.
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 36 37 38 39 40 41 | package com.example.oop.model; public class Student { private int id; private String fname; private String course; private int fee; public int getId() { return id; } public void setId(int id) { this.id = id; } public String getFname() { return fname; } public void setFname(String fname) { this.fname = fname; } public String getCourse() { return course; } public void setCourse(String course) { this.course = course; } public int getFee() { return fee; } public void setFee(int fee) { this.fee = fee; } } |
we created the database studentinfo.inside the database created the table which name is students in the mysql database.
After that created the package com.example.oop.studentdb.
Establish the Db Connection
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | package com.example.oop.studentdb; import java.sql.Connection; import java.sql.DriverManager; public class StudentDb { static Connection con; static String driver = "com.mysql.jdbc.Driver"; static String url = "jdbc:mysql://localhost/studentinfo"; static String uname = "root"; static String pass = ""; public static Connection getConnection() throws Exception{ if(con == null){ Class.forName(driver); con = DriverManager.getConnection(url,uname, pass); } return con; } } |
Controller
After that created the package com.example.oop.studentcontroller. create the interface StudentDAO.
1 2 3 4 5 6 7 8 9 10 | public interface StudentDAO { public void save(Student students); public void update(Student students); public void delete(Student students); public Student get(int id); public List<Student> list(); } |
after that create the class StudentDAOImp and implement the particular interface StudentDAO. inside the class
we create the crud operation methods.
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 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 | package com.example.oop.studentcontoller; import com.example.oop.model.Student; import com.example.oop.studentdb.StudentDb; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; import java.util.List; import javax.swing.JOptionPane; public class StudentDAOImp implements StudentDAO { @Override public void save(Student students) { try { Connection con = StudentDb.getConnection(); String sql = "INSERT INTO students(fname,course,fee) VALUES (?,?,?)"; PreparedStatement ps = con.prepareStatement(sql); ps.setString(1, students.getFname()); ps.setString(2, students.getCourse()); ps.setInt(3, students.getFee()); ps.executeUpdate(); JOptionPane.showMessageDialog(null, "Saved!"); } catch (Exception e) { e.printStackTrace(); JOptionPane.showMessageDialog(null, "Error"); } } @Override public void update(Student students) { try { Connection con = StudentDb.getConnection(); String sql = "UPDATE students SET fname=?,course=?,fee=? WHERE id=?"; PreparedStatement ps = con.prepareStatement(sql); ps.setString(1, students.getFname()); ps.setString(2, students.getCourse()); ps.setInt(3, students.getFee()); ps.setInt(4, students.getId()); ps.executeUpdate(); JOptionPane.showMessageDialog(null, "Updated!"); } catch (Exception e) { e.printStackTrace(); JOptionPane.showMessageDialog(null, "Error"); } } @Override public void delete(Student students) { try { Connection con = StudentDb.getConnection(); String sql = "delete from students WHERE id=?"; PreparedStatement ps = con.prepareStatement(sql); ps.setInt(1, students.getId()); ps.executeUpdate(); JOptionPane.showMessageDialog(null, "Deleteddd!"); } catch (Exception e) { e.printStackTrace(); JOptionPane.showMessageDialog(null, "Error"); } } @Override public Student get(int id) { Student st = new Student(); try { Connection con = StudentDb.getConnection(); String sql = "SELECT * FROM students WHERE id=?"; PreparedStatement ps = con.prepareStatement(sql); ps.setInt(1, id); ResultSet rs = ps.executeQuery(); if(rs.next()){ st.setId(rs.getInt("id")); st.setFname(rs.getString("fname")); st.setCourse(rs.getString("course")); st.setFee(rs.getInt("fee")); } } catch (Exception e) { e.printStackTrace(); JOptionPane.showMessageDialog(null, "Error"); } return st; } @Override public List<Student> list() { List<Student> list = new ArrayList<Student>(); try { Connection con = StudentDb.getConnection(); String sql = "SELECT * FROM students "; PreparedStatement ps = con.prepareStatement(sql); ResultSet rs = ps.executeQuery(); while(rs.next()){ Student st = new Student(); st.setId(rs.getInt("id")); st.setFname(rs.getString("fname")); st.setCourse(rs.getString("course")); st.setFee(rs.getInt("fee")); list.add(st); } } catch (Exception e) { e.printStackTrace(); JOptionPane.showMessageDialog(null, "Error"); } return list; } } |
View
we designed the swing GUI design.After that created the package com.example.oop.studentview.
Save
save button which we use to save data in to the mysql database.
double click the save button paste the code code inside.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | Student st = new Student(); String sname = txtsname.getText(); String course = txtcourse .getText(); int fee = Integer.parseInt(txtfee .getText()); st.setFname(sname); st.setCourse(course); st.setFee(fee); StudentDAOImp dao = new StudentDAOImp(); dao.save(st); Load(); txtsname.setText(""); txtcourse.setText(""); txtfee.setText(""); txtsname.requestFocus(); |
Load
Get the data from the mysql database to pass into JTable.so create the method which load() inside the method we paste the following code.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | public void Load() { StudentDAOImp dao = new StudentDAOImp(); List<Student> list = dao.list(); DefaultTableModel DFT = (DefaultTableModel) jTable1.getModel(); DFT.setRowCount(0); for(Student st: list) { int sid = st.getId(); String stname = st.getFname(); String course = st.getCourse(); int fee = st.getFee(); DFT.addRow(new Object[]{sid,stname,course,fee}); } } |
after done it. you have to call the load method inside the constructor of class.so when application runs all data will be loaded.i shown below how to call inside the constructor.
1 2 3 4 | public StudentForm() { initComponents(); Load(); } |
Search
Search button which we use to seach data from the mysql database.double click the seach button paste the code code inside.
1 2 3 4 5 6 7 8 | search = Integer.parseInt(JOptionPane.showInputDialog("Enter Student ID")); StudentDAOImp dao = new StudentDAOImp(); Student st = dao.get(search); txtsname.setText(st.getFname()); txtcourse.setText(st.getCourse()); txtfee.setText(String.valueOf(st.getFee())); |
Edit
After search the record you have to make a changes what you need and click edit button.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | Student st = new Student(); String sname = txtsname.getText(); String course = txtcourse .getText(); int fee = Integer.parseInt(txtfee .getText()); st.setFname(sname); st.setCourse(course); st.setFee(fee); st.setId(search); StudentDAOImp dao = new StudentDAOImp(); dao.update(st); Load(); txtsname.setText(""); txtcourse.setText(""); txtfee.setText(""); txtsname.requestFocus(); |
Delete
After search the record by using student what you want delete. and click delete button.
1 2 3 4 5 6 7 8 9 | Student st = new Student(); st.setId(search); StudentDAOImp dao = new StudentDAOImp(); dao.delete(st); Load(); txtsname.setText(""); txtcourse.setText(""); txtfee.setText(""); txtsname.requestFocus(); |
i have attached the video link below. which will do this tutorials step by step.
