This article shares with you the implementation of the student management system based on MySQL for your reference. The specific content is as follows
Because the laboratory had to hand in the homework, it built a student management system and posted a code to commemorate it. The interface and other things were too urgent were poor.
There are still some small details that are not perfect, but can still achieve the main functions.
Window is the main interface
package First; import java.sql.*; import java.awt.*; import java.awt.event.*; import javax.swing.*; public class Window { public static void main(String[] args){ JFrame jframe = new JFrame("Student Management System"); //window Dimension d = new Dimension(400,300); Point p = new Point (250,350); jframe.setSize(d); jframe.setLocation(p); jframe.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); jframe.setVisible(true); JButton button1 = new JButton("Add"); JButton button2 = new JButton("Modify"); JButton button3 = new JButton("Query"); JButton button4 = new JButton("Delete"); JButton button5 = new JButton("Browse"); FlowLayout flow = new FlowLayout(FlowLayout.LEFT,10,10); JPanel panel = new JPanel(flow); panel.add(button1); panel.add(button2); panel.add(button3); panel.add(button4); panel.add(button5); jframe.add(panel); button1.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ Add add = new Add(); } }); button2.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ Change change = new Change(); } }); button3.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ Ask ask = new Ask(); } }); button4.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ Delete delete = new Delete(); } }); button5.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ Look look = new Look(); } }); } }Add is added
package First; import java.sql.*; import java.awt.*; import java.awt.event.*; import javax.swing.*; import com.mysql.jdbc.Driver; import First.Window; public class Add extends JFrame { private static final long serialVersionUID = -1928970409928880648L; JLabel jlnumber = new JLabel("Student number:"); JLabel jlname = new JLabel("Name:"); JLabel jlsex = new JLabel("Gender:"); JLabel jlbirthday = new JLabel("Date of Birth:"); JLabel jldepartment = new JLabel("College:"); JTextField jtnumber = new JTextField("",20); JTextField jtname = new JTextField("",20); JTextField jtsex = new JTextField("",20); JTextField jtbirthday = new JTextField("",20); JTextField jtdepartment = new JTextField("",20); JButton buttonadd = new JButton("Add"); JButton buttonreturn = new JButton("Return"); public Add() { JPanel jpnumber = new JPanel(); JPanel jpname = new JPanel(); JPanel jpsex = new JPanel(); JPanel jpbirthday = new JPanel(); JPanel jpdepartment = new JPanel(); JPanel jpforbutton = new JPanel(new GridLayout(1,1)); jpnumber.add(jlnumber); jpnumber.add(jtnumber); jpname.add(jlname); jpname.add(jtname); jpsex.add(jlsex); jpsex.add(jtsex); jpbirthday.add(jlbirthday); jpbirthday.add(jtbirthday); jpdepartment.add(jldepartment); jpforbutton.add(buttonadd); jpforbutton.add(buttonreturn); buttonadd.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ //Add Connection conn = null; Statement stat = null; PreparedStatement ps=null; String sql = "INSERT INTO student(number,name,sex,birthday,department) " + "values(?,?,?,?,?)"; try{ Class.forName("Driver"); System.out.println("JBDC loaded successfully!"); }catch(Exception a){ System.out.println("JBDC dog belt!"); a.printStackTrace(); } try{ conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/javaStu","root","123"); ps=conn.prepareStatement(sql); ps.setString(1,jtnumber.getText()); ps.setString(2,jtname.getText()); ps.setString(3,jtsex.getText()); ps.setString(4,jtbirthday.getText()); ps.setString(5,jtdepartment.getText()); ps.executeUpdate(); //System.out.println("MySQL connection succeeded!"); //stat = conn.createStatement(); //stat.executeUpdate(sql); //System.out.println("Insert data successfully!"); }catch (SQLException b){ b.printStackTrace(); } finally{ try{ conn.close(); System.out.println("MySQL shutdown succeeded"); }catch (SQLException c){ System.out.println("MySQL shutdown failed"); c.printStackTrace(); } } } ); buttonreturn.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ Window window = new Window(); } }); this.setTitle("Add student information"); this.setLayout(new GridLayout(9,1)); this.add(jpnumber); this.add(jpname); this.add(jpsex); this.add(jpbirthday); this.add(jpdepartment); this.add(jpforbutton); this.setLocation(400,300); this.setSize(350,300); this.setVisible(true); } }Ask is a query
package First; import java.sql.*; import java.awt.*; import java.awt.event.*; import javax.swing.*; import First.Window; public class Ask extends JFrame { private static final long serialVersionUID = -1928970409928880648L; JLabel jlnumber = new JLabel("Student number:"); JLabel jlname = new JLabel("Name:"); JLabel jlsex = new JLabel("Gender:"); JLabel jlbirthday = new JLabel("Date of Birth:"); JLabel jldepartment = new JLabel("College:"); JTextField jtnumber = new JTextField("",20); JLabel jname = new JLabel(); JLabel jsex = new JLabel(); JLabel jbirthday = new JLabel(); JLabel jdepartment = new JLabel(); JButton buttonask = new JButton("Query"); JButton buttonreturn = new JButton("return"); public Ask() { JPanel jpnumber = new JPanel(); JPanel jpname = new JPanel(); JPanel jpsex = new JPanel(); JPanel jpbirthday = new JPanel(); JPanel jpdepartment = new JPanel(); JPanel jpforbutton = new JPanel(new GridLayout(1,1)); jpnumber.add(jlnumber); jpnumber.add(jtnumber); jpname.add(jlname); jpname.add(jname); jpsex.add(jlsex); jpsex.add(jsex); jpbirthday.add(jlbirthday); jpbirthday.add(jbirthday); jpdepartment.add(jldepartment); jpdepartment.add(jdepartment); jpforbutton.add(buttonreturn); buttonask.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ Connection conn = null; ResultSet res = null; Statement stat = null; String sql = "SELECT number,name,sex,birthday,department FROM student;"; try{ Class.forName("com.mysql.jdbc.Driver"); }catch(Exception d){ System.out.println("jdbc fall"); d.printStackTrace(); } try{ conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/javaStu","root","123"); stat=conn.createStatement(); res=stat.executeQuery(sql); while (res.next()) { if (res.getString(1).equals(jtnumber.getText()))) { jname.setText(res.getString(2)); jsex.setText(res.getString(3)); jbirthday.setText(res.getString(4)); jdepartment.setText(res.getString(5)); break; } } } catch (SQLException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } finally{ try{ conn.close(); } catch(SQLException ar){ ar.printStackTrace(); } }}} ); buttonreturn.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ Window window = new Window(); } }); this.setTitle("Query student information"); this.setLayout(new GridLayout(9,1)); this.add(jpnumber); this.add(jpname); this.add(jpsex); this.add(jpbirthday); this.add(jpdepartment); this.add(jpforbutton); this.setLocation(400,300); this.setSize(350,300); this.setVisible(true); } }Change is modified
package First; import java.sql.*; import java.awt.*; import java.awt.event.*; import javax.swing.*; import First.Window; public class Change extends JFrame { private static final long serialVersionUID = -1928970409928880648L; JLabel jlnumber = new JLabel("Student number:"); JLabel jlname = new JLabel("Name:"); JLabel jlsex = new JLabel("Gender:"); JLabel jlbirthday = new JLabel("Date of Birth:"); JLabel jldepartment = new JLabel("College:"); JTextField jtnumber = new JTextField("",20); JTextField jtname = new JTextField("",20); JTextField jttsex = new JTextField("",20); JTextField jtbirthday = new JTextField("",20); JTextField jtdepartment = new JTextField("",20); JButton buttonchange = new JButton("Modify"); JButton buttonreturn = new JButton("Return"); public Change() { JPanel jpnumber = new JPanel(); JPanel jpname = new JPanel(); JPanel jpsex = new JPanel(); JPanel jpbirthday = new JPanel(); JPanel jpdepartment = new JPanel(); JPanel jpforbutton = new JPanel(new GridLayout(1,1)); jpnumber.add(jlnumber); jpnumber.add(jtnumber); jpname.add(jlname); jpname.add(jtname); jpsex.add(jlsex); jpsex.add(jtsex); jpbirthday.add(jlbirthday); jpbirthday.add(jtbirthday); jpdepartment.add(jldepartment); jpdepartment.add(jtdepartment); jpforbutton.add(buttonreturn); buttonchange.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ String number = jtnumber.getText(); String name = jtname.getText(); String sex = jttsex.getText(); String birthday = jtbirthday.getText(); String department = jtdepartment.getText(); Connection conn = null; ResultSet res = null; Statement stat = null; String sql = "SELECT number,name,sex,birthday,department FROM student;"; try{ Class.forName("com.mysql.jdbc.Driver"); } catch(Exception d){ System.out.println("jdbc fall"); d.printStackTrace(); } try{ conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/javaStu","root","123"); stat=conn.createStatement(); res=stat.executeQuery(sql); while (res.next()) { //change if (res.getString(1).equals(jtnumber.getText())) { try{ Class.forName("com.mysql.jdbc.Driver"); }catch(Exception d){ System.out.println("jdbc fall"); d.printStackTrace(); } String sql2="UPDATE student SET name='"+name+"' WHERE number='"+jtnumber.getText()+"'"; String sql3="UPDATE student SET sex='"+sex+"' WHERE number='"+jtnumber.getText()+"'"; String sql4="UPDATE student SET birthday='"+birthday+"' WHERE number='"+jtnumber.getText()+"'"; String sql5="UPDATE student SET department='"+department+"' WHERE number='"+jtnumber.getText()+"'"; try { conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/javaStu","root","123"); stat=conn.createStatement(); stat.executeUpdate(sql2); stat.executeUpdate(sql3); stat.executeUpdate(sql4); stat.executeUpdate(sql5); } catch (SQLException g) { // TODO Auto-generated catch block g.printStackTrace(); }try{ stat.close(); conn.close(); }catch(SQLException ar){ ar.printStackTrace(); } break; } //change end } }catch (SQLException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } finally{ try{ conn.close(); } catch(SQLException ar){ ar.printStackTrace(); } } } }); buttonreturn.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ Window window = new Window(); } }); this.setTitle("Modify student information"); this.setLayout(new GridLayout(9,1)); this.add(jpnumber); this.add(jpname); this.add(jpsex); this.add(jpbirthday); this.add(jpdepartment); this.add(jpforbutton); this.setLocation(400,300); this.setSize(350,300); this.setVisible(true); } }Delete is delete
package First; import java.sql.*; import java.awt.*; import java.awt.event.*; import javax.swing.*; import First.Window; public class Delete extends JFrame { private static final long serialVersionUID = -1928970409928880648L; JLabel jlnumber = new JLabel("Student number:"); JTextField jtnumber = new JTextField("",20); JButton buttondelete = new JButton("Delete"); JButton buttonreturn = new JButton("Return"); public Delete() { JPanel jpnumber = new JPanel(); JPanel jpforbutton = new JPanel(new GridLayout(1,1)); jpnumber.add(jlnumber); jpnumber.add(jtnumber); jpforbutton.add(buttondelete); jpforbutton.add(buttonreturn); buttondelete.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ String number = jtnumber.getText(); Connection conn = null; ResultSet res = null; Statement stat = null; String sql = "DELETE FROM student WHERE number='"+number+"'"; try{ Class.forName("com.mysql.jdbc.Driver"); }catch(Exception a){ a.printStackTrace(); } try{ conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/javaStu","root","123"); stat = conn.createStatement(); stat.executeUpdate(sql); }catch(SQLException h){ h.printStackTrace(); } finally{ try{ conn.close(); System.out.println("close success!"); }catch(SQLException j){ System.out.println("close go die!"); j.printStackTrace(); } } } }); buttonreturn.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ Window window = new Window(); } }); this.setTitle("Delete Student Information"); this.setLayout(new GridLayout(9,1)); this.add(jpnumber); this.add(jpforbutton); this.setLocation(400,300); this.setSize(350,300); this.setVisible(true); } }Look is browsing
package First; import java.sql.*; import java.awt.*; import java.awt.event.*; import javax.swing.*; import java.util.*; import First.Window; public class Look extends JFrame { private static final long serialVersionUID = -1928970409928880648L; Connection conn = null; PreparedStatement ps = null; ResultSet res = null; //JButton buttonlook = new JButton("Browse"); //JButton buttonreturn = new JButton("Return"); JTable jtable; JScrollPane jscrollpane = new JScrollPane(); Vector columnNames = null; Vector rowData = null; public Look() { JPanel jpforbutton = new JPanel(new GridLayout(1,1)); columnNames = new Vector(); columnNames.add("Student number"); columnNames.add("Name"); columnNames.add("Gender"); columnNames.add("Date of Birth"); columnNames.add("College"); rowData = new Vector(); //jpforbutton.add(buttonlook); //jpforbutton.add(buttonreturn); try { Class.forName("com.mysql.jdbc.Driver"); conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/javaStu","root","123"); ps = conn.prepareStatement("SELECT * FROM student"); res = ps.executeQuery(); while (res.next()) { Vector hang = new Vector(); hang.add(res.getString(1)); hang.add(res.getString(2)); hang.add(res.getString(3)); hang.add(res.getString(4)); hang.add(res.getString(5)); rowData.add(hang); } System.out.println("load ok!"); } catch (Exception q){ q.printStackTrace(); System.out.println("go die"); } finally{ try{ res.close(); ps.close(); conn.close(); System.out.println("close ok"); } catch (SQLException o){ o.printStackTrace(); System.out.println("go die 2"); } } jtable = new JTable(rowData,columnNames); jscrollpane = new JScrollPane(jtable); this.add(jscrollpane); this.setTitle("Browse Student Information"); this.setLayout(new GridLayout(2,5)); this.add(jpforbutton); this.setLocation(300,300); this.setSize(500,300); this.setVisible(true); this.setResizable(false); } }Some running interfaces:
For more learning materials, please pay attention to the special topic "Management System Development".
The above is all the content of this article. I hope it will be helpful to everyone's learning and I hope everyone will support Wulin.com more.