user.java

一个学校当中的教务管理系统

        jMenu1.add(jMenuItem2);

        jMenuItem3.setText("\u9009\u4fee\u8bfe");
        jMenu1.add(jMenuItem3);

        jMenuItem4.setText("\u67e5\u8be2\u6210\u7ee9");
        jMenu1.add(jMenuItem4);

        jMenuBar1.add(jMenu1);

        jMenu2.setText("\u7f16\u8f91\u4fee\u6539");
        jMenuItem5.setText("\u4fee\u6539\u4e2a\u4eba\u4fe1\u606f");
        jMenuItem5.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jMenuItem5ActionPerformed(evt);
            }
        });

        jMenu2.add(jMenuItem5);

        jMenu3.setText("\u9009\u4fee\u8bfe");
        jMenuItem8.setText("\u9009\u8bfe");
        jMenu3.add(jMenuItem8);

        jMenuItem9.setText("\u5220\u9664\u9009\u8bfe");
        jMenu3.add(jMenuItem9);

        jMenu2.add(jMenu3);

        jMenu4.setText("\u6dfb\u52a0");
        jMenuItem10.setText("\u5b66\u751f");
        jMenuItem10.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jMenuItem10ActionPerformed(evt);
            }
        });

        jMenu4.add(jMenuItem10);

        jMenuItem11.setText("\u6559\u5e08");
        jMenu4.add(jMenuItem11);

        jMenu2.add(jMenu4);

        jMenu5.setText("\u5220\u9664");
        jMenuItem12.setText("\u5b66\u751f");
        jMenu5.add(jMenuItem12);

        jMenuItem13.setText("\u6559\u5e08");
        jMenu5.add(jMenuItem13);

        jMenu2.add(jMenu5);

        jMenuBar1.add(jMenu2);

        setJMenuBar(jMenuBar1);

        pack();
    }// </editor-fold>//GEN-END:initComponents

    private void jMenuItem10ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem10ActionPerformed
// TODO 将在此处添加您的处理代码：
       edit addstu=new edit();
       addstu.setVisible(true);
      // String sqladd="insert into sinfo (sid,sname,psd) values('20001340000000','我','1')";
       //String sqladd="insert into sinfo values('2000134111111','nu','20001340000000','男',2000,'13','01','13','340104710429200','7','1');";
       // String sqladd=addstu.aa();
       
        isQuery=false;
     //  System.out.println (sqladd); 
      // dboperater(sqladd);
    
       // this.setEnabled(false);
     //   String b=addstu.jButton1ActionPerformed(java.awt.event.ActionEvent evt);
       // System.out.println (addstu.sqladd); 
        
       
       
    }//GEN-LAST:event_jMenuItem10ActionPerformed

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
// TODO 将在此处添加您的处理代码：
    String a= jTextField1.getText();
    int qq=0;
     isQuery=true;
     isquery=true;
   /*dboperater("select * from sinfo where sno='"+a+"'or sname='"+a+"'");
      System.out.println("rows.length"+Rows.length);
     for( int q=0;q<Rows.length;q++)
      {
        qq=Rows[q].indexOf(a);
         
      }
     System.out.println("at"+qq);
     jTable1.setRowSelectionAllowed(true);
                  jTable1.setRowSelectionInterval(qq,qq);
                  jTable1.setSelectionBackground(Color.ORANGE);*/
     try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            String url="jdbc:odbc:教务";
            Connection con=DriverManager.getConnection(url,"","");            
            Statement stmt=con.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);       
            ResultSet rs=stmt.executeQuery("select * from sinfo");                   
            ResultSetMetaData rsmd=rs.getMetaData();
            int cols= rsmd.getColumnCount();//得到列数
            aRow=new String[cols];//表头数组
            Rows=new String[cols];//表的内容数组
            boolean more=rs.next();          
            int r=0;//行数   
            int i=0;//列数
            for(i=0;i<cols;i++)
                   aRow[i]=rsmd.getColumnName(i+1);  //得到表头             
            do{                               
                more=rs.next();      
                r++;
            }while(more);//得到行数
            System.out.println(r);        
            rs.beforeFirst();
            int ww=0;
                 while(rs.next()){                
                 for(i=1;i<=cols;i++){                    
                    if(a.equals(rs.getString(i))) {
                    qq=ww;                    
                    }  
                    
                     } 
                  ww++;
                 } 
            System.out.println("at"+qq);
           jTable1.setRowSelectionAllowed(true);
                  jTable1.setRowSelectionInterval(qq,qq);
             //    ListSelectionModel lsm=new ListSelectionModel(); 
                 
                  jTable1.setSelectionBackground(Color.ORANGE);
            record_jL.setText("有关记录为"+r+"条");   }              
           catch (SQLException ex) {
              System.out.println(ex.getErrorCode());
            ex.printStackTrace();
          }  catch (ClassNotFoundException ex) {
            ex.printStackTrace();
          }
     
    }//GEN-LAST:event_jButton1ActionPerformed

    private void jMenuItem5ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem5ActionPerformed
         
    }//GEN-LAST:event_jMenuItem5ActionPerformed

    private void jMenuItem1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem1ActionPerformed
// TODO 将在此处添加您的处理代码：
         isQuery=true;
 // dboperater("select * from sinfo where sno='"+ID+"'");
    dboperater("select * from sinfo");
    }//GEN-LAST:event_jMenuItem1ActionPerformed
  
    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new user().setVisible(true);
            }
        });
    }
    
    // 变量声明 - 不进行修改//GEN-BEGIN:variables
    private javax.swing.JButton jButton1;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JMenu jMenu1;
    private javax.swing.JMenu jMenu2;
    private javax.swing.JMenu jMenu3;
    private javax.swing.JMenu jMenu4;
    private javax.swing.JMenu jMenu5;
    private javax.swing.JMenuBar jMenuBar1;
    private javax.swing.JMenuItem jMenuItem1;
    private javax.swing.JMenuItem jMenuItem10;
    private javax.swing.JMenuItem jMenuItem11;
    private javax.swing.JMenuItem jMenuItem12;
    private javax.swing.JMenuItem jMenuItem13;
    private javax.swing.JMenuItem jMenuItem2;
    private javax.swing.JMenuItem jMenuItem3;
    private javax.swing.JMenuItem jMenuItem4;
    private javax.swing.JMenuItem jMenuItem5;
    private javax.swing.JMenuItem jMenuItem8;
    private javax.swing.JMenuItem jMenuItem9;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JTable jTable1;
    private javax.swing.JTextField jTextField1;
    private javax.swing.JLabel record_jL;
    // 变量声明结束//GEN-END:variables

}