Dieser Artikel teilt mit Ihnen die Implementierung des Student -Management -Systems auf der Grundlage von MySQL als Referenz. Der spezifische Inhalt ist wie folgt
Da das Labor die Hausaufgaben übergeben musste, baute es ein Student -Management -System auf und veröffentlichte einen Code, um es zu erinnern. Die Schnittstelle und andere Dinge waren zu dringend schlecht.
Es gibt immer noch einige kleine Details, die nicht perfekt sind, aber dennoch die Hauptfunktionen erzielen können.
Fenster ist die Hauptschnittstelle
Paket zuerst; Java.sql.*importieren; import Java.awt.*; import Java.awt.event.*; Javax.swing importieren.*; Public Class Fenster {public static void main (String [] args) {jframe jframe = new JFrame ("Student Management System"); // Fensterdimension D = neue Dimension (400.300); Punkt p = neuer Punkt (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 ("Abfrage"); Jbutton Button4 = New Jbutton ("Delete"); Jbutton Button5 = neuer Jbutton ("Browse"); FlowLayout Flow = New FlowLayout (FlowLayout.Left, 10,10); Jpanel panel = new Jpanel (Flow); Panel.Add (Taste1); Panel.Add (Taste2); Panel.Add (Taste3); panel.Add (button4); Panel.Add (Taste5); Jframe.Add (Panel); button1.addactionListener (new ActionListener () {public void actionPerformed (actionEvent e) {add = new add ();}}); button2.AddactionListener (new ActionListener () {public void actionPerformed (actionEvent e) {Änderung = new Change ();}}); button3.AddactionListener (new ActionListener () {public void actionPerformed (actionEvent e) {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 = new Look ();}}); }}Add wird hinzugefügt
Paket zuerst; Java.sql.*importieren; import Java.awt.*; import Java.awt.event.*; Javax.swing importieren.*; import com.mysql.jdbc.driver; importieren.Window; öffentliche Klasse Add Extends JFrame {private statische endgültige lange Serialversionuid = -1928970409928880648L; Jlabel Jlnumber = new JLabel ("Studentnummer:"); Jlabel Jlname = new Jlabel ("Name:"); JLabel JlSEX = new JLabel ("Geschlecht:"); Jlabel Jlbirthday = new Jlabel ("Geburtsdatum:"); 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) {// Verbindung add conn = null; Statement stat = null; prepedStatement ps = null; String SQL = "In Schüler einfügen (Nummer, Name, Sexual", Abteilung) " +" -Werte (Tribut) (Tribut). System.out.println ("JBDC erfolgreich geladen!"); PS = CONN.PREPARESTATEMENT (SQL); Ps.SetStRing (5, JTDepartment.GETTEXT ()); (SQLEXTE B) {B.PrintstackTrace (); ButtonReturn.AddactionListener (new ActionListener () {public void actionPerformed (actionEvent e) {window window = new window ();}}); this.settitle ("Schülerinformationen hinzufügen"); this.setLayout (neuer 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); }}Fragen Sie eine Frage
Paket zuerst; Java.sql.*importieren; import Java.awt.*; import Java.awt.event.*; Javax.swing importieren.*; importieren.Window; öffentliche Klasse Ask erweitert JFrame {private statische endgültige lange Serialversionuid = -1928970409928880648L; Jlabel Jlnumber = new JLabel ("Studentnummer:"); Jlabel Jlname = new Jlabel ("Name:"); JLabel JlSEX = new JLabel ("Geschlecht:"); Jlabel Jlbirthday = new Jlabel ("Geburtsdatum:"); 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 ("Abfrage"); 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) {Verbindung conn = null; resultSet res = null; Statement stat = null; String SQL = "Ausgewählte Nummer, Name, Sex, Geburtstag, Abteilung von Student;"; try {class.forname ("com.mysql.jdbc.driver"); System.out.println ("JDBC Fall"); {if (res.getString (1) .equals (jtnumber.Getext ())) {jname.setText (res.getString (2)); JSEX.SetText (Res.GetString (3)); Jbirthday.setText (Res.GetString (4)); jdepartment.setText (res.getString (5)); brechen; }}} catch (SQLEXception E1) {// todo automatisch generiertes Block e1.printstacktrace (); } endlich {try {conn.close (); } catch (sqlexception ar) {ar.printstacktrace (); }}}}); ButtonReturn.AddactionListener (new ActionListener () {public void actionPerformed (actionEvent e) {window window = new window ();}}); this.settitle ("Studentinformationen abfragen"); this.setLayout (neuer 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); }}Änderung wird geändert
Paket zuerst; Java.sql.*importieren; import Java.awt.*; import Java.awt.event.*; Javax.swing importieren.*; importieren.Window; Public Class Change erweitert JFrame {private statische endgültige lange Serialversionuid = -1928970409928880648L; Jlabel Jlnumber = new JLabel ("Studentnummer:"); Jlabel Jlname = new Jlabel ("Name:"); JLabel JlSEX = new JLabel ("Geschlecht:"); Jlabel Jlbirthday = new Jlabel ("Geburtsdatum:"); 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 -Nummer = jtnumber.getText (); String name = jtName.GeteText (); String sex = jttsex.GetText (); String birthday = jtbirthday.GETTEXT (); res = null; conn = driverManager.getConnection ("JDBC: MySQL: // localhost: 3306/javastu", "root", "123"); try {class.forname ("com.mysql.jdbc.driver"); sex = '"+sex+"' wob conn = drivermanager stat.executeupdate (SQL5); // todo automatisch erzeugte block e1.printstacktrace (); ButtonReturn.AddactionListener (new ActionListener () {public void actionPerformed (actionEvent e) {window window = new window ();}}); this.settitle ("Schülerinformationen ändern"); this.setLayout (neuer 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); }}Löschen wird gelöscht
Paket zuerst; Java.sql.*importieren; import Java.awt.*; import Java.awt.event.*; Javax.swing importieren.*; importieren.Window; öffentliche Klasse Delete erweitert JFrame {private statische endgültige long serialversionuid = -1928970409928880648l; Jlabel Jlnumber = new JLabel ("Studentnummer:"); 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 (); Verbindung conn = null; resultSet res = null; Anweisung stat = null; String sql = "löschen von student, where numn = '"+"" "trydbc"; } catch (Ausnahme a) {A.printstacktrace (); H.PrintStackTrace (); ButtonReturn.AddactionListener (new ActionListener () {public void actionPerformed (actionEvent e) {window window = new window ();}}); this.settitle ("Schülerinformationen löschen"); this.setLayout (neuer GridLayout (9,1)); this.add (jpnumber); this.add (jpforbutton); this.setLocation (400.300); this.setsize (350.300); this.setvisible (true); }}Look ist stöbert
Paket zuerst; Java.sql.*importieren; import Java.awt.*; import Java.awt.event.*; Javax.swing importieren.*; import Java.util.*; importieren.Window; Public Class Look erweitert JFrame {private statische endgültige lange Serialversionuid = -1928970409928880648L; Verbindung conn = null; PrepedStatement ps = null; ResultSet res = null; // Jbutton buttonlook = new Jbutton ("Browse"); // jbutton buttonreturn = new Jbutton ("return"); Jtable jtable; JScrollPane JScrollpane = new JScrollpane (); Vektor columnNames = null; Vector rowdata = null; public Look () {jpanel jpforbutton = new Jpanel (New GridLayout (1,1)); columnNames = new vector (); columnNames.add ("Schülernummer"); columnNames.add ("name"); columnNames.add ("Geschlecht"); columnNames.add ("Geburtsdatum"); 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 (Ausnahme q) {q.printstacktrace (); System.out.println ("go Die"); } endlich {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 ("Studentinformationen durchsuchen"); this.setLayout (neuer GridLayout (2,5)); this.add (jpforbutton); this.setLocation (300.300); this.setsize (500.300); this.setvisible (true); this.setResizable (falsch); }}Einige laufende Schnittstellen:
Weitere Lernmaterialien finden Sie auf das spezielle Thema "Managementsystementwicklung".
Das obige ist der gesamte Inhalt dieses Artikels. Ich hoffe, es wird für das Lernen aller hilfreich sein und ich hoffe, jeder wird Wulin.com mehr unterstützen.