209_4512088_教室管理系统的源代码.doc

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 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 classinfovalues(4101,投影仪,40,01)insert classinfovalues(4102,电脑,50,02)insert teacherinfovalues(0a,李萍,计算机系统分,讲师)insert teacherinfovalues(0b,李明,c语言,教授)insert 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.awt.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.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 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 jlabel(登录名:);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.setactioncommand(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, 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(提示：用户名或密码为空！);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 /加载驱动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 namet=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.printstacktrace();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.chall.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.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.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 implements 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 jtextfieldsearcht;/搜索字样 /centerbarprivatejscrollpane scroll;privatejtable content;private mytablemodel model;private string list=new string教师信息,教室信息,教室使用情况,教室具体使用情况;private jlabel remind;public static void main(string args)new controlinterface();public controlinterface()/登录界面 -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.add(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);/rightbarrightbar=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 itemstatechanged(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.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.addactionlistener(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().substring(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();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);this.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()=教室具体使用情况)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.getselectedrow()=-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.getselecteditem().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().tostring();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.next();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;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;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;resultset rs=null;string sql = null;if(value=教师信息)columnnames.add(教师编号);columnnames.add(教师姓名);columnnames.add(教授课程);columnnames.add(教师职称);sql=select * from teacherinfo;else if(value=教室信息)columnnames.add(教室编号);columnnames.add(教室设备);columnnames.add(教室容纳人数);columnnames.add(教室管理员编号);sql=select * from classinfo;else if(value=教室使用情况)columnnames.add(教室编号);columnnames.add(上课开始时间);columnnames.add(结束时间);columnnames.add(教师编号);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(教师编号);columnnames.add(教师姓名);columnnames.add(教授课程);columnnames.add(上课开始时间); columnnames.add(结束时间);columnnames.add(教师职称);columnnames.add(教室设备);columnnames.add(教室容纳人数);columnnames.add(教室管理员编号);sql=select classinfo.教室编号,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.教室管理员编号 from classroominfo,teacherinfo,classinfo where classinfo.教室编号= classroominfo.教室编号 and teacherinfo.教师编号=classroominfo.教师编号;try /加载驱动class.forname(sun.jdbc.odbc.jdbcodbcdriver);/得到连接 connection=drivermanager.getconnection(jdbc:odbc:classmanager, sa, 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=教室信息)while(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.add(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.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.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) return (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;import 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;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);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.seteditable(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(教师职称:);sure.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.length()=0)warn.settext(-信息不全-);return;sql=update teacherinfo set 教师姓名=+tname+,教授课程 =+tcourse+,教师职称=+ttitle+ where 教师编号 = +tnum+;update2table(sql);update.this.dispose(););cancle.addactionlistener(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=