Este artículo comparte con usted la implementación del sistema de gestión de estudiantes basado en MySQL para su referencia. El contenido específico es el siguiente
Debido a que el laboratorio tuvo que entregar la tarea, construyó un sistema de gestión de estudiantes y publicó un código para conmemorarlo. La interfaz y otras cosas eran demasiado urgentes eran pobres.
Todavía hay algunos pequeños detalles que no son perfectos, pero aún pueden lograr las funciones principales.
La ventana es la interfaz principal
paquete primero; 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 ("Sistema de gestión de estudiantes"); // Dimensión de la ventana d = nueva dimensión (400,300); Punto p = nuevo punto (250,350); jframe.setsize (d); jframe.setLocation (p); jframe.setDefaultCloseOperation (jframe.exit_on_close); jframe.setVisible (verdadero); JButton Button1 = new JButton ("Agregar"); JButton Button2 = new JButton ("Modify"); JButton Button3 = new JButton ("Query"); JButton Button4 = new JButton ("Eliminar"); JButton Button5 = new JButton ("Examinar"); FlowLayout Flow = New FlowLayout (FlowLayout.Lft, 10,10); Panel jpanel = nuevo JPanel (flujo); panel.add (botón1); panel.add (botón2); panel.add (Button3); panel.add (botón4); 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) {apartar = new Look ();}}); }}Se agrega agregar
paquete primero; import java.sql.*; import java.awt.*; import java.awt.event.*; import javax.swing.*; import com.mysql.jdbc.driver; importar primero. Window; La clase pública ADD extiende jframe {privado estático final Long SerialVersionUid = -1928970409928880648l; Jlabel jlNumber = new JLabel ("Número de estudiante:"); Jlabel jlname = new JLabel ("Nombre:"); Jlabel jlsex = new JLabel ("Género:"); Jlabel jlbirthday = new JLabel ("Fecha de nacimiento:"); 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 ("Agregar"); 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 (nuevo 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) {// Agregar conexión conn = null; declaración stat = null; prepareStatement ps = null; string sql = "insertar en estudiante (número, nombre, sexo, departamento)" + "valores (?,,?,?,?)"; intent System.out.println ("JBDC Cargado con éxito!"); PS = Conn.PrepareStatement (SQL); Ps.SetString (5, JTDePartment.gettext ()); (SQLEXCECT B) {B.PrintStackTrace (); ButtonReturn.AdDactionListener (new ActionListener () {public void ActionPerformed (ActionEvent E) {Window Window = New Window ();}}); this.settitle ("Agregar información del estudiante"); this.setLayout (nuevo 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 (verdadero); }}Preguntar es una consulta
paquete primero; import java.sql.*; import java.awt.*; import java.awt.event.*; import javax.swing.*; importar primero. Window; La clase pública Ask extiende Jframe {Private Static Final Long SerialVersionUid = -1928970409928880648l; Jlabel jlNumber = new JLabel ("Número de estudiante:"); Jlabel jlname = new JLabel ("Nombre:"); Jlabel jlsex = new JLabel ("Género:"); Jlabel jlbirthday = new JLabel ("Fecha de nacimiento:"); 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 (nuevo 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; Declaration stat = null; String sql = "Seleccionar número, nombre, sexo, cumpleaños, departamento de alumno;"; intente {class.forname ("com.mysql.jdbc.driver"); System.out.println ("JDBC Fall"); (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)); romper; }}} Catch (SQLException E1) {// TODO Bloque de captura generada automática e1.printstackTrace (); } finalmente {try {conn.close (); } catch (sqlexception ar) {ar.printstackTrace (); }}}}); ButtonReturn.AdDactionListener (new ActionListener () {public void ActionPerformed (ActionEvent E) {Window Window = New Window ();}}); this.settitle ("Información del estudiante de consulta"); this.setLayout (nuevo 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 (verdadero); }}El cambio se modifica
paquete primero; import java.sql.*; import java.awt.*; import java.awt.event.*; import javax.swing.*; importar primero. Window; El cambio de clase pública se extiende Jframe {privado estático final Long SerialVersionUid = -1928970409928880648l; Jlabel jlNumber = new JLabel ("Número de estudiante:"); Jlabel jlname = new JLabel ("Nombre:"); Jlabel jlsex = new JLabel ("Género:"); Jlabel jlbirthday = new JLabel ("Fecha de nacimiento:"); 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"); Cambio public () {jPanel jpNumber = new JPanel (); Jpanel jpname = new JPanel (); Jpanel jpsex = new JPanel (); Jpanel jpbirthday = new JPanel (); Jpanel jpdepartment = new JPanel (); Jpanel jpforButton = new JPanel (nuevo 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 = JTBIRTHDay.Gettext (); = NULL STAT = NULL; Conn = Drivermanager.getConnection ("JDBC: mySQL: // localhost: 3306/javastu", "root", "123"); {try {class.forname ("com.mysql.jdbc.driver"); sexo = '"+sexy+"' where number = '"+jtnumber.gettext ()+"' "; string sql4 =" actualizar set de estudiante set de birthday = '"+birthdle+"' where numin Conn = Drivermanager.getConnection ("JDBC: mysql: // localhost: 3306/javastu", "root", "123"); stat.ExCuteUpdate (SQL5); // TODO BLOQUE DE CABLIÓN AUTO ButtonReturn.AdDactionListener (new ActionListener () {public void ActionPerformed (ActionEvent E) {Window Window = New Window ();}}); this.settitle ("Modificar información del estudiante"); this.setLayout (nuevo 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 (verdadero); }}Eliminar es Eliminar
paquete primero; import java.sql.*; import java.awt.*; import java.awt.event.*; import javax.swing.*; importar primero. Window; Public Class Delete extiende Jframe {Private Static Final Long SerialVersionUid = -1928970409928880648l; Jlabel jlNumber = new JLabel ("Número de estudiante:"); JTextfield Jtnumber = new JTextfield ("", 20); JButton Buttondelete = new JButton ("Eliminar"); JButton ButtonReturn = new JButton ("return"); public delete () {jPanel jpNumber = new JPanel (); Jpanel jpforButton = new JPanel (nuevo GridLayout (1,1)); jpnumber.add (jlNumber); jpnumber.add (jtnumber); JPFORBUTTON.Add (ButDondelete); JPFORBUTTON.Add (ButtonReturn); buttondelete.AdDactionListener (new ActionListener () {public void ActionPerformed (ActionEvent E) {String Number = JtNumber.Gettext (); Connection conn = null; resultSet res = null; Declaration stat = null; String sql = "delete del estudiante Where Number ="+Number+""; "Hyl.forname (" com.mysql.j.dbc.driver "); } Catch (excepción a) {A.PrintStackTrace (); H.PrintStackTrace (); ButtonReturn.AdDactionListener (new ActionListener () {public void ActionPerformed (ActionEvent E) {Window Window = New Window ();}}); this.settitle ("Eliminar información del estudiante"); this.setLayout (nuevo GridLayout (9,1)); this.add (jpnumber); this.add (jpforButton); this.setLocation (400,300); this.setsize (350,300); this.setVisible (verdadero); }}Mira está navegando
paquete primero; import java.sql.*; import java.awt.*; import java.awt.event.*; import javax.swing.*; import java.util.*; importar primero. Window; El aspecto de la clase pública extiende Jframe {Private Static Final Long SerialVersionUid = -1928970409928880648l; Conexión conn = nulo; Preparado PS = NULL; ResultSet Res = NULL; // jButton Buttonlook = new JButton ("Examinar"); // jButton ButtonReturn = new JButton ("return"); Jtable jtable; JSCrollPane JScrollPane = new JScrollPane (); Columnnames vectoriales = nulo; Vector RowData = NULL; Public Look () {JPanel JPForButton = new JPanel (new GridLayout (1,1)); columnNames = new Vector (); columnNames.Add ("Número de estudiante"); columnNames.add ("nombre"); columnNames.Add ("género"); columnNames.Add ("Fecha de nacimiento"); columnNames.Add ("College"); RowData = new Vector (); //jpforButton.add(Buttonlook); //jpforButton.add(ButtonReturn); intente {class.forname ("com.mysql.jdbc.driver"); Conn = drivermanager.getConnection ("jdbc: mysql: // localhost: 3306/javastu", "root", "123"); ps = conn.prepareStatement ("Seleccionar * del estudiante"); 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 (colgar); } System.out.println ("¡Cargar bien!"); } catch (excepción q) {Q.PrintStackTrace (); System.out.println ("Go Die"); } finalmente {try {res.close (); ps.close (); conn.close (); System.out.println ("Cerrar 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 ("Explorar información del estudiante"); this.setLayout (nuevo GridLayout (2,5)); this.add (jpforButton); this.setLocation (300,300); this.setsize (500,300); this.setVisible (verdadero); this.setResizable (falso); }}Algunas interfaces en ejecución:
Para obtener más materiales de aprendizaje, preste atención al tema especial "Desarrollo del sistema de gestión".
Lo anterior es todo el contenido de este artículo. Espero que sea útil para el aprendizaje de todos y espero que todos apoyen más a Wulin.com.