Artikel ini berbagi dengan Anda implementasi sistem manajemen siswa berdasarkan MySQL untuk referensi Anda. Konten spesifiknya adalah sebagai berikut
Karena laboratorium harus menyerahkan pekerjaan rumah, itu membangun sistem manajemen siswa dan memposting kode untuk memperingati. Antarmuka dan hal -hal lain terlalu mendesak sangat buruk.
Masih ada beberapa detail kecil yang tidak sempurna, tetapi masih bisa mencapai fungsi utama.
Jendela adalah antarmuka utama
paket dulu; impor java.sql.*; impor java.awt.*; impor java.awt.event.*; impor javax.swing.*; Window kelas publik {public static void main (string [] args) {jframe jframe = new jframe ("sistem manajemen siswa"); // dimensi jendela d = dimensi baru (400.300); Poin p = titik baru (250.350); jframe.setsize (d); jframe.setlocation (p); jframe.setDefaultCloseOperation (jframe.exit_on_close); jframe.setVisible (true); Jbutton button1 = jbutton baru ("add"); Jbutton button2 = new jbutton ("ubah"); Jbutton button3 = jbutton baru ("kueri"); Jbutton button4 = new jbutton ("delete"); Jbutton button5 = jbutton baru ("browse"); Flowlayout flow = flowlayout baru (flowlayout.left, 10,10); Jpanel panel = jpanel baru (aliran); panel.add (tombol1); panel.add (tombol2); panel.add (tombol3); panel.add (tombol4); panel.add (tombol5); jframe.add (panel); Button1.AddActionListener (ActionListener baru () {public void actionPerformed (actionEvent e) {add add = new add ();}}); tombol2.AddActionListener (ActionListener baru () {public void actionPerformed (actionEvent e) {ubah perubahan = perubahan baru ();}}); tombol3.addactionListener (actionListener () {public void actionPerformed (actionEvent e) {ask ask = new ask ();}}); tombol4.addactionListener (actionListener () {public void actionPerformed (actionEvent e) {delete delete = new delete ();}}); tombol5.addactionListener (actionListener () {public void actionPerformed (actionEvent e) {look look = new look ();}}); }}Tambahkan ditambahkan
paket dulu; impor java.sql.*; impor java.awt.*; impor java.awt.event.*; impor javax.swing.*; impor com.mysql.jdbc.driver; impor pertama.window; Kelas Publik Tambahkan Luas JFrame {Private Static Final Long SerialVersionUID = -1928970409928880648L; Jlabel Jlnumber = JLabel baru ("Nomor Siswa:"); Jlabel jlname = jlabel baru ("name:"); Jlabel jlsex = new jlabel ("gender:"); Jlabel Jlbirthday = Jlabel baru ("Tanggal Lahir:"); Jlabel jldepartment = new jlabel ("college:"); JTextField JTnumber = JTextField baru ("", 20); JTextField JTName = JTextField baru ("", 20); JTextfield jtsex = new jTextField ("", 20); JTextField JTBIrthDay = JTextField baru ("", 20); JTextField JtDepartment = baru jTextField ("", 20); Jbutton buttonadd = jbutton baru ("add"); Jbutton buttonReturn = jbutton baru ("return"); public add () {jpanel jpnumber = new jpanel (); Jpanel jpname = jpanel baru (); Jpanel jpsex = jpanel baru (); Jpanel jpbirthday = jpanel baru (); Jpanel jpdepartment = jpanel baru (); Jpanel jpforbutton = jpanel baru (gridlayout baru (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 (ActionListener baru () {public void actionPerformed (actionEvent e) {// tambahkan koneksi conn = null; pernyataan stat = null; disiapkan ps = null; string sql = "masukkan ke siswa (angka, nama, seks, ulang tahun, departemen)" + "nilai (?,?,? System.out.println ("JBDC berhasil dimuat!"); PS = Conn.PrepareStatement (SQL); ps.setstring (5, jtdepartment.gettext ()); (SQlexception b) {B.PrintStackTrace (); ButtonReTurn.addactionListener (ActionListener baru () {public void actionPerformed (actionEvent e) {window window = window baru ();}}); this.settitle ("Tambahkan informasi siswa"); this.setLayout (GridLayout baru (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); }}Tanya adalah kueri
paket dulu; impor java.sql.*; impor java.awt.*; impor java.awt.event.*; impor javax.swing.*; impor pertama.window; kelas publik Ask Extends JFrame {private static final long serialversionuid = -1928970409928880648l; Jlabel Jlnumber = JLabel baru ("Nomor Siswa:"); Jlabel jlname = jlabel baru ("name:"); Jlabel jlsex = new jlabel ("gender:"); Jlabel Jlbirthday = Jlabel baru ("Tanggal Lahir:"); Jlabel jldepartment = new jlabel ("college:"); JTextField JTnumber = JTextField baru ("", 20); Jlabel jname = new jlabel (); Jlabel jsex = new jlabel (); Jlabel jbirthday = new jlabel (); Jlabel jdepartment = new jlabel (); Jbutton buttonask = jbutton baru ("kueri"); Jbutton buttonReturn = jbutton baru ("return"); public ask () {jpanel jpnumber = new jpanel (); Jpanel jpname = jpanel baru (); Jpanel jpsex = jpanel baru (); Jpanel jpbirthday = jpanel baru (); Jpanel jpdepartment = jpanel baru (); Jpanel jpforbutton = jpanel baru (gridlayout baru (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.outs.println (JDBC Fall "); {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)); merusak; }}} catch (sqlexception e1) {// todo auto-generated catch block e1.printstacktrace (); } akhirnya {coba {conn.close (); } catch (sqlexception ar) {ar.printstacktrace (); }}}}); ButtonReTurn.addactionListener (ActionListener baru () {public void actionPerformed (actionEvent e) {window window = window baru ();}}); this.settitle ("Informasi Siswa Permintaan"); this.setLayout (GridLayout baru (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); }}Perubahan dimodifikasi
paket dulu; impor java.sql.*; impor java.awt.*; impor java.awt.event.*; impor javax.swing.*; impor pertama.window; perubahan kelas publik memperluas jframe {private static final long serialversionuid = -1928970409928880648l; Jlabel Jlnumber = JLabel baru ("Nomor Siswa:"); Jlabel jlname = jlabel baru ("name:"); Jlabel jlsex = new jlabel ("gender:"); Jlabel Jlbirthday = Jlabel baru ("Tanggal Lahir:"); Jlabel jldepartment = new jlabel ("college:"); JTextField JTnumber = JTextField baru ("", 20); JTextField JTName = JTextField baru ("", 20); JTextField JTTSEX = JTextField baru ("", 20); JTextField JTBIrthDay = JTextField baru ("", 20); JTextField JtDepartment = baru jTextField ("", 20); Jbutton buttonchange = new jbutton ("ubah"); Jbutton buttonReturn = jbutton baru ("return"); perubahan publik () {jpanel jpnumber = jpanel baru (); Jpanel jpname = jpanel baru (); Jpanel jpsex = jpanel baru (); Jpanel jpbirthday = jpanel baru (); Jpanel jpdepartment = jpanel baru (); Jpanel jpforbutton = jpanel baru (gridlayout baru (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 (ActionListener baru () {public void actionPerformed (actionEvent e) {string number = jtnumber.getText (); string name = jtname.getText (); string sex = nttsex.gettext (); string ulang tahun = jtbirthday.gettext (); non (); sangki (); jttdeptext. res = null; Conn = DriverManager.getConnection ("jdbc: mysql: // localhost: 3306/javastu", "root", "123"); coba {class.forname ("com.mysql.jdbc.driver"); 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.ExecuteUnpdate (SQL5); {// TODO AUTO-ENTERASI BLOK E1.PRINTSTACKTRACE (); ButtonReTurn.addactionListener (ActionListener baru () {public void actionPerformed (actionEvent e) {window window = window baru ();}}); this.settitle ("memodifikasi informasi siswa"); this.setLayout (GridLayout baru (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); }}Hapus adalah Hapus
paket dulu; impor java.sql.*; impor java.awt.*; impor java.awt.event.*; impor javax.swing.*; impor pertama.window; Hapus Kelas Publik Perluaja JFrame {Private Static Final Long SerialVersionuid = -1928970409928880648L; Jlabel Jlnumber = JLabel baru ("Nomor Siswa:"); JTextField JTnumber = JTextField baru ("", 20); Jbutton buttondelete = jbutton baru ("hapus"); Jbutton buttonReturn = jbutton baru ("return"); delete publik () {jpanel jpnumber = new jpanel (); Jpanel jpforbutton = jpanel baru (gridlayout baru (1,1)); jpnumber.add (jlnumber); jpnumber.add (jtnumber); jpforbutton.add (buttondelete); jpforbutton.add (ButtonReturn); buttondelete.addactionListener (ActionListener baru () {public void actionPerformed (actionEvent e) {string number = jtnumber.getText (); koneksi conn = null; resultSet res = null; stat stator. } Catatan (Pengecualian A) {A.PrintStackTrace (); h.printstacktrace (); ButtonReTurn.addactionListener (ActionListener baru () {public void actionPerformed (actionEvent e) {window window = window baru ();}}); this.settitle ("hapus informasi siswa"); this.setLayout (GridLayout baru (9,1)); this.add (jpnumber); this.add (jpforbutton); this.setlocation (400.300); this.setsize (350.300); this.setVisible (true); }}Tampilan sedang menjelajah
paket dulu; impor java.sql.*; impor java.awt.*; impor java.awt.event.*; impor javax.swing.*; impor java.util.*; impor pertama.window; kelas publik tampilan meluas {private static final long serialversionuid = -1928970409928880648l; Koneksi conn = null; Disiapkan ps = null; Resultet res = null; // jbutton buttonlook = jbutton baru ("browse"); // jbutton buttonReturn = jbutton baru ("return"); Jtable jtable; Jscrollpane jscrollpane = jscrollpane baru (); Vektor ColumnNames = null; Vektor rowData = null; Public Look () {jpanel jpforbutton = jpanel baru (new gridlayout (1,1)); ColumnNames = vektor baru (); ColumnNames.Add ("Nomor Siswa"); columnNames.add ("name"); ColumnNames.Add ("Jenis Kelamin"); ColumnNames.Add ("Tanggal Lahir"); ColumnNames.Add ("College"); rowData = vektor baru (); //jpforbutton.add(buttonlook); //jpforbutton.add(buttonreturn); coba {class.forname ("com.mysql.jdbc.driver"); conn = driverManager.getConnection ("jdbc: mysql: // localhost: 3306/javastu", "root", "123"); ps = Conn.PrepareStatement ("Pilih * dari Siswa"); res = ps.executeQuery (); while (res.next ()) {vector hang = vektor baru (); 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 ("Muat OK!"); } catch (Exception q) {q.printstacktrace (); System.out.println ("Go Die"); } akhirnya {coba {res.close (); ps.close (); conn.close (); System.out.println ("Tutup OK"); } catch (sqlexception o) {o.printstacktrace (); System.out.println ("Go Die 2"); }} jtable = jtable baru (rowData, ColumnNames); jscrollpane = jscrollpane baru (jtable); this.add (jscrollpane); this.settitle ("Jelajahi Informasi Siswa"); this.setLayout (GridLayout baru (2,5)); this.add (jpforbutton); this.setlocation (300.300); this.setsize (500.300); this.setVisible (true); this.setresizable (false); }}Beberapa antarmuka yang berjalan:
Untuk materi pembelajaran lebih lanjut, harap perhatikan topik khusus "pengembangan sistem manajemen".
Di atas adalah semua konten artikel ini. Saya berharap ini akan membantu untuk pembelajaran semua orang dan saya harap semua orang akan lebih mendukung wulin.com.