Java는 MySQL을 기반으로 한 학생 관리 시스템을 구현합니다

이 기사는 귀하의 참조를 위해 MySQL을 기반으로 한 학생 관리 시스템의 구현을 귀하와 공유합니다. 특정 내용은 다음과 같습니다

실험실은 숙제를해야했기 때문에 학생 관리 시스템을 구축하고이를 기념하기위한 코드를 게시했습니다. 인터페이스와 다른 것들이 너무 시급했습니다.

완벽하지는 않지만 여전히 주요 기능을 달성 할 수있는 작은 세부 사항이 여전히 있습니다.

창이 기본 인터페이스입니다

 먼저 패키지; Java.sql.*; java.awt.*; import java.awt.event.*; javax.swing을 가져옵니다.*; 공개 클래스 창 {public static void main (String [] args) {jframe jframe = new Jframe ( "학생 관리 시스템"); // Window Dimension D = New Dimension (400,300); 포인트 P = 새로운 포인트 (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 BUTCY4 = NEW JBUTTON ( "Delete"); jbutton button5 = New JButton ( "브라우즈"); FlowLayout Flow = New FlowLayout (FlowLayout.Left, 10,10); JPANEL 패널 = 새로운 JPANEL (flow); PALEN.ADD (button1); 패널 .add (button2); 패널 .add (button3); 패널 .add (button4); 패널 .add (button5); jframe.add (패널); button1.addactionListener (new ActionListener () {public void ActionPerformed (ActionEvent e) {add = new add ();}}); button2.addactionListener (new ActionListener () {public void ActionPerformed (ActionEvent e) {변경 변경 = 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가 추가됩니다

 먼저 패키지; Java.sql.*; java.awt.*; import java.awt.event.*; javax.swing을 가져옵니다.*; import com.mysql.jdbc.driver; 먼저 가져옵니다. 공개 클래스 추가 jframe {private static final long serialversionuid = -1928970409928880648L; Jlabel Jlnumber = New Jlabel ( "학생 번호 :"); jlabel jlname = new Jlabel ( "이름 :"); Jlabel Jlsex = New Jlabel ( "성별 :"); Jlabel Jlbirthday = New Jlabel ( "생년월일 :"); 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 BUTCYADD = NEW JBUTTON ( "ADD"); JBUTTON BUCKERETURN = NEW JBUTTON ( "return"); public add () {jpanel jpnumber = new jpanel (); jpanel jpname = new jpanel (); JPANEL JPSEX = 새로운 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) {// 연결 추가 conn = null; stat = null; readingstatement ps = null; String SQL = "삽입 (number, 이름, 성별, 부서)" + "값 (?,?,?,?,?); System.out.println ( "JBDC가 성공적으로로드!"}} {System.out.println ( "JBDC Dog Belt!"); ps = ps.setstring (1, jtnumber.gettreting); PseString (5, jtdepartment.getText); (sqlexection b) {b.printstacktrace () {conn.close.out.println; buttonReturn.addactionListener (new ActionListener () {public void ActionPerformed (ActionEvent e) {Window Window = new Window ();}}); this.settitle ( "학생 정보 추가"); 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.set -Visible (true); }}

질문은 쿼리입니다

 먼저 패키지; Java.sql.*; java.awt.*; import java.awt.event.*; javax.swing을 가져옵니다.*; 먼저 가져옵니다. 공개 클래스 ASK 확장 jframe {private static final long serialversionuid = -192897040992880648L; Jlabel Jlnumber = New Jlabel ( "학생 번호 :"); jlabel jlname = new Jlabel ( "이름 :"); Jlabel Jlsex = New Jlabel ( "성별 :"); Jlabel Jlbirthday = New Jlabel ( "생년월일 :"); 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 BUCKERETURN = NEW JBUTTON ( "return"); public ask () {jpanel jpnumber = new jpanel (); jpanel jpname = new jpanel (); JPANEL JPSEX = 새로운 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; stat = null; string sql = "select number, name, 섹스, 생일, 학생; System.out.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)); 부서지다; }}} catch (sqlexception e1) {// todo 자동 생성 캐치 블록 e1.printstacktrace (); } 마침내 {try {conn.close (); } catch (sqlexception ar) {ar.printstacktrace (); }}}}); buttonReturn.addactionListener (new ActionListener () {public void ActionPerformed (ActionEvent e) {Window Window = new Window ();}}); this.settitle ( "쿼리 학생 정보"); 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.set -Visible (true); }}

변경이 수정되었습니다

 먼저 패키지; Java.sql.*; java.awt.*; import java.awt.event.*; javax.swing을 가져옵니다.*; 먼저 가져옵니다. 공공 클래스 변경은 JFrame {private static final long serialversionuid = -1928970409928880648L을 확장합니다. Jlabel Jlnumber = New Jlabel ( "학생 번호 :"); jlabel jlname = new Jlabel ( "이름 :"); Jlabel Jlsex = New Jlabel ( "성별 :"); Jlabel Jlbirthday = New Jlabel ( "생년월일 :"); 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 BUCKERETURN = NEW JBUTTON ( "return"); Public Change () {jpanel jpnumber = new jpanel (); jpanel jpname = new jpanel (); JPANEL JPSEX = 새로운 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) {문자열 번호 = jtnumber.getText (); String name = jtname.getText (); String sex = jttsex.getText (); string 생일 = jtbirthday.getText (); jtdepartment.gettext (); res = null stat = null; conn = jdbc : mysql : // localhost : 3306/javastu ","123 "); {class.forname (com.mysql.jdbc.driver "}} {system.out.println (d.printstacktrace); sex = '+sex+"'where number = '"+jtnumber.getText ()+"'"; String Sql4 = "String Set Set Birthday = '+생일+"'+생일+" 'where number ='+jtnumber.getText ()+" ''; String Sql5 = "update Student set department = ''+department+" '+jtnumber.getTetext ()+Jtnext (gettext); conn = jdbc : mysql : // localhost : "root", "123"; stat. TODO가 자율적 인 캐치 블록 e1.printstacktrace (); buttonReturn.addactionListener (new ActionListener () {public void ActionPerformed (ActionEvent e) {Window Window = new Window ();}}); this.settitle ( "학생 정보 수정"); 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.set -Visible (true); }}

삭제가 삭제됩니다

 먼저 패키지; Java.sql.*; java.awt.*; import java.awt.event.*; javax.swing을 가져옵니다.*; 먼저 가져옵니다. 공개 클래스 삭제 jframe {private static final long serialversionuid = -1928970409928880648L; Jlabel Jlnumber = New Jlabel ( "학생 번호 :"); jtextfield jtnumber = New Jtextfield ( "", 20); JBUTTON BUTTONDELETE = NEW JBUTTON ( "Delete"); JBUTTON BUCKERETURN = 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) {문자열 번호 = jtnumber.getText (); Connection Conn = null; resultSt = null; stat = null; String SQL = "숫자 = '+번호+"'; frals.fornam ( "com.mysql.jdc."; } a.printstacktrace (); h.printstacktrace (); buttonReturn.addactionListener (new ActionListener () {public void ActionPerformed (ActionEvent e) {Window Window = new Window ();}}); this.settitle ( "학생 정보 삭제"); this.setLayout (New GridLayout (9,1)); this.add (jpnumber); this.add (jpforbutton); this.setLocation (400,300); this.setsize (350,300); this.set -Visible (true); }}

룩은 탐색 중입니다

 먼저 패키지; Java.sql.*; java.awt.*; import java.awt.event.*; javax.swing을 가져옵니다.*; java.util.*; 먼저 가져옵니다. 공개 클래스 룩 확장 jframe {private static final long serialversionuid = -1928970409928880648L; 연결 Conn = null; 준비된 상태 ps = null; resultSet res = null; // jbutton buttonLook = new JButton ( "브라우즈"); // jbutton buttonreturn = new Jbutton ( "return"); jtable jtable; jscrollpane jscrollpane = new jscrollpane (); 벡터 columnnames = null; 벡터 rowdata = null; 공개 룩 () {jpanel jpforbutton = new JPanel (New Gridlayout (1,1)); columnNames = new vector (); columnnames.add ( "학생 번호"); columnNames.add ( "이름"); columnnames.add ( "성별"); columnnames.add ( "생년월일"); 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 (행); } system.out.println ( "load Ok!"); } catch (예외 Q) {q.printstacktrace (); System.out.println ( "Go Die"); } 마침내 {try {res.close (); ps.close (); conn.close (); System.out.println ( "닫기 확인"); } catch (sqlexception o) {O.printstacktrace (); System.out.println ( "Go Die 2"); }} jtable = new Jtable (RowData, columnNames); jscrollpane = 새로운 jscrollpane (jtable); this.add (jscrollpane); this.settitle ( "학생 정보 찾아보기"); this.setLayout (New GridLayout (2,5)); this.add (jpforbutton); this.setLocation (300,300); this.setsize (500,300); this.set -Visible (true); this.setResizable (false); }}

일부 실행중인 인터페이스 :

더 많은 학습 자료는 특별한 주제 "관리 시스템 개발"에주의를 기울이십시오.

위는이 기사의 모든 내용입니다. 모든 사람의 학습에 도움이되기를 바랍니다. 모든 사람이 wulin.com을 더 지원하기를 바랍니다.