JMenu helpMenu=new   JMenu("帮助");
         menubar.add(helpMenu);
         //给窗体设置主菜单
         this.setJMenuBar(menubar);
         JToolBar toolBar=new JToolBar();
         bNew=new JButton("添加");
         //给添加按钮绑定监听
         this.bNew.addActionListener(this);
         toolBar.add(bNew);
         bUpdate=new JButton("修改");
         this.bUpdate.addActionListener(this);
         toolBar.add(bUpdate);
         toolBar.addSeparator();
         bDelete=new JButton("删除");
         //给删除按钮绑定监听
         this.bDelete.addActionListener(this);
         toolBar.add(bDelete);
         //添加工具栏
         pnlMain.add(BorderLayout.NORTH,toolBar);
        
         table = new JTable();
         setTableData();
        
       
          JScrollPane scroll=new JScrollPane(table);
         pnlMain.add(BorderLayout.CENTER,scroll);
         return pnlMain;
     }
    
         public static void setTableData() {
             Vector data =new Vector();
             Vector lieming =new Vector();
              //构造一个数据库语句
             String sql="select * from student";
              
               ResultSet rs=null;
               //1 添加注册驱动；
               try {
                    


                      rs=DB.executeQuery(sql);
                     
                      while(rs.next()){
                          Vector rowData=new Vector();
                          rowData.add(rs.getString("id"));
                          rowData.add(rs.getString("name"));
                          rowData.add(rs.getString("gender"));
                          rowData.add(rs.getString("class"));
                          rowData.add(rs.getString("chinese"));
                          rowData.add(rs.getString("math"));
                          rowData.add(rs.getString("english"));
                          rowData.add(rs.getString("lizong"));
                          data.add(rowData);
                      }
                     
                 } catch (Exception e1) {
                     e1.printStackTrace();
                 }finally{
                     try {


                         rs.close();
                         DB.closeConnection();
                     } catch (SQLException e) {
                         // TODO Auto-generated catch block
                         e.printStackTrace();
                     }
                    
                 }
                 lieming.add("编号");
                 lieming.add("姓名");
                 lieming.add("性别");
                 lieming.add("班级");
                 lieming.add("语文");
                 lieming.add("数学");
                 lieming.add("英语");
                 lieming.add("理综合");
                 DefaultTableModel model=new DefaultTableModel(data,lieming);
                 table.setModel(model);
         }
        
     private void delete(){
         //获取选中的行
         int row=this.table.getSelectedRow();
         if(row==-1){
             JOptionPane.showMessageDialog(this, "没有选中任何一行");
             return;
         }else{


             //获取主键
             String id=this.table.getValueAt(row, 0).toString();
             //构造删除语句并执行到数据库
             String sql="delete from student where id ="+id+"";
            
            
    
          Statement st =null;
          Connection conn=null;
          //1 添加注册驱动
          try {
             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
              //2 创建管道
           conn=DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)}; DBQ=db.mdb");
           //3 创建执行命令的载体
           st=conn.createStatement();
           //4 让载体把sql增加命令送到数据库中
           st.executeUpdate(sql);
         } catch (Exception e1) {
             e1.printStackTrace();
         }
        
    
         finally{
             //无论正常与否，都必须执行
             try {
                 st.close();
                 conn.close();//关闭连接
             } catch (SQLException e1) {
                 // TODO Auto-generated catch block
                 e1.printStackTrace();
             }
         }
             //关闭载体
        


        
         DefaultTableModel dtm = (DefaultTableModel)this.table.getModel();
         System.out.println(row);
         dtm.removeRow(row);
         }
         }
        
     public static void main(String[] args) {
         new Guanli();
     }
     //
     private void update(){
        
      int row = this.table.getSelectedRow();
      if(row==-1){
          JOptionPane.showMessageDialog(this, "没有选中任何一行！");
          return;
      }else{
          //获取主键
          String id =this.table.getValueAt(row, 0).toString();
          String xingming =this.table.getValueAt(row, 1).toString();
          String xingbie =this.table.getValueAt(row, 2).toString();
          String banji =this.table.getValueAt(row, 3).toString();
          String yuwen =this.table.getValueAt(row, 4).toString();
          String shuxue =this.table.getValueAt(row, 5).toString();
          String yingyu =this.table.getValueAt(row, 6).toString();
          String lizonghe=this.table.getValueAt(row, 7).toString();
          Zhuce.id=id;
          Zhuce.xingming=xingming;
          Zhuce.xingbie=xingbie;
          Zhuce.banji=banji;
          Zhuce.yuwen=yuwen;
          Zhuce.shuxue=shuxue;
          Zhuce.yingyu=yingyu;
          Zhuce.lizonghe=lizonghe;
          System.out.println("hello");
          Zhuce Zhuce= new Zhuce();
          Zhuce.setContent();
      }
     }
        
//二.系统自动生成，具体实现接口的方法
     public void actionPerformed(ActionEvent e) {
         // TODO Auto-generated method stub
         Object obj =e.getSource();//object
         if(obj==this.bNew||obj==itemNew){
             Zhuce.id="";
             new Zhuce();
             this.setVisible(false);
         }
         if(obj==this.bDelete||obj==itemDelete){
             this.delete();
         }
         if(obj==this.bUpdate){
             this.update();
         }
     }
         }