Student Management System Project In Java With Source Code
The Student Management System Project In Java is developed using Java Programming Language, This Student Management System Project In Java And MySQL is simple and basic level small project for learning purposes. Also, you can modify this system as per your requirements and develop a perfect advance level project.
A Student Management System Java Code allows you to keep the student records and manage them when needed. This is a simple java project with a good and interactive-looking GUI. This Project Use MySQL Database for managing all the data that store in the database.
By the way I have here a list of Best Java Projects With Source Code For Beginners Free Download 2021 maybe this can help a lot.
Watch the video here to see the full running Student Management System Project In Java With Source Code
This Student Management System Project In Java also includes a downloadable Project With Source Code for free, just find the downloadable source code below and click to start downloading.
Student Management System Project In Java Features
- Add Student Information – In this feature the user can add the information of the students.
- Update Student Information – In this feature the user can update the information of the students inside the database.
- Delete Student Information – In this feature the user can delete any information of the students inside the database.
- Generate Student Information – In this feature the user can generate the report or the record of the students inside the database.
To start creating a Student Management System Project In Java, makes sure that you have NeatBeans IDE or any platform of Java installed in your computer.
Student Management System Project In Java With Source Code steps on how to create the project
Time needed: 5 minutes.
These are the steps on how to create Student Management System Project In Java With Source Code
- Step 1: Create project.
First, open file and then click “project” to create.
- Step 2: Create project name.
Second, name your project.
- Step 3: Create JFrame.
Third, create “JFrame” form.
- Step 4: Create JFrame name.
Fourth, name your JFrame form.
- Step 5: Project Design.
Fifth, The actual design of the project.
Complete Source Code
package StudentDBMysql;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;
import java.text.DateFormat;
import java.text.MessageFormat;
import java.text.SimpleDateFormat;
import java.util.Vector;
/**
*
* @author paul.oamen
*/
public class StudentDBMysql extends javax.swing.JFrame {
private static final String username="root";
private static final String password="";
private static final String dataConn ="jdbc:mysql://localhost:3306/studentdata";
Connection sqlConn =null;
PreparedStatement pst = null;
ResultSet rs=null;
int q, i, id, deleteItem;
/**
* Creates new form StudentDBMysql
*/
public StudentDBMysql() {
initComponents();
updateDB();
}
/**
* This method is called from within the constructor to initialize the form.
* WARNING: Do NOT modify this code. The content of this method is always
* regenerated by the Form Editor.
*/
@SuppressWarnings("unchecked")
//===============================Function Declaration======================================
public void updateDB()
{
//int q, i;
try
{
Class.forName("com.mysql.jdbc.Driver");
sqlConn = DriverManager.getConnection(dataConn,username,password);
pst = sqlConn.prepareStatement("select * from studentdata");
rs =pst.executeQuery();
ResultSetMetaData StData = rs.getMetaData();
q = StData.getColumnCount();
DefaultTableModel RecordTable = (DefaultTableModel)jTable1.getModel();
RecordTable.setRowCount(0);
while(rs.next()){
Vector columnData = new Vector();
for (i = 1; i <= q; i++)
{
columnData.add(rs.getString("id"));
columnData.add(rs.getString("studentid"));
columnData.add(rs.getString("firstname"));
columnData.add(rs.getString("surname"));
columnData.add(rs.getString("address"));
columnData.add(rs.getString("gender"));
columnData.add(rs.getString("mobile"));
columnData.add(rs.getString("maths"));
columnData.add(rs.getString("games"));
columnData.add(rs.getString("datasci"));
columnData.add(rs.getString("analysis"));
columnData.add(rs.getString("graphic"));
columnData.add(rs.getString("database1"));
columnData.add(rs.getString("science"));
columnData.add(rs.getString("english"));
}
RecordTable.addRow(columnData);
}
}
catch (Exception ex) {
JOptionPane.showMessageDialog(null, ex);
}
}
//=============================================================================================
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
jPanel2 = new javax.swing.JPanel();
jPanel4 = new javax.swing.JPanel();
jLabel15 = new javax.swing.JLabel();
jPanel5 = new javax.swing.JPanel();
jPanel1 = new javax.swing.JPanel();
jScrollPane1 = new javax.swing.JScrollPane();
jTable1 = new javax.swing.JTable();
jPanel7 = new javax.swing.JPanel();
jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
jLabel4 = new javax.swing.JLabel();
jLabel5 = new javax.swing.JLabel();
jLabel6 = new javax.swing.JLabel();
txtFirstname = new javax.swing.JTextField();
txtStudentID = new javax.swing.JTextField();
txtAddress = new javax.swing.JTextField();
txtSurname = new javax.swing.JTextField();
txtMobile = new javax.swing.JTextField();
cboGender = new javax.swing.JComboBox<>();
jPanel3 = new javax.swing.JPanel();
jLabel7 = new javax.swing.JLabel();
jLabel8 = new javax.swing.JLabel();
jLabel9 = new javax.swing.JLabel();
jLabel10 = new javax.swing.JLabel();
cboGraphic = new javax.swing.JComboBox<>();
cboDatabase = new javax.swing.JComboBox<>();
cboScience = new javax.swing.JComboBox<>();
cboEnglish = new javax.swing.JComboBox<>();
jPanel8 = new javax.swing.JPanel();
jLabel11 = new javax.swing.JLabel();
cboMaths = new javax.swing.JComboBox<>();
cboGames = new javax.swing.JComboBox<>();
jLabel12 = new javax.swing.JLabel();
jLabel13 = new javax.swing.JLabel();
jLabel14 = new javax.swing.JLabel();
cboAnalysis = new javax.swing.JComboBox<>();
cboDataSci = new javax.swing.JComboBox<>();
jPanel6 = new javax.swing.JPanel();
btnPrint = new javax.swing.JButton();
btnUpdate = new javax.swing.JButton();
btnReset = new javax.swing.JButton();
btnDelete = new javax.swing.JButton();
btnExit = new javax.swing.JButton();
btnAddNew = new javax.swing.JButton();
jPanel9 = new javax.swing.JPanel();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
getContentPane().setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());
jPanel2.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(95, 158, 160), 4));
jPanel2.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());
jPanel4.setBackground(new java.awt.Color(0, 153, 255));
jPanel4.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.LOWERED));
jPanel4.setFont(new java.awt.Font("Tahoma", 1, 48)); // NOI18N
jPanel4.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());
jLabel15.setBackground(new java.awt.Color(0, 153, 255));
jLabel15.setFont(new java.awt.Font("Tahoma", 1, 60)); // NOI18N
jLabel15.setText("Student Management Systems Using Java");
jLabel15.setToolTipText("");
jPanel4.add(jLabel15, new org.netbeans.lib.awtextra.AbsoluteConstraints(30, 10, -1, -1));
jPanel2.add(jPanel4, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 10, 1340, 90));
jPanel5.setBackground(new java.awt.Color(0, 153, 255));
jPanel5.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.LOWERED));
jPanel5.setFont(new java.awt.Font("Tahoma", 1, 48)); // NOI18N
jPanel5.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());
jPanel1.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(95, 158, 160), 4));
jPanel1.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());
jTable1.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
},
new String [] {
"ID", "Student ID", "Firstname", "Surname", "Address", "Gender", "Mobile", "Maths", "Games", "Data Sci", "Analysis", "Graphic", "Database", "Science", "English"
}
) {
Class[] types = new Class [] {
java.lang.Object.class, java.lang.Integer.class, java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.Integer.class, java.lang.Object.class, java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.String.class
};
public Class getColumnClass(int columnIndex) {
return types [columnIndex];
}
});
jTable1.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
jTable1MouseClicked(evt);
}
});
jScrollPane1.setViewportView(jTable1);
jPanel1.add(jScrollPane1, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 10, 870, 380));
jPanel5.add(jPanel1, new org.netbeans.lib.awtextra.AbsoluteConstraints(440, 10, 890, 410));
jPanel7.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(95, 158, 160), 4));
jPanel7.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());
jLabel1.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
jLabel1.setText("Mobile");
jPanel7.add(jLabel1, new org.netbeans.lib.awtextra.AbsoluteConstraints(240, 180, -1, -1));
jLabel2.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
jLabel2.setText("Student ID");
jPanel7.add(jLabel2, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 20, -1, -1));
jLabel3.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
jLabel3.setText("Firstname");
jPanel7.add(jLabel3, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 60, -1, -1));
jLabel4.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
jLabel4.setText("Surname");
jPanel7.add(jLabel4, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 110, -1, -1));
jLabel5.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
jLabel5.setText("Address");
jPanel7.add(jLabel5, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 150, -1, -1));
jLabel6.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
jLabel6.setText("Gender");
jPanel7.add(jLabel6, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 190, -1, -1));
txtFirstname.setFont(new java.awt.Font("Tahoma", 0, 18)); // NOI18N
jPanel7.add(txtFirstname, new org.netbeans.lib.awtextra.AbsoluteConstraints(110, 60, 300, -1));
txtStudentID.setFont(new java.awt.Font("Tahoma", 0, 18)); // NOI18N
jPanel7.add(txtStudentID, new org.netbeans.lib.awtextra.AbsoluteConstraints(110, 20, 300, -1));
txtAddress.setFont(new java.awt.Font("Tahoma", 0, 18)); // NOI18N
jPanel7.add(txtAddress, new org.netbeans.lib.awtextra.AbsoluteConstraints(110, 140, 300, -1));
txtSurname.setFont(new java.awt.Font("Tahoma", 0, 18)); // NOI18N
jPanel7.add(txtSurname, new org.netbeans.lib.awtextra.AbsoluteConstraints(110, 100, 300, -1));
txtMobile.setFont(new java.awt.Font("Tahoma", 0, 18)); // NOI18N
jPanel7.add(txtMobile, new org.netbeans.lib.awtextra.AbsoluteConstraints(310, 180, 100, -1));
cboGender.setFont(new java.awt.Font("Tahoma", 0, 18)); // NOI18N
cboGender.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "", "Female", "Male", "" }));
jPanel7.add(cboGender, new org.netbeans.lib.awtextra.AbsoluteConstraints(110, 180, 120, -1));
jPanel3.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.LOWERED));
jPanel3.setFont(new java.awt.Font("Tahoma", 1, 48)); // NOI18N
jPanel3.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());
jLabel7.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
jLabel7.setText("Graphic");
jPanel3.add(jLabel7, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 10, -1, -1));
jLabel8.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
jLabel8.setText("Database");
jPanel3.add(jLabel8, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 50, -1, -1));
jLabel9.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
jLabel9.setText("Science");
jPanel3.add(jLabel9, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 90, -1, -1));
jLabel10.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
jLabel10.setText("English");
jPanel3.add(jLabel10, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 130, -1, -1));
cboGraphic.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
cboGraphic.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "No", "Yes", "Core Unit", "Complete" }));
jPanel3.add(cboGraphic, new org.netbeans.lib.awtextra.AbsoluteConstraints(100, 10, 90, 30));
cboDatabase.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
cboDatabase.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "No", "Yes", "Core Unit", "Complete" }));
jPanel3.add(cboDatabase, new org.netbeans.lib.awtextra.AbsoluteConstraints(100, 50, 90, 30));
cboScience.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
cboScience.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "No", "Yes", "Core Unit", "Complete" }));
jPanel3.add(cboScience, new org.netbeans.lib.awtextra.AbsoluteConstraints(100, 90, 90, 30));
cboEnglish.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
cboEnglish.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "No", "Yes", "Core Unit", "Complete" }));
jPanel3.add(cboEnglish, new org.netbeans.lib.awtextra.AbsoluteConstraints(100, 130, 90, 30));
jPanel7.add(jPanel3, new org.netbeans.lib.awtextra.AbsoluteConstraints(210, 220, 200, 170));
jPanel8.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.LOWERED));
jPanel8.setFont(new java.awt.Font("Tahoma", 1, 48)); // NOI18N
jPanel8.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());
jLabel11.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
jLabel11.setText("Maths");
jPanel8.add(jLabel11, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 20, -1, -1));
cboMaths.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
cboMaths.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "No", "Yes", "Core Unit", "Complete" }));
jPanel8.add(cboMaths, new org.netbeans.lib.awtextra.AbsoluteConstraints(100, 10, 90, 30));
cboGames.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
cboGames.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "No", "Yes", "Core Unit", "Complete" }));
jPanel8.add(cboGames, new org.netbeans.lib.awtextra.AbsoluteConstraints(100, 50, 90, 30));
jLabel12.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
jLabel12.setText("Games");
jPanel8.add(jLabel12, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 60, -1, -1));
jLabel13.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
jLabel13.setText("Data Sci");
jPanel8.add(jLabel13, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 100, -1, -1));
jLabel14.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
jLabel14.setText("Analysis");
jPanel8.add(jLabel14, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 140, -1, -1));
cboAnalysis.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
cboAnalysis.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "No", "Yes", "Core Unit", "Complete" }));
jPanel8.add(cboAnalysis, new org.netbeans.lib.awtextra.AbsoluteConstraints(100, 130, 90, 30));
cboDataSci.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N
cboDataSci.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "No", "Yes", "Core Unit", "Complete" }));
jPanel8.add(cboDataSci, new org.netbeans.lib.awtextra.AbsoluteConstraints(100, 90, 90, 30));
jPanel7.add(jPanel8, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 220, 200, 170));
jPanel5.add(jPanel7, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 10, 420, 410));
jPanel6.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(95, 158, 160), 4));
jPanel6.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());
btnPrint.setBackground(new java.awt.Color(0, 153, 255));
btnPrint.setFont(new java.awt.Font("Tahoma", 1, 36)); // NOI18N
btnPrint.setText("Print");
btnPrint.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnPrintActionPerformed(evt);
}
});
jPanel6.add(btnPrint, new org.netbeans.lib.awtextra.AbsoluteConstraints(220, 10, 212, 60));
btnUpdate.setBackground(new java.awt.Color(0, 153, 255));
btnUpdate.setFont(new java.awt.Font("Tahoma", 1, 36)); // NOI18N
btnUpdate.setText("Update");
btnUpdate.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnUpdateActionPerformed(evt);
}
});
jPanel6.add(btnUpdate, new org.netbeans.lib.awtextra.AbsoluteConstraints(440, 10, 212, 60));
btnReset.setBackground(new java.awt.Color(0, 153, 255));
btnReset.setFont(new java.awt.Font("Tahoma", 1, 36)); // NOI18N
btnReset.setText("Reset");
btnReset.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnResetActionPerformed(evt);
}
});
jPanel6.add(btnReset, new org.netbeans.lib.awtextra.AbsoluteConstraints(660, 10, 212, 60));
btnDelete.setBackground(new java.awt.Color(0, 153, 255));
btnDelete.setFont(new java.awt.Font("Tahoma", 1, 36)); // NOI18N
btnDelete.setText("Delete");
btnDelete.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnDeleteActionPerformed(evt);
}
});
jPanel6.add(btnDelete, new org.netbeans.lib.awtextra.AbsoluteConstraints(880, 10, 212, 60));
btnExit.setBackground(new java.awt.Color(0, 153, 255));
btnExit.setFont(new java.awt.Font("Tahoma", 1, 36)); // NOI18N
btnExit.setText("Exit");
btnExit.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnExitActionPerformed(evt);
}
});
jPanel6.add(btnExit, new org.netbeans.lib.awtextra.AbsoluteConstraints(1100, 10, 212, 60));
btnAddNew.setBackground(new java.awt.Color(0, 153, 255));
btnAddNew.setFont(new java.awt.Font("Tahoma", 1, 36)); // NOI18N
btnAddNew.setText("Add New");
btnAddNew.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnAddNewActionPerformed(evt);
}
});
jPanel6.add(btnAddNew, new org.netbeans.lib.awtextra.AbsoluteConstraints(12, 10, 200, 60));
jPanel5.add(jPanel6, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 430, 1320, 80));
jPanel2.add(jPanel5, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 100, 1340, 520));
getContentPane().add(jPanel2, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, 1360, 640));
javax.swing.GroupLayout jPanel9Layout = new javax.swing.GroupLayout(jPanel9);
jPanel9.setLayout(jPanel9Layout);
jPanel9Layout.setHorizontalGroup(
jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGap(0, 770, Short.MAX_VALUE)
);
jPanel9Layout.setVerticalGroup(
jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGap(0, 100, Short.MAX_VALUE)
);
getContentPane().add(jPanel9, new org.netbeans.lib.awtextra.AbsoluteConstraints(120, 690, 770, -1));
pack();
setLocationRelativeTo(null);
}// </editor-fold>
private void btnResetActionPerformed(java.awt.event.ActionEvent evt) {
txtStudentID.setText("");
txtFirstname.setText("");
txtSurname.setText("");
txtAddress.setText("");
cboGender.setSelectedIndex(0);
txtMobile.setText("");
cboMaths.setSelectedIndex(0);
cboGames.setSelectedIndex(0);
cboDataSci.setSelectedIndex(0);
cboAnalysis.setSelectedIndex(0);
cboGraphic.setSelectedIndex(0);
cboDatabase.setSelectedIndex(0);
cboScience.setSelectedIndex(0);
cboEnglish.setSelectedIndex(0);
DefaultTableModel RecordTable = (DefaultTableModel) jTable1.getModel();
RecordTable.setRowCount(0);
}
private JFrame frame;
private void btnExitActionPerformed(java.awt.event.ActionEvent evt) {
frame = new JFrame("Exit");
if (JOptionPane.showConfirmDialog(frame, "Confirm if you want to exit","Student Management Systems",
JOptionPane.YES_NO_OPTION)==JOptionPane.YES_NO_OPTION){
System.exit(0);
}
}
private void btnAddNewActionPerformed(java.awt.event.ActionEvent evt) {
try
{
Class.forName("com.mysql.jdbc.Driver");
sqlConn = DriverManager.getConnection(dataConn,username,password);
pst = sqlConn.prepareStatement("insert into studentdata(studentid,firstname,surname,address,"
+ "gender,mobile,maths,games,datasci,analysis,graphic,database1,science,english)values"
+ "(?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
pst.setString(1, txtStudentID.getText());
pst.setString(2, txtFirstname.getText());
pst.setString(3, txtSurname.getText());
pst.setString(4, txtAddress.getText());
pst.setString(5, (String) cboGender.getSelectedItem());
pst.setString(6, txtMobile.getText());
pst.setString(7, (String)cboMaths.getSelectedItem());
pst.setString(8, (String)cboGames.getSelectedItem());
pst.setString(9, (String)cboDataSci.getSelectedItem());
pst.setString(10, (String)cboAnalysis.getSelectedItem());
pst.setString(11, (String)cboGraphic.getSelectedItem());
pst.setString(12, (String)cboDatabase.getSelectedItem());
pst.setString(13, (String)cboScience.getSelectedItem());
pst.setString(14, (String)cboEnglish.getSelectedItem());
pst.executeUpdate();
JOptionPane.showMessageDialog(this,"Student Record Added");
updateDB();
}
catch (ClassNotFoundException ex) {
java.util.logging.Logger.getLogger(StudentDBMysql.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (SQLException ex) {
//System.err.println(ex);
java.util.logging.Logger.getLogger(StudentDBMysql.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
}
}
private void btnUpdateActionPerformed(java.awt.event.ActionEvent evt) {
DefaultTableModel RecordTable = (DefaultTableModel)jTable1.getModel();
int SelectedRows = jTable1.getSelectedRow();
try
{
//int id
id = Integer.parseInt(RecordTable.getValueAt(SelectedRows, 0).toString());
Class.forName("com.mysql.jdbc.Driver");
sqlConn = DriverManager.getConnection(dataConn,username,password);
pst = sqlConn.prepareStatement("update studentdata set studentid =?,firstname=?,surname=?,"
+ "address=?,gender=?,mobile=?,maths=?,games=?,datasci=?,analysis=?,graphic=?,"
+ "database1=?,science=?,english=? where id =?");
pst.setString(1, txtStudentID.getText());
pst.setString(2, txtFirstname.getText());
pst.setString(3, txtSurname.getText());
pst.setString(4, txtAddress.getText());
pst.setString(5, (String) cboGender.getSelectedItem());
pst.setString(6, txtMobile.getText());
pst.setString(7, (String)cboMaths.getSelectedItem());
pst.setString(8, (String)cboGames.getSelectedItem());
pst.setString(9, (String)cboDataSci.getSelectedItem());
pst.setString(10, (String)cboAnalysis.getSelectedItem());
pst.setString(11, (String)cboGraphic.getSelectedItem());
pst.setString(12, (String)cboDatabase.getSelectedItem());
pst.setString(13, (String)cboScience.getSelectedItem());
pst.setString(14, (String)cboEnglish.getSelectedItem());
pst.setInt(15, id);
pst.executeUpdate();
JOptionPane.showMessageDialog(this,"Student Record updated");
updateDB();
}
catch (ClassNotFoundException ex) {
java.util.logging.Logger.getLogger(StudentDBMysql.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (SQLException ex) {
System.err.println(ex);
}
}
private void jTable1MouseClicked(java.awt.event.MouseEvent evt) {
DefaultTableModel RecordTable = (DefaultTableModel)jTable1.getModel();
int SelectedRows = jTable1.getSelectedRow();
txtStudentID.setText(RecordTable.getValueAt(SelectedRows, 1).toString());
txtFirstname.setText(RecordTable.getValueAt(SelectedRows, 2).toString());
txtSurname.setText(RecordTable.getValueAt(SelectedRows, 3).toString());
txtAddress.setText(RecordTable.getValueAt(SelectedRows, 4).toString());
cboGender.setSelectedItem(RecordTable.getValueAt(SelectedRows, 5).toString());
txtMobile.setText(RecordTable.getValueAt(SelectedRows, 6).toString());
cboMaths.setSelectedItem(RecordTable.getValueAt(SelectedRows, 7).toString());
cboGames.setSelectedItem(RecordTable.getValueAt(SelectedRows, 8).toString());
cboDataSci.setSelectedItem(RecordTable.getValueAt(SelectedRows, 9).toString());
cboAnalysis.setSelectedItem(RecordTable.getValueAt(SelectedRows, 10).toString());
cboGraphic.setSelectedItem(RecordTable.getValueAt(SelectedRows, 11).toString());
cboDatabase.setSelectedItem(RecordTable.getValueAt(SelectedRows, 12).toString());
cboScience.setSelectedItem(RecordTable.getValueAt(SelectedRows, 13).toString());
cboEnglish.setSelectedItem(RecordTable.getValueAt(SelectedRows, 14).toString());
}
private void btnPrintActionPerformed(java.awt.event.ActionEvent evt) {
MessageFormat header = new MessageFormat("Printing in progress");
MessageFormat footer = new MessageFormat("Page {0, number, integer}");
try
{
jTable1.print(JTable.PrintMode.NORMAL,header,footer);
}
catch(java.awt.print.PrinterException e)
{
System.err.format("No Printer found", e.getMessage());
}
}
private void btnDeleteActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
DefaultTableModel RecordTable = (DefaultTableModel)jTable1.getModel();
int SelectedRows = jTable1.getSelectedRow();
try
{
//int id
id = Integer.parseInt(RecordTable.getValueAt(SelectedRows, 0).toString());
//int deleteItem
deleteItem = JOptionPane.showConfirmDialog(null,"Confirm if you want to delete item",
"Warning",JOptionPane.YES_NO_OPTION);
if (deleteItem ==JOptionPane.YES_OPTION )
{
Class.forName("com.mysql.jdbc.Driver");
sqlConn = DriverManager.getConnection(dataConn,username,password);
pst = sqlConn.prepareStatement("delete from studentdata where id =?");
pst.setInt(1, id);
pst.executeUpdate();
JOptionPane.showMessageDialog(this,"Student Record updated");
updateDB();
txtStudentID.setText("");
txtStudentID.requestFocus();
txtFirstname.setText("");
txtSurname.setText("");
txtAddress.setText("");
cboGender.setSelectedIndex(0);
txtMobile.setText("");
cboMaths.setSelectedIndex(0);
cboGames.setSelectedIndex(0);
cboDataSci.setSelectedIndex(0);
cboAnalysis.setSelectedIndex(0);
cboGraphic.setSelectedIndex(0);
cboDatabase.setSelectedIndex(0);
cboScience.setSelectedIndex(0);
cboEnglish.setSelectedIndex(0);
}
}
catch (ClassNotFoundException ex) {
java.util.logging.Logger.getLogger(StudentDBMysql.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
} catch (SQLException ex) {
System.err.println(ex);
}
}
About The Student Management System In Java
Project Name: | Student Management System |
Language/s Used: | JAVA |
Database: | MySQL |
Type: | Desktop Application |
Developer: | IT SOURCECODE |
Updates: | 0 |
Downloadable Source Code Below.
Admin
Username: Admin
Password: pass
Summary
The Student Management System Project In Java is built fully in Java and MySQL Database. It has full-featured Graphical User Interface (GUI) with all the functionalities
This Article is the way to enhance and develop our skills and logic ideas which is important in practicing the Java programming language which is most well known and most usable programming language in many company.
Related article below
- Best Java Projects With Source Code For Beginners Free Download 2021
- Load data from MySQL database to Combo box Using Java
- How to use Scanner in Java Tutorial Using Netbeans IDE
- Update Data using MySQL Database and Java with Netbeans IDE
- Join Two String Value using MySQL CONCAT Function in Java
- How to convert text to speech in Java Tutorial using Netbeans IDE
- How to Load data from Mysql Database to Table Element Using Java
Inquiries
If you have any questions or suggestions about Student Management System Project In Java With Source Code, please feel free to leave a comment below.
Can you please give how to create MySQL database for this project?
If you have then please send me also
Hello sir how to setup this project can you tell me about it?