guest.java

数据库管理类

package app.guest;
import app.login.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.event.*;
import java.util.*;
import javax.swing.border.*;
import java.sql.*;
import javax.swing.table.*;
import java.net.*;
import java.io.*;
import java.awt.datatransfer.*;
public class guest extends JFrame
   implements ChangeListener,ActionListener,ItemListener
 {
  private static final int DATA = 0;
  private static final int GRADE = 1;
  private static final int DATATABLE = 2;
  private static final int GRADETABLE= 3;
  private int ra1,ra2,ra3,ra4,rrr1,rrr2,rrr3,rrr0;
  private JButton hf,wxx,selectButton,exitButton,loginButton,nextButton,sButton;
  private JButton previousButton,addButton,delButton,updateButton,cleanButton;
  private Clipboard sysClipboard;
  private JCheckBox selectItem;
  private JComboBox queryDataComboBox,queryGradeComboBox;
  private JComboBox dataNameComboBox,gradeNameComboBox;
  private JComboBox dataComboBox,gradeComboBox;
  private JComboBox sexComboBox,visageComboBox,collegeComboBox,collegeBox;
  private JComboBox planComboBox;
  private AboutDialog aboutDialog;
  private GridBagConstraints sSelectGbc;    
  private ImageIcon icon1,icon2;
  private ImageIcon icon;
  private JLabel clewLabel,selectLabel,selectLabel2,selectLabel3;
  private JMenuItem saveItem;
  private JMenuItem saveAsItem;
  private JPanel dataTablePane,gradeTablePane;
  private JPanel particularSelectPane,simplenessSelectPane;
  private JPopupMenu popup;
  private JRadioButton ra1Button,ra2Button,ra3Button,ra4Button,selectRadioButton;
  private JScrollPane scrollTablePane,scrollGradeTablePane;
  private String datasheetString,segmentString,query,text,dataquery;
  private String getItemString1,getItemString2,dataQueryString;
  private String getItemString3,getItemString4,gradequery;
  private String getItemString5,getItemString6;
  private String queryDataName[]={"所有","学号","姓名","性别","班级","所在院系","专业",
                              "政治面貌","宿舍","联系电话","通讯地址","邮政编码"};
  private String queryGradeName[]={"所有","学号","姓名","课程安排","班级","所在院系","专业",
                              "课程编号","课程名称","指导老师","考试成绩"};
  private String DataName[]={"学号","姓名","性别","班级","所在院系","专业",
                              "政治面貌","宿舍","联系电话","通讯地址","邮政编码"};
  private String GradeName[]={"学号","姓名","课程安排","班级","所在院系","专业",
                              "课程编号","课程名称","指导老师","考试成绩"};
  private String Data[]={"","学号","姓名","性别","班级","所在院系","专业",
                              "政治面貌","宿舍","联系电话","通讯地址","邮政编码"};
  private String Grade[]={"","学号","姓名","课程安排","班级","所在院系","专业",
                              "课程编号","课程名称","指导老师","考试成绩"};                            
  private String sexName[]={"","男","女"}; 
  private String visageName[]={"","党员","团员"}; 
  private String collegeName[]={"","计科系","成教学院"};
  private String planName[]={"","大一","大二","大三","大四"};                      
  private JTabbedPane tabbedPane; 
  private JTextField text1,text2,text3,text4,text5,text6,text7,text8,
                     text9,text10,text11,text13,text21,text22,text23,
                     text24,text25,text26,text27,text28,text29,text30,
                     queryText;
  private JTextArea text12,text31;
  private ResultSetTableModel grademodel,datamodel,model;
  private Connection con;
  private Statement stmt;
  private PreparedStatement dataQuerystmt;    
  private ResultSet rs;                                     
  public guest()
   {try
      {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
       con =
       DriverManager.getConnection("jdbc:odbc:student");
      }
    catch (ClassNotFoundException e)
      {
      System.out.println(e.getMessage());
      }
    catch (SQLException sqlex)
     {sqlex.printStackTrace();
     clewLabel.setText(sqlex.toString());
     }
    catch (Exception ex)
     { ex.printStackTrace();
       clewLabel.setText(ex.toString());
     }  
    setTitle("Welcome ");
    setSize(800,600);
    Toolkit tk=Toolkit.getDefaultToolkit();
    Image img=tk.getImage("images/Eagle.jpg");
    setIconImage(img);
    JLabel title   = new JLabel("学生基本信息");
    JToolBar bar = new JToolBar();
      
      Action copyAction     //快捷图标  exit
         = new AbstractAction("复制", new ImageIcon("images/copy.gif"))
            {  public void actionPerformed(ActionEvent event)
               {  queryText.copy();
               }
            };
      Action cutAction     //快捷图标  exit
         = new AbstractAction("剪切", new ImageIcon("images/cut.gif"))
            {  public void actionPerformed(ActionEvent event)
               {  queryText.cut();
               }
            };
      Action pasteAction     //快捷图标  exit
         = new AbstractAction("粘贴", new ImageIcon("images/paste.gif"))
            {  public void actionPerformed(ActionEvent event)
               {  queryText.paste();
               }
            };
      Action aboutAction     //关于图标  about
         = new AbstractAction("About", new ImageIcon("images/about.gif"))
            {  public void actionPerformed(ActionEvent event)
               { 
               }
            };        
      Action exitAction     //快捷图标  exit
         = new AbstractAction("Exit", new ImageIcon("images/edit_exit.gif"))
            {  public void actionPerformed(ActionEvent event)
               {  System.exit(0);
               }
            };      
      bar.add(new ToolBarButton(cutAction)); 
      bar.add(new ToolBarButton(copyAction));
      bar.add(new ToolBarButton(pasteAction));
      bar.addSeparator();
      bar.add(new ToolBarButton(aboutAction));
      bar.add(new ToolBarButton(exitAction));  
      
       //  菜单    
      JMenuBar mbar = new JMenuBar();
      setJMenuBar(mbar);
      JMenu fileMenu = new JMenu("文件(F)");  //文件菜单
      fileMenu.setMnemonic('F');

      mbar.add(makeMenu(fileMenu,
         new Object[]
         {  
            null,
            new JMenuItem("退出(X)", 'X')
         },
         this));
        
      JMenu editMenu = new JMenu("编辑(E)");
      editMenu.setMnemonic('E');
      mbar.add(makeMenu(editMenu,
         new Object[]
         {  new JMenuItem("剪切",
               new ImageIcon("images/cut.gif")),
            new JMenuItem("复制",
               new ImageIcon("images/copy.gif")),
            new JMenuItem("粘贴",
               new ImageIcon("images/paste.gif")),
           
         },
         this));
   
      JMenu helpMenu = new JMenu("帮助(H)");  //帮助菜单
      helpMenu.setMnemonic('H');

      mbar.add(makeMenu(helpMenu,
         new Object[]
         {  new JMenuItem("帮助索引 (I)", 'I'),
            
            new JMenuItem("关于软件 (A)", 'A')
         },
         this));

      popup = makePopupMenu(           //弹出菜单
         new Object[]
         { new JMenuItem("剪切",
               new ImageIcon("cut.gif")),
            new JMenuItem("复制",
               new ImageIcon("copy.gif")),
            new JMenuItem("粘贴",
               new ImageIcon("paste.gif")),
           
         },
         this);
    
     JLabel spaceLabel1=new JLabel("    ");
     JLabel spaceLabel2=new JLabel("    ");
     JLabel spaceLabel3=new JLabel("    ");
     JLabel spaceLabel4=new JLabel("    ");
     JLabel spaceLabel5=new JLabel("    ");
     JLabel spaceLabel6=new JLabel("    ");
     JLabel spaceLabel7=new JLabel("    ");
     JLabel spaceLabel8=new JLabel("    ");
     JLabel spaceLabel9=new JLabel("    ");
    //基本数据窗体数据
    JLabel label1=new JLabel("学 号");
    JLabel label2=new JLabel("姓 名");
    JLabel label3=new JLabel("性 别");
    JLabel label4=new JLabel("班 级");
    JLabel label5=new JLabel("专 业");
    JLabel label6=new JLabel("所在院系");
    JLabel label7=new JLabel("政治面貌");
    JLabel label8=new JLabel("宿 舍");
    JLabel label9=new JLabel("联系电话");
    JLabel label10=new JLabel("通讯地址");
    JLabel label11=new JLabel("邮政编码");
    JLabel label12=new JLabel("个人特长");
    JLabel label13=new JLabel("数据表");
    JLabel label14=new JLabel("数据字段名");
    JLabel label15=new JLabel("及  简介");
    label1.setFont(new Font("宋体", Font.BOLD ,16));
    label2.setFont(new Font("宋体", Font.BOLD ,16));
    label3.setFont(new Font("宋体", Font.BOLD ,16));
    label4.setFont(new Font("宋体", Font.BOLD ,16));
    label5.setFont(new Font("宋体", Font.BOLD ,16));
    label6.setFont(new Font("宋体", Font.BOLD ,16));
    label7.setFont(new Font("宋体", Font.BOLD ,16));
    label8.setFont(new Font("宋体", Font.BOLD ,16));
    label9.setFont(new Font("宋体", Font.BOLD ,16));
    label10.setFont(new Font("宋体", Font.BOLD ,16));
    label11.setFont(new Font("宋体", Font.BOLD ,16));
    label12.setFont(new Font("宋体", Font.BOLD ,16));
    label13.setFont(new Font("宋体", Font.BOLD ,16));
    label14.setFont(new Font("宋体", Font.BOLD ,16));
    label15.setFont(new Font("宋体", Font.BOLD ,16));
    text1=new JTextField(8);    text2=new JTextField(8);
    text3=new JTextField(4);    text4=new JTextField(8);
    text5=new JTextField(8);    text6=new JTextField(6);
    text7=new JTextField(4);    text8=new JTextField(8);
    text9=new JTextField(7);    text10=new JTextField(20);
    text11=new JTextField(7);   text12=new JTextArea("",3,30); 
    text13=new JTextField(10);  text12.setLineWrap(true);
    JScrollPane scrPane=new JScrollPane(text12); 
    sexComboBox=new JComboBox(sexName);
    visageComboBox=new JComboBox(visageName);
    collegeComboBox=new JComboBox(collegeName);
    collegeBox=new JComboBox(collegeName);
    planComboBox=new JComboBox(planName);
    //visageComboBox.setEditable(true);
    //成绩窗体数据
    JLabel label21=new JLabel("学 号");
    JLabel label22=new JLabel("姓 名");
    JLabel label23=new JLabel("课程安排");
    JLabel label24=new JLabel("班 级");
    JLabel label25=new JLabel("专 业");
    JLabel label26=new JLabel("所在院系");
    JLabel label27=new JLabel("课程编号");
    JLabel label28=new JLabel("课程名称");
    JLabel label29=new JLabel("指导老师");
    JLabel label30=new JLabel("考试成绩");
    JLabel label31=new JLabel("课程简介");
    label21.setFont(new Font("宋体", Font.BOLD ,16));
    label22.setFont(new Font("宋体", Font.BOLD ,16));
    label23.setFont(new Font("宋体", Font.BOLD ,16));
    label24.setFont(new Font("宋体", Font.BOLD ,16));
    label25.setFont(new Font("宋体", Font.BOLD ,16));
    label26.setFont(new Font("宋体", Font.BOLD ,16));
    label27.setFont(new Font("宋体", Font.BOLD ,16));
    label28.setFont(new Font("宋体", Font.BOLD ,16));
    label29.setFont(new Font("宋体", Font.BOLD ,16));
    label30.setFont(new Font("宋体", Font.BOLD ,16));
    label31.setFont(new Font("宋体", Font.BOLD ,16));
    text21=new JTextField(6);    text22=new JTextField(8);
    text23=new JTextField(6);    text24=new JTextField(6);
    text25=new JTextField(8);    text26=new JTextField(6);
    text27=new JTextField(4);    text28=new JTextField(8);
    text29=new JTextField(7);    text30=new JTextField(4);
    text31=new JTextArea("",3,30); text31.setLineWrap(true);
    clewLabel=new JLabel("欢迎您使用本软件.作者:黄飞，黄学锋");
    title.setFont(new Font("宋体", Font.BOLD ,16));
    
   
    ra1=1;ra2=0;ra3=0;ra4=1;
   
    rrr0=1;    rrr1=0;    rrr2=0;   rrr3=0; //判断点击那个tabbedPane            
   //dataPane//gradePane//dataTablePane//gradeTablePane
                     
    tabbedPane=new JTabbedPane();
    tabbedPane.addChangeListener(this);
    icon=new ImageIcon("images/1.gif");
    ImageIcon icon1=new ImageIcon("images/1.gif");
    ImageIcon icon2=new ImageIcon("images/2.gif");
    ImageIcon icon3=new ImageIcon("images/3.gif");
    ra1Button=new JRadioButton("数据表");
    ra2Button=new JRadioButton("成绩表");
    ButtonGroup group1=new ButtonGroup();
    group1.add(ra1Button);
    group1.add(ra2Button);
    ra3Button=new JRadioButton(" 学  号",false);
    ra4Button=new JRadioButton(" 姓  名",true);
    ButtonGroup group2=new ButtonGroup();
    group2.add(ra3Button);
    group2.add(ra4Button);