學生考勤管理系統(tǒng)(JAVA語言)

1、java程序設(shè)計學生考勤管理系統(tǒng)課程名稱：java程序設(shè)計設(shè)計題目：學生考勤管理系統(tǒng)（java）指導老師：xxx班級：數(shù)計x級x班姓名： xxx學號： xxxxxxxxxx時間： 2016年某月某日編程工具：myeclipse （宣版的）編程電藺：dell操作系知windows 7（自己換的）顯卡：nvidia編程環(huán)境：java gw設(shè)計功能： 查看學生信息 學生考h 增加，m除，修改學生信息實駛代馬:package manger;import javax.swing.jdialoq；import javax.swing.jframe;import javax.swino.joptionpan

2、e;import javax.swin0.jpanel;import java.awt.borderlayout;import java.awt.dimension;import java.awt.toolkit;import javax.swlnajdesktoppane;import javax.swino.jbutton;import java.awt.rectanole;import java.sql.connection;import java.sql.drivermanager;import java.sql.resultset;import java.sql.statement;

3、import javax.swino.jtextfield;import javax.swing.jlabel;public class addform private jframe jframe = null;private j panel jcontentpane = null;private j desktoppane jdesktoppane = null;private jbutton jbirttonok = null;private jbutton jbirttoncancel = null;private jtextfield jtextname = null;private

4、jtextfield jtextnum = null;private jtextfield jtextgrade = null;private jlabel jlabelname = null;private jlabel jlabelnum = null;private jlabel jlabelgrade = null;j frame getjframeo if (jframe = null) jframe = new jframeo;jframe.settitlecs 加學生信息,)；jframe.setsize(new dimension(242,205);dimension scre

5、ensize = toolkit.getdefaulttoolkit().getscreensize()y/n 口居中顯示screensize = toolkit.getdefaulttoolkft().oetscreensize();jframe.setlocation(screensize.width-jframe.oetwidth()/2,(screensize.heiaht-jframe.oetheight()/2); jframe.setcontentpane(oetjcontentpaneo);)return jframe;)private j panel qetjcontentp

6、aneo (if ocontentpane = null) jcontentpane = new jpanelo;jcontentpane.setlayout(new borderlayouto);jcontentpane.add(oetjdesktoppane()f borderlayout.center);)return jcontentpane;)private jdesktoppane getjdesktoppane() if odesktoppane = null) jlabelgrade = new jlabelo；jlabelgrade.setbounds(new rectan0

7、le(3ov 100,38,18);jlabelgrade.settext(s 級:)；jlabelnum = new jlabelo;jlabelnum.setbounds(new rectangle(30f 60,38,18);ilabelnum.settextf 號jlabelname = new jlabelo;jlabelname.setbounds(new rectangle(30,20,38,18);jlabelname.settextc# 2 ：)；jdesktoppane = new jdesktoppaneo;jdesktoppane.add(qetjbuttonok()l

8、 null);jdesktoppane.add(getjbuttoncancel(), null);jdesktoppane.add(oetjtextname()f null);jdesktoppane.add(aetjtextnum(), null);jdesktoppane.add(getjtextgrade()9 null);jdesktoppane.adddlabelnamev null);jdesktoppane.adddlabelnum, null);jdesktoppane.addolabelgrade, null);return jdesktoppane;)private jb

9、utton geubuttonoko if obuttonok = null) jbuttonok = new jbuttono;jbuttonok.setbounds(new rectangle(20f 135,80,22);jbuttonok. settext(提交)；jbuttonok.addmouselistener(new java.awt.event.mouseadapter() public void mouseclickeddava.awt.event.mouseevent e) try(addsqlq; catch (exception e1)/todo自動生成catch塊e

10、1.printstacktrace();j/todo auto-generated event stub mouseclicked()private void addsqlo throws exception string dbdriversun.jdbc.odbc.jdbcodbcdriver-;string str=bjdbc:odbc:driver=microsoft access driver (*.mdb);dbq=stulnfob;connection con=null;statement stmunull;resultset rs=null;class.forname(dbdri

11、ver);con=drivermanagergetconnection(str);stmt=con.createstatement();string name = jtextname.gettexto;if(name.equalsn)(stmt.close();con.closeo;joptionpane.showmessagedialog(new jdialog(),姓名不能為空!);return;)string num = jtextnum.oettexto;if(num.equals(ib)(stmt.closeo；con.closeo;joptionpane.showmessagedi

12、alog(new jdialogo/ 學號不能為空!)；return;elsers = stmt.executequery(select * from stulnfo where num =+num+,b);if(rs.next()(stmt.closeo;con.closeo;joptionpane.showmessagedialog(new jdialogo；學號重復!)；return;)string grade = jtextgrade.gettext();rf(orade.equalsd)(stmtdoseo;con.closeo；joptionpane.showmessaoedial

13、oo(new jdialoq()9as 級不能為空!)；return;stmtexecuteupdateflnsert into stulnfo values(,i+name+lll+num+lf,l,+orade+,)ir);stmt.closeo;con.close();mainform.reflesh();oetjframe(),dispose();joptionpane.showmessaaedialog(new jdialogo/s 加成曲)；);)return jbuttonok;)private jbutton getjbuttoncancelo if obuttoncancel

14、 = null) jbuttoncancel = new jbuttono;jbuttoncancel.setbounds(new rectanole(137,135,80,22);jbuttoncancel.settextc 取消);jbuttoncancel.addmouselistener(new java.awtevent.mouseadapter() public void mousecllcked(java.awt.eventmouseevent e) getjframe().dispose(););)return jbuttoncancel;private jtextfleld oeutextnameo if (jtextname = null) jtextname = new jtextreldo;jtextname.setbounds(new rectanale(90,20,120,22);)return jtextname;private jtextfleld oetjtextnumo if gtextnum = null) jtextnum = new jtextfieldo;jtextnum.setbounds(ne