用java编教务系统的源码

1、import Java . awt . *；import javax . swing . *；import Java . awt . event . *；import javax . swing . border . *；import javax . swing . joption pane；import javax . swing . jlabel；import javax . swing . jp anel；import javax . swing . table . default table model；import javax . swing . table . table colu

2、mn；import Java . SQL . *；import Java . awt . grid layout；Public class my studentPublic myStudent() public static void main(stringargs)/TODO code application logic hereLoginFrame lf=new LoginFrame()；lf . set visible(true)；lf . addwindowslistener(new window adapter()public void window closing(window e

3、vent e)system . exit(0)；)；/主界面class mainframe extends jframe implements action listener MenuBar my MenuBar=new MenuBar()；Menu my menu file、mymenu edit、mymenu user、mymenu aboutMenuitem minew、miopen、mi save、misa veas、mi exitMenuitem miadd、mi edit、midel、mi find、mi show、miuser、mi aboutpublic JTable tabl

4、e=new JTable()；Public DefaultTableModel mmPublic mainFrame()MyMenuFile=new Menu(“文件”)；MiNew=new MenuItem(“新建”)；MiOpen=new MenuItem(“打开”)；MiSave=new MenuItem(“保存”)；MiExit=new MenuItem(“退出”)；/minew . enable(false)；/mio pen . enable(false)；/misave . enable(false)；/my menufile . add(miNew)；/my menufile

5、. add(mio pen)；/my menufile . add(miSave)；my menufile . add(miExit)；MyMenuEdit=new Menu(“编辑数据”)；MiFind=new MenuItem(“查找数据”)；MiAdd=new MenuItem(“添加数据”)；MiEdit=new MenuItem(“数据修改”)；MiDel=new MenuItem(“数据擦除”)；MiShow=new MenuItem(“全部显示”)；my menue dit . add(miFind)；my menue dit . add(miAdd)；my menue dit

6、. add(miEdit)；mymenue dit . add(miDel)；my menue dit . add(miShow)；MyMenuUser=new Menu(“用户”)；MiUser=new MenuItem(“编辑用户”)；my menuser . add(miUser)；MyMenuAbout=new Menu(“我的工作”)；MiAbout=new MenuItem(“作业说明”)；my menuabout . add(miAbout)；menubar.add(我的菜单文件)；menubar.add(编辑我的菜单)；my menubar . add(my menuser)；

7、my menubar . add(my menuabout)；String col= 学号，名字，姓氏，民族，年龄，年级，班级，专业 /Mm=new DefaultTableModel(col，0)；table . set model(mm)；jscroll pane table scroll pane=new jscroll pane(table)；This .set menubarthis . add(table scroll pane)；miexit . addaction listener(this)；mifind . addaction listener(this)；miadd .

8、addaction listener(this)；miedit . addaction listener(this)；midel . addaction listener(this)；美秀。addaction listener(this)；miuser . addaction listener(this)；miabout . addaction listener(this)；public void fresh table(string SQL)my connection conn=new my connection()；ResultSet RSRS=conn . get result(SQL)

9、；If (rs)！=null)Try mm . setrow count(0)；table . set model(mm)；While (rs.next ()String学号=rs.getString(学号)；String名称=rs.getString(“名称”)；String性别=rs.getString(性别)；字串民族=rs.getString(民族)；String年龄=rs.getString(“年龄”)；String年级=rs.getString(年级)；String类=rs.getString(“类”)；string specialty=RS . getstring( specia

10、lty )；String cloumns=学号，名字，性别，民族，年龄，年级，班级，专业；mm . addrow(cloumns)；/table . clear selection()；table . set model(mm)； catch (exception e)system . out . print ln(e . tostring()；public void action performed(action event e)/退出If (e.getSource()=miExit)system . exit(0)；/查找 else if(e . get source()=mi find)

11、find frame ff=new find frame(this)；ff . setvisible(true)；/添加else if(e.getSource()=miAdd)add frame af=new add frame(this)；af . set visible(true)；/修改 else if(e . get source()=mi edit)if(table . getselectedrow()=-1)joption pane . showmessagedialog(null，选择修改)，“温暖的提示”，joption pane . information _ message

12、)； elseedit frame ef=new edit frame(this)；Ef .学号。settext(string)table . get value at(table . getselectedrow()0)；Ef .名字。settext(string)table . get value at(table . getselectedrow()1)；Ef .性别。settext(string)table . get value at(table . getselectedrow()2)；Ef .民族。settext(string)table . get value at(table

13、 . getselectedrow()3)；ef . age . settext(string)table . getvalue at(table . getselectedrow()4)；Ef .年级。settext(string)table . get value at(table . getselectedrow()5)；Ef .类。settext(string)table . get value at(table . getselectedrow()6)；Ef .professional . settext(string)table . get value at(table . get

14、selectedrow()7)；ef . set visible(true)；this . fresh table( select * from student information table )；/删除else if(e.getSource()=miDel)if(table . getselectedrow()=-1)joption pane . show messagedialog(null，“选择要删除的行”，“温暖的提示”，joption pane . information _ message)； elseString sql=delete from学生信息表where学号= t

15、able . get value at(table . getselectedrow()0) ；/joption pane . show messagedialog(null，SQL，“温暖的提示”，joption pane . information _ message)；my connection conn=new my connection()；If (conn.execute SQL (SQL)joption pane . show messagedialog(null，“已成功删除”，“温暖的提示”，joption pane . information _ message)；this

16、 . fresh table( select * from student information table )； elsejoption pane . show messagedialog(null，“未知错误”，“删除失败”，joption pane . information _ message)；/显示 else if(e . get source()=mi show)/joption pane . show messagedialog(null，“未知错误”，“删除失败”，joption pane . information _ message)；this . fresh table( select * from student information table )；/用户管理 else if(e . get source()=miuser)user frame uf=new user fra