教室管理系统的源代码1

1、1.创建数据库create datebase classmanager;create table classinfo(教室编号 varchar(10) primary key,教室设备 varchar(100) not null,教室容纳人数 int not null,教室管理员编号 varchar(10) not null);create table teacherinfo(教师编号 varchar(10) primary key,教师姓名varchar(20) not null,教授课程varchar(50),教师职称 varchar(20) not null);create table

2、classroominfo(教室编号 varchar(10),上课开始时间 datetime not null,结束时间 datetime not null,教师编号 varchar(10),foreign key (教室编号) references classinfo(教室编号), foreign key (教师编号) references teacherinfo(教师编号);create table manager(username varchar(10) not null,userpsw varchar(10) not null);向其中插入数据。insert classinfovalu

3、es('4101','投影仪','40','01')insert classinfovalues('4102','电脑','50','02')insert teacherinfovalues('0a','李萍','计算机系统分','讲师')insert teacherinfovalues('0b','李明','c语言','教授')insert

4、 classroominfovalues('4101','8:00','10:00','0a')insert classroominfovalues('4102','10:00','12:00','0b')insert managervalues('jack','20120521')2.创建登录界面package dev.chall.otherinterface;import java.awt.cursor;import java.aw

5、t.flowlayout;import java.awt.frame;import java.awt.gridlayout;import java.awt.event.actionevent;import java.awt.event.actionlistener;import java.awt.event.windowevent;import java.sql.connection;import java.sql.drivermanager;import java.sql.preparedstatement;import java.sql.resultset;import java.sql.

6、sqlexception;import javax.swing.jbutton;import javax.swing.jdialog;import javax.swing.jlabel;import javax.swing.jpanel;import javax.swing.jpasswordfield;import javax.swing.jtextfield;public class login extends jdialog implements actionlistenerprivate jlabel name;private jlabel psw;private jtextfield

7、 namev;private jpasswordfield pswv;private jbutton login,quit;private jpanel top;private jpanel center;private jpanel bottom;private jlabel prompt;public static string loginname;public login(frame owner, string title, boolean modal) super(owner, title, modal);init();private void init()name=new jlabe

8、l("登录名:");namev=new jtextfield(10);top=new jpanel();top.add(name);top.add(namev);this.add(top);psw=new jlabel("密 码:");pswv=new jpasswordfield(10);center=new jpanel();center.add(psw);center.add(pswv);this.add(center);login=new jbutton();login.settext("登录");login.setactio

9、ncommand("login");login.addactionlistener(this);quit=new jbutton("退出");quit.setactioncommand("quit");quit.addactionlistener(this);bottom=new jpanel();bottom.add(login);bottom.add(quit);this.add(bottom);prompt=new jlabel();this.add(prompt);this.setlayout(new gridlayout(4

10、, 1);this.setlocation(550, 230);this.setsize(200,200);this.setvisible(true);overridepublic void actionperformed(actionevent arg0) if(arg0.getactioncommand()="login")string name=namev.gettext();string psw=pswv.gettext();if(name.length()<=0|psw.length()<=0)prompt.settext("提示：用户名或密

11、码为空！");return;if(checkcount(name,psw)this.dispose();elseprompt.settext("提示：用户名或密码错误！");return;else if(arg0.getactioncommand()="quit")system.exit(0);private boolean checkcount(string name,string psw)connection connection=null;preparedstatement ps=null;resultset rs=null;try /加

12、载驱动class.forname("sun.jdbc.odbc.jdbcodbcdriver");/得到连接connection=drivermanager.getconnection("jdbc:odbc:classmanager", "sa", "songchao");/创建访问数据库接口ps=connection.preparestatement("select * from manager");rs=ps.executequery();while(rs.next()string name

13、t=rs.getstring(1);string pswt=rs.getstring(2);system.out.println(namet+"<>"+pswt+"-"+name+"<>"+psw+"-");if(namet.equals(name)&&pswt.equals(psw)loginname=namet;return true;system.out.println("false"); catch (exception e) e.printsta

14、cktrace();finallytry rs.close();ps.close();connection.close(); catch (sqlexception e) e.printstacktrace();return false;overrideprotected void processwindowevent(windowevent arg0) cesswindowevent(arg0);if(arg0.getid()=windowevent.window_closing)system.exit(0);3.实现主界面，实现各按钮的作用package dev.chal

15、l.main;import java.awt.borderlayout;import java.awt.flowlayout;import java.awt.font;import java.awt.gridlayout;import java.awt.event.actionevent;import java.awt.event.actionlistener;import java.awt.event.itemevent;import java.awt.event.itemlistener;import java.awt.event.windowevent;import java.util.

16、iterator;import java.util.vector;import javax.swing.jbutton;import javax.swing.jcombobox;import javax.swing.jdialog;import javax.swing.jframe;import javax.swing.jlabel;import javax.swing.jpanel;import javax.swing.jscrollbar;import javax.swing.jscrollpane;import javax.swing.jtable;import javax.swing.

17、jtextfield; import dev.chall.otherinterface.delete;import dev.chall.otherinterface.insert;import dev.chall.otherinterface.update;import dev.chall.otherinterface.login;import dev.chall.otherinterface.reminddialog;import dev.chall.util.mytablemodel;public class controlinterface extends jframe implemen

18、ts actionlistener/登录界面login login;/主控制界面private jpanel topbar,rightbar;/topbarprivate jlabel username;private jbuttonquit;/rightbarprivate jpanel operationp,buttonp,searchp;private jlabel operationt,search;private jcombobox operation;private jbutton searchb,alert,insert,delete;private jtextfieldsear

19、cht;/搜索字样 /centerbarprivatejscrollpane scroll;privatejtable content;private mytablemodel model;private string list=new string"教师信息","教室信息","教室使用情况","教室具体使用情况"private jlabel remind;public static void main(string args)new controlinterface();public controlinterfa

20、ce()/登录界面 -login=new login(this, "登录",true);/登陆界面回来之后/topbartopbar=new jpanel();username=new jlabel();username.settext(login.loginname);username.setfont(new font("隶书",1,25);/字体,1代表样式，字号username.setlocation(this.getwidth()/2-username.getwidth()/2, username.getheight()/3);topbar.ad

21、d(username,borderlayout.center);quit=new jbutton("退出");quit.setactioncommand("quit");quit.addactionlistener(this);quit.setlocation(int) (this.getwidth()-quit.getwidth()*1.5),username.getheight()/3);topbar.add(quit,borderlayout.east);this.add(topbar,borderlayout.north);/rightbarri

22、ghtbar=new jpanel();rightbar.setlayout(new gridlayout(4,1);this.add(rightbar,borderlayout.east);operationp=new jpanel();operationp.setlayout(new flowlayout();operationt=new jlabel("选择表：");operation=new jcombobox(list);operation.additemlistener(new itemlistener()overridepublic void itemstat

23、echanged(itemevent arg0) searcht.settext("请输入"+ operation.getselecteditem().tostring().substring(0,2)+ "编号");model=new mytablemodel(operation.getselecteditem().tostring();content.setmodel(model);) ;operationp.add(operationt);operationp.add(operation);buttonp=new jpanel();buttonp.

24、setlayout(new gridlayout(3,1);alert=new jbutton("修改");alert.addactionlistener(this);alert.setactioncommand("alert");insert=new jbutton("增加");insert.addactionlistener(this);insert.setactioncommand("insert");delete=new jbutton("删除");delete.addactionlis

25、tener(this);delete.setactioncommand("delete");buttonp.add(alert);buttonp.add(insert);buttonp.add(delete);operationp.add(buttonp);rightbar.add(operationp);search=new jlabel("关键字：");searcht=new jtextfield(10);searcht.settext("请输入"+operation.getselecteditem().tostring().su

26、bstring(0,2)+"编号");searchb=new jbutton("搜索");searchb.addactionlistener(this);searchb.setactioncommand("search");searchp=new jpanel();searchp.setlayout(new flowlayout();searchp.add(search);searchp.add(searcht);searchp.add(searchb);rightbar.add(searchp);remind=new jlabel(

27、);rightbar.add(remind);/centerbarmodel=new mytablemodel(operation.getselecteditem().tostring();content=new jtable(model);scroll=new jscrollpane(content);this.add(scroll,borderlayout.center);this.settitle("教室管理系统");this.setresizable(false);this.setlocation(180,60);this.setsize(1000, 600);th

28、is.setvisible(true);this.setdefaultcloseoperation(jframe.exit_on_close);overridepublic void actionperformed(actionevent arg0) if(arg0.getactioncommand()="quit")system.exit(0);if(arg0.getactioncommand()="search")search2uniontable();return;if(string)operation.getselecteditem()=&quo

29、t;教室具体使用情况")new reminddialog(this, "提示",true,0);return;if(arg0.getactioncommand()="insert")new insert(this,"增加新数据",true,operation.getselecteditem().tostring();model=new mytablemodel(operation.getselecteditem().tostring();content.setmodel(model);return;if(content.ge

30、tselectedrow()=-1)new reminddialog(this, "提示",true,1);return;if(arg0.getactioncommand()="alert")vector v=(vector)mytablemodel.rowdata.get(content.getselectedrow();new update(this,"修改",true,operation.getselecteditem().tostring(),v);model=new mytablemodel(operation.getsel

31、ecteditem().tostring();content.setmodel(model);return;if(arg0.getactioncommand()="delete")vector v=(vector) mytablemodel.rowdata.get(content.getselectedrow();new delete(this,"删除",true,v,operation.getselecteditem().tostring();model=new mytablemodel(operation.getselecteditem().tost

32、ring();content.setmodel(model);return;private void search2uniontable()vector v=mytablemodel.select(operation.getselecteditem().tostring();vector rowdata=new vector();iterator iterator=v.iterator();string rnum=searcht.gettext().tostring().trim();while(iterator.hasnext()vector tem=(vector)iterator.nex

33、t();if(string)tem.get(0).equals(rnum)rowdata.add(tem);if(rowdata.size()=0)remind.settext("-无该教室信息-");return;elseremind.settext("");mytablemodel my=new mytablemodel(rowdata,mytablemodel.columnnames);content.setmodel(my);4.向主界面中加载数据package dev.chall.util;import java.sql.connection;

34、import java.sql.drivermanager;import java.sql.preparedstatement;import java.sql.resultset;import java.sql.sqlexception;import java.util.vector;import javax.swing.table.abstracttablemodel;public class mytablemodel extends abstracttablemodelpublic static vector rowdata;public static vector columnnames

35、;public mytablemodel(string value) select(value);public mytablemodel(vector rowdata,vector columnnames) this.rowdata=rowdata;this.columnnames=columnnames;public static vector select(string value)rowdata=new vector();columnnames=new vector();connection connection=null;preparedstatement ps=null;result

36、set rs=null;string sql = null;if(value="教师信息")columnnames.add("教师编号");columnnames.add("教师姓名");columnnames.add("教授课程");columnnames.add("教师职称");sql="select * from teacherinfo"else if(value="教室信息")columnnames.add("教室编号");co

37、lumnnames.add("教室设备");columnnames.add("教室容纳人数");columnnames.add("教室管理员编号");sql="select * from classinfo"else if(value="教室使用情况")columnnames.add("教室编号");columnnames.add("上课开始时间");columnnames.add("结束时间");columnnames.add(&qu

38、ot;教师编号");sql="select 教室编号, convert(varchar(20),上课开始时间,111),convert(varchar(20),上课开始时间,108),convert(varchar(20),结束时间,111) ,convert(varchar(20),结束时间,108), 教师编号 from classroominfo"else if(value="教室具体使用情况")columnnames.add("教室编号");columnnames.add("教师编号");colu

39、mnnames.add("教师姓名");columnnames.add("教授课程");columnnames.add("上课开始时间"); columnnames.add("结束时间");columnnames.add("教师职称");columnnames.add("教室设备");columnnames.add("教室容纳人数");columnnames.add("教室管理员编号");sql="select classin

40、fo.教室编号,teacherinfo.教师编号,teacherinfo.教师姓名,teacherinfo.教授课程, convert(varchar(20),classroominfo.上课开始时间,111),convert(varchar(20),classroominfo.上课开始时间,108),convert(varchar(20),classroominfo.结束时间,111) ,convert(varchar(20),classroominfo.结束时间,108) ,teacherinfo.教师职称,classinfo.教室设备,classinfo.教室容纳人数,classinfo

41、.教室管理员编号 from classroominfo,teacherinfo,classinfo where classinfo.教室编号= classroominfo.教室编号 and teacherinfo.教师编号=classroominfo.教师编号"try /加载驱动class.forname("sun.jdbc.odbc.jdbcodbcdriver");/得到连接 connection=drivermanager.getconnection("jdbc:odbc:classmanager", "sa", &q

42、uot;songchao");/创建访问数据库接口ps=connection.preparestatement(sql);rs=ps.executequery();if(value="教师信息")while(rs.next()vector tem=new vector();tem.add(rs.getstring(1);tem.add(rs.getstring(2);tem.add(rs.getstring(3);tem.add(rs.getstring(4);rowdata.add(tem);else if(value="教室信息")whil

43、e(rs.next()vector tem=new vector();tem.add(rs.getstring(1);tem.add(rs.getstring(2);tem.add(rs.getint(3);tem.add(rs.getstring(4);rowdata.add(tem);else if(value="教室使用情况")while(rs.next()vector tem=new vector();tem.add(rs.getstring(1);tem.add(rs.getstring(2)+"/"+rs.getstring(3);tem.a

44、dd(rs.getstring(4)+"/"+rs.getstring(5);tem.add(rs.getstring(6);rowdata.add(tem);else if(value="教室具体使用情况")while(rs.next()vector tem=new vector();tem.add(rs.getstring(1);tem.add(rs.getstring(2);tem.add(rs.getstring(3);tem.add(rs.getstring(4);tem.add(rs.getstring(5)+"/"+rs

45、.getstring(6);tem.add(rs.getstring(7)+"/"+rs.getstring(8);tem.add(rs.getstring(9);tem.add(rs.getstring(10);tem.add(rs.getint(11);tem.add(rs.getstring(12);rowdata.add(tem); catch (exception e) e.printstacktrace();finallytry rs.close();ps.close();connection.close(); catch (sqlexception e) e.

46、printstacktrace();return rowdata;overridepublic string getcolumnname(int arg0) return (string) columnnames.get(arg0);overridepublic int getcolumncount() return columnnames.size();overridepublic int getrowcount() return rowdata.size();override public object getvalueat(int rowindex, int columnindex) r

47、eturn (vector)rowdata.get(rowindex).get(columnindex);5.实现主界面中修改按钮功能package dev.chall.otherinterface;import java.awt.color;import java.awt.flowlayout;import java.awt.frame;import java.awt.gridlayout;import java.awt.event.actionevent;import java.awt.event.actionlistener;import java.sql.connection;impo

48、rt java.sql.drivermanager;import java.sql.preparedstatement;import java.sql.resultset;import java.sql.sqlexception;import java.util.arraylist;import java.util.vector;import javax.swing.jbutton;import javax.swing.jcombobox;import javax.swing.jdialog;import javax.swing.jlabel;import javax.swing.jpanel

49、;import javax.swing.jtextfield;import dev.chall.util.mytablemodel;public class update extends jdialogprivate jlabel warn=new jlabel();/提示文本private jbutton sure=new jbutton("-确定-");private jbutton cancle=new jbutton("-取消-");private string sql;final jtextfield t51=new jtextfield(15

50、);final jtextfield t52=new jtextfield(15);final jtextfield t53=new jtextfield(15);final jtextfield t54=new jtextfield(15);public update(frame owner, string title, boolean modal,string name,final vector v) super(owner, title, modal);warn.setbounds(0, 0, 300, 50);t51.settext(v.get(0).tostring();t51.se

51、teditable(false);t52.settext(v.get(1).tostring();t53.settext(v.get(2).tostring();t54.settext(v.get(3).tostring();if(name="教师信息")jlabel t1=new jlabel("教师编号:");jlabel t2=new jlabel("教师姓名:");jlabel t3=new jlabel("教授课程:");jlabel t4=new jlabel("教师职称:");su

52、re.addactionlistener(new actionlistener()overridepublic void actionperformed(actionevent e) string tnum=t51.gettext();string tname=t52.gettext().trim();string tcourse=t53.gettext().trim();string ttitle=t54.gettext().trim();if(tnum.length()<=0|tname.length()<=0|tcourse.length()<=0|ttitle.len

53、gth()<=0)warn.settext("-信息不全-");return;sql="update teacherinfo set 教师姓名='"+tname+"',教授课程 ='"+tcourse+"',教师职称='"+ttitle+"' where 教师编号 = '"+tnum+"'"update2table(sql);update.this.dispose(););cancle.addactionl

54、istener(new actionlistener()overridepublic void actionperformed(actionevent e) update.this.dispose(););this.add(t1);this.add(t51);this.add(t2);this.add(t52);this.add(t3);this.add(t53);this.add(t4);this.add(t54);this.add(sure);this.add(cancle);this.add(warn);this.setlayout(new flowlayout();this.setsize(250,300);this.setlocation(550, 100);this.setresizable(false);this.setvisible(true);this.setdefaultcloseoperation(dispose_on_close);else if(name="教室信息")jlabel t1=new jlabel(" 教 室 编 号:");jlabel t2=new jlab