guest.java

数据库管理类

    ImageIcon select=new ImageIcon("images/select.gif");
    selectButton=new JButton("查询",select);
    selectButton.addActionListener(this);
    sButton=new JButton("单项查询");
    sButton.addActionListener(this);
    hf=new JButton("返回");
    
    
    wxx=new JButton("退出");
    wxx.addActionListener(this);
    ImageIcon login=new ImageIcon("images/login.gif");
    loginButton=new JButton("登  录",login);
    loginButton.addActionListener(this);
    ImageIcon exit=new ImageIcon("images/exit.gif");
    exitButton=new JButton("退出",exit);
    exitButton.addActionListener(this);
    
    //基本数据窗体basicDataPane
    JPanel basicDataPane=new JPanel();
    BorderLayout basicDataPane_Layout=new BorderLayout();
    basicDataPane.setLayout(basicDataPane_Layout);
    
    JPanel dataPane = new JPanel();
    GridBagLayout dataPane_Layout=new GridBagLayout();
    dataPane.setLayout(dataPane_Layout);
    GridBagConstraints dataGbc=new  GridBagConstraints();
    
    //Label("学号")
    dataGbc.gridx=0;dataGbc.gridwidth=1;
    dataGbc.gridy=1;dataGbc.gridheight=1;    
    dataGbc.anchor=GridBagConstraints.WEST;
    dataPane.add(label1,dataGbc);
    //text("学号")
    dataGbc.gridx=1;dataGbc.gridwidth=1;
    dataGbc.gridy=1;dataGbc.gridheight=1;    
    dataGbc.anchor=GridBagConstraints.WEST;
    dataPane.add(text1,dataGbc);
    //Label("姓名");
    dataGbc.gridx=3;dataGbc.gridwidth=1;
    dataGbc.gridy=1;dataGbc.gridheight=1;    
    dataGbc.anchor=GridBagConstraints.EAST;
    dataPane.add(label2,dataGbc);
    //text("姓名")
    dataGbc.gridx=4;dataGbc.gridwidth=1;
    dataGbc.gridy=1;dataGbc.gridheight=1;    
    dataGbc.anchor=GridBagConstraints.WEST;
    dataPane.add(text2,dataGbc);
    //Label("性别");
    dataGbc.gridx=6;dataGbc.gridwidth=1;
    dataGbc.gridy=1;dataGbc.gridheight=1;    
    dataGbc.anchor=GridBagConstraints.WEST;
    dataPane.add(label3,dataGbc);
    //text("性别")
    dataGbc.gridx=7;dataGbc.gridwidth=1;
    dataGbc.gridy=1;dataGbc.gridheight=1;    
    dataGbc.anchor=GridBagConstraints.WEST;
    dataPane.add(sexComboBox,dataGbc);
    //
    dataGbc.gridx=1;dataGbc.gridwidth=1;
    dataGbc.gridy=3;dataGbc.gridheight=1;    
    dataGbc.anchor=GridBagConstraints.WEST;
    dataPane.add(spaceLabel1,dataGbc);
    //Label("班级");
    dataGbc.gridx=0; dataGbc.gridwidth=1;
    dataGbc.gridy=4; dataGbc.gridheight=1;    
    dataGbc.anchor=GridBagConstraints.WEST;
    dataPane.add(label4,dataGbc); 
    //text("班级")
    dataGbc.gridx=1;dataGbc.gridwidth=1;
    dataGbc.gridy=4;dataGbc.gridheight=1;    
    dataGbc.anchor=GridBagConstraints.WEST;
    dataPane.add(text4,dataGbc);
     //Label("所在院系");
    dataGbc.gridx=3;dataGbc.gridwidth=1;
    dataGbc.gridy=4;dataGbc.gridheight=1;    
    dataGbc.anchor=GridBagConstraints.EAST;
    dataPane.add(label5,dataGbc);
    //text("所在院系")
    dataGbc.gridx=4;dataGbc.gridwidth=1;
    dataGbc.gridy=4;dataGbc.gridheight=1;   
    dataGbc.anchor=GridBagConstraints.WEST;
    dataPane.add(text5,dataGbc);
     //Label("专业");
    dataGbc.gridx=6;dataGbc.gridwidth=1;
    dataGbc.gridy=4;dataGbc.gridheight=1;    
    dataGbc.anchor=GridBagConstraints.WEST;
    dataPane.add(label6,dataGbc);
    //text("专业")
    dataGbc.gridx=7;dataGbc.gridwidth=1;
    dataGbc.gridy=4;dataGbc.gridheight=1;    
    dataGbc.anchor=GridBagConstraints.WEST;
    dataPane.add(collegeComboBox,dataGbc);
    //
    dataGbc.gridx=1;dataGbc.gridwidth=1;
    dataGbc.gridy=6;dataGbc.gridheight=1;    
    dataGbc.anchor=GridBagConstraints.WEST;
    dataPane.add(spaceLabel2,dataGbc);
     //Label("政治面貌");
    dataGbc.gridx=0;dataGbc.gridwidth=1;
    dataGbc.gridy=7;dataGbc.gridheight=1;    
    dataGbc.anchor=GridBagConstraints.WEST;
    dataPane.add(label7,dataGbc);
    //text("政治面貌")
    dataGbc.gridx=1;dataGbc.gridwidth=1;
    dataGbc.gridy=7;dataGbc.gridheight=1;    
    dataGbc.anchor=GridBagConstraints.WEST;
    dataPane.add(visageComboBox,dataGbc);
     //Label("宿舍");
    dataGbc.gridx=3;dataGbc.gridwidth=1;
    dataGbc.gridy=7;dataGbc.gridheight=1;    
    dataGbc.anchor=GridBagConstraints.EAST;
    dataPane.add(label8,dataGbc);
    //text("宿舍")
    dataGbc.gridx=4;dataGbc.gridwidth=1;
    dataGbc.gridy=7;dataGbc.gridheight=1;    
    dataGbc.anchor=GridBagConstraints.WEST;
    dataPane.add(text8,dataGbc);
    //Label("联系电话");
    dataGbc.gridx=6; dataGbc.gridwidth=1;
    dataGbc.gridy=7; dataGbc.gridheight=1;    
    dataGbc.anchor=GridBagConstraints.WEST;
    dataPane.add(label9,dataGbc);
    //text("联系电话")
    dataGbc.gridx=7;dataGbc.gridwidth=1;
    dataGbc.gridy=7;dataGbc.gridheight=1;    
    dataGbc.anchor=GridBagConstraints.WEST;
    dataPane.add(text9,dataGbc);
    //
    dataGbc.gridx=1;dataGbc.gridwidth=1;
    dataGbc.gridy=9;dataGbc.gridheight=1;    
    dataGbc.anchor=GridBagConstraints.WEST;
    dataPane.add(spaceLabel3,dataGbc);
    //Label("通讯地址");
    dataGbc.gridx=0;dataGbc.gridwidth=1;
    dataGbc.gridy=10;dataGbc.gridheight=1;    
    dataGbc.anchor=GridBagConstraints.WEST;
    dataPane.add(label10,dataGbc);
    //text("通讯地址")
    dataGbc.gridx=1;dataGbc.gridwidth=4;
    dataGbc.gridy=10;dataGbc.gridheight=1;    
    dataGbc.anchor=GridBagConstraints.WEST;
    dataPane.add(text10,dataGbc);
    //Label("邮政编码");
    dataGbc.gridx=6;dataGbc.gridwidth=1;
    dataGbc.gridy=10;dataGbc.gridheight=1;    
    dataGbc.anchor=GridBagConstraints.WEST;
    dataPane.add(label11,dataGbc);
    //text("邮政编码")
    dataGbc.gridx=7;dataGbc.gridwidth=3;
    dataGbc.gridy=10;dataGbc.gridheight=1;    
    dataGbc.anchor=GridBagConstraints.WEST;
    dataPane.add(text11,dataGbc);
    //
    dataGbc.gridx=1;dataGbc.gridwidth=1;
    dataGbc.gridy=12;dataGbc.gridheight=1;    
    dataGbc.anchor=GridBagConstraints.WEST;
    dataPane.add(spaceLabel4,dataGbc);
    //Label("个人特长");
    dataGbc.gridx=0;dataGbc.gridwidth=1;
    dataGbc.gridy=13;dataGbc.gridheight=1;    
    dataGbc.anchor=GridBagConstraints.WEST;
    dataPane.add(label12,dataGbc);
    //Label("及简介");
    dataGbc.gridx=0;dataGbc.gridwidth=1;
    dataGbc.gridy=14;dataGbc.gridheight=1;    
    dataGbc.anchor=GridBagConstraints.WEST;
    dataPane.add(label15,dataGbc);
    //text("个人特长及简介")
    dataGbc.gridx=1;dataGbc.gridwidth=7;
    dataGbc.gridy=13;dataGbc.gridheight=3;    
    dataGbc.anchor=GridBagConstraints.WEST;
    dataPane.add(scrPane,dataGbc);  
    
    //基本数据窗体basicDataPane下的数据组件
    Border dataEtched=BorderFactory.createEtchedBorder();
    Border dataTitled=BorderFactory.createTitledBorder(dataEtched,"学生基本信息");
    dataPane.setBorder(dataTitled);
    basicDataPane.add(dataPane,BorderLayout.CENTER);
    JScrollPane scrPane2=new JScrollPane(text31); 
    //成绩窗体basicGradePane
    JPanel basicGradePane=new JPanel();
    BorderLayout basicGradePane_Layout=new BorderLayout();
    basicGradePane.setLayout(basicGradePane_Layout);
    
    JPanel gradePane = new JPanel();
    Border gradeEtched=BorderFactory.createEtchedBorder();
    Border gradeTitled=BorderFactory.createTitledBorder(gradeEtched,"学生成绩信息");
    gradePane.setBorder(gradeTitled);    
    GridBagLayout gradePane_Layout=new GridBagLayout();
    gradePane.setLayout(gradePane_Layout);
    GridBagConstraints gradeGbc=new  GridBagConstraints();
     //Label("学号")
    gradeGbc.gridx=0; gradeGbc.gridwidth=1;   
    gradeGbc.gridy=1; gradeGbc.gridheight=1;
    gradeGbc.anchor=GridBagConstraints.WEST;
    gradePane.add(label21,gradeGbc);
    //text("学号")
    gradeGbc.gridx=1; gradeGbc.gridwidth=1;  
    gradeGbc.gridy=1; gradeGbc.gridheight=1;
    gradeGbc.anchor=GridBagConstraints.WEST;
    gradePane.add(text21,gradeGbc);
    //Label("姓名");
    gradeGbc.gridx=3;gradeGbc.gridwidth=1;     
    gradeGbc.gridy=1;gradeGbc.gridheight=1;
    gradeGbc.anchor=GridBagConstraints.WEST;
    gradePane.add(label22,gradeGbc);
    //text("姓名")
    gradeGbc.gridx=4;gradeGbc.gridwidth=1;    
    gradeGbc.gridy=1;gradeGbc.gridheight=1;
    gradeGbc.anchor=GridBagConstraints.WEST;
    gradePane.add(text22,gradeGbc);
    //Label("课程安排");
    gradeGbc.gridx=6;gradeGbc.gridwidth=1;
    gradeGbc.gridy=1;gradeGbc.gridheight=1;
    gradeGbc.anchor=GridBagConstraints.WEST;
    gradePane.add(label23,gradeGbc);
    //text("课程安排")
    gradeGbc.gridx=7;gradeGbc.gridwidth=1;
    gradeGbc.gridy=1;gradeGbc.gridheight=1;
    gradeGbc.anchor=GridBagConstraints.WEST;
    gradePane.add(planComboBox,gradeGbc);
    //
    gradeGbc.gridx=1;gradeGbc.gridwidth=1;
    gradeGbc.gridy=3;gradeGbc.gridheight=1;
    gradeGbc.anchor=GridBagConstraints.WEST;
    gradePane.add(spaceLabel5,gradeGbc);
    //Label("班级");
    gradeGbc.gridx=0;gradeGbc.gridwidth=1;
    gradeGbc.gridy=4;gradeGbc.gridheight=1;
    gradeGbc.anchor=GridBagConstraints.WEST;
    gradePane.add(label24,gradeGbc); 
    //text("班级")
    gradeGbc.gridx=1;gradeGbc.gridwidth=1;
    gradeGbc.gridy=4;gradeGbc.gridheight=1;
    gradeGbc.anchor=GridBagConstraints.WEST;
    gradePane.add(text24,gradeGbc);
     //Label("专业");
    gradeGbc.gridx=3;gradeGbc.gridwidth=1;
    gradeGbc.gridy=4;gradeGbc.gridheight=1;    
    gradeGbc.anchor=GridBagConstraints.WEST;
    gradePane.add(label25,gradeGbc);
    //text("专业")
    gradeGbc.gridx=4;gradeGbc.gridwidth=1;
    gradeGbc.gridy=4;gradeGbc.gridheight=1;    
    gradeGbc.anchor=GridBagConstraints.WEST;
    gradePane.add(text25,gradeGbc);
     //Label("所在院系");
    gradeGbc.gridx=6;gradeGbc.gridwidth=1;
    gradeGbc.gridy=4;gradeGbc.gridheight=1;    
    gradeGbc.anchor=GridBagConstraints.WEST;
    gradePane.add(label26,gradeGbc);
    //text("所在院系")
    gradeGbc.gridx=7;gradeGbc.gridwidth=1;
    gradeGbc.gridy=4;gradeGbc.gridheight=1;    
    gradeGbc.anchor=GridBagConstraints.WEST;
    gradePane.add(collegeBox,gradeGbc);
    //
    gradeGbc.gridx=1;gradeGbc.gridwidth=1;
    gradeGbc.gridy=5;gradeGbc.gridheight=1;
    gradeGbc.anchor=GridBagConstraints.WEST;
    gradePane.add(spaceLabel6,gradeGbc);
     //Label("课程编号");
    gradeGbc.gridx=0;gradeGbc.gridwidth=1;
    gradeGbc.gridy=6;gradeGbc.gridheight=1;    
    gradeGbc.anchor=GridBagConstraints.WEST;
    gradePane.add(label27,gradeGbc);
    //text("课程编号")
    gradeGbc.gridx=1;gradeGbc.gridwidth=1;
    gradeGbc.gridy=6;gradeGbc.gridheight=1;    
    gradeGbc.anchor=GridBagConstraints.WEST;
    gradePane.add(text27,gradeGbc);
     //Label("课程名称");
    gradeGbc.gridx=3;gradeGbc.gridwidth=1;
    gradeGbc.gridy=6;gradeGbc.gridheight=1;    
    gradeGbc.anchor=GridBagConstraints.EAST;
    gradePane.add(label28,gradeGbc);
    //text("课程名称")
    gradeGbc.gridx=4;gradeGbc.gridwidth=1;
    gradeGbc.gridy=6;gradeGbc.gridheight=1;   
    gradeGbc.anchor=GridBagConstraints.WEST;
    gradePane.add(text28,gradeGbc);
    //Label("指导老师");
    gradeGbc.gridx=6;gradeGbc.gridwidth=1;
    gradeGbc.gridy=6;gradeGbc.gridheight=1;    
    gradeGbc.anchor=GridBagConstraints.WEST;
    gradePane.add(label29,gradeGbc);
    //text("指导老师")
    gradeGbc.gridx=7;gradeGbc.gridwidth=1;
    gradeGbc.gridy=6;gradeGbc.gridheight=1;    
    gradeGbc.anchor=GridBagConstraints.WEST;
    gradePane.add(text29,gradeGbc);
    //
    gradeGbc.gridx=1;gradeGbc.gridwidth=1;
    gradeGbc.gridy=8;gradeGbc.gridheight=1;
    gradeGbc.anchor=GridBagConstraints.WEST;
    gradePane.add(spaceLabel7,gradeGbc);