数据库期末大作业

班级：1 ：学号2采用的数据库是：Access数据库；其中一共有1 表否否是表否是3myframe：建立主页面样式（包括：窗体名称、菜单项目（学生管理-学生；4importjava.awt.*;importjava.awt.event.*;importjavax.swing.*;importjava.sql.*;importimportjava.text.SimpleDateFormat;publicclassJdbc{publicstaticvoidmain(String{myframemf=new}}classmyframeextendsJFrameimplements{Barmb;m1,m2;Labellb1=newLabel("学籍管理系统Labellb2=newLabel("20097720119计算机辅助设计1班飞",Label.CENTER);Itemmi1,mi2,mi3,mi4;{setTitle("学籍管理系统--制作:20097720119计算机辅助设计飞");mb=newBar();m1=new("学生管理m2=new("系统mi1=newItem("学生查询");mi2=newItem("学生录入");mi3=newItem("退出系统Containercon=this.getContentPane();con.setLayout(newGridLayout(4,1,1,1));lb1.setFont(newFont("黑体",Font.BOLD,60));lb2.setFont(newFont("黑体}publicvoidactionPerformed(ActionEvent{{xscxxs=newxscx();}else{xstjxs=newxstj();}else{}}}class JFrameimplements{JLabellb1;JTextFieldtf1;JButtonbt1,bt2;{lb1=newJLabel("请输入学生的学号:");tf1=newJTextField(7);bt1=newJButton("查询");bt2=newJButton("Containercon=this.getContentPane();lb1.setFont(newFont("宋体",Font.BOLD,12));tf1.setFont(newFont("宋体",Font.BOLD,12));bt1.setFont(newFont("宋体",Font.BOLD,12));bt2.setFont(newFont("宋体}publicvoidactionPerformed(ActionEvent{DatabaseDB=newDatabase();DatabaseDB1=newDatabase();inttem;Stringtemp[]=newString[6];StringBuffermess=newStringBuffer();{{

DB.rs=DB.executeQuery("select*fromwhere学号{Stringsql1="select*fromfenshuwhere号{mess.append(""+DB1.rs.getString(1)+}}}catch(Exception{}{}}}}class JFrameimplements{JLabelJTextFieldtf1,tf2,tf3;JButtonbt1,bt2;{lb1=newJLabel("学号");tf1=newJTextField(10);lb2=newJLabel("");tf2=newJTextField(10);lb3=newJLabel("生日");tf3=newJTextField(10);bt1=newJButton("插入");bt2=newJButton("Containercon=this.getContentPane();}publicvoidactionPerformed(ActionEvent{DatabaseDB=newDatabase();{{if(tf1.getText().length()!=0tf2.getText().length()!=0&&{Strings=newStringsql="insertintomessage}}catch(Exception{}{}}}}classDatabaseprivateStatementstmt=null;ResultSetrs=null;privateConnectionconn=null;Stringsql;Stringpublic}publicvoidOpenConn()throwsException{}catch(SQLException}}publicResultSetexecuteQuery(Stringsql){stmt=null;}catch(SQLException}return}publicvoidexecuteUpdate(Stringsq