myjframe.java

是java与sql2000编写的学生学籍管理系统,利用java工具NetBeans5.5.1设计界面

                    .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                        .addComponent(jLabel1)
                        .addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 48, javax.swing.GroupLayout.PREFERRED_SIZE)))
                .addGap(23, 23, 23)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(layout.createSequentialGroup()
                        .addComponent(B2)
                        .addGap(24, 24, 24)
                        .addComponent(B3)
                        .addGap(201, 201, 201))
                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                            .addComponent(mima, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 118, Short.MAX_VALUE)
                            .addComponent(yonghu, javax.swing.GroupLayout.DEFAULT_SIZE, 118, Short.MAX_VALUE))
                        .addGap(245, 245, 245)))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(71, 71, 71))
            .addGroup(layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 698, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap())
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addGap(16, 16, 16)
                .addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 482, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(layout.createSequentialGroup()
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabel1)
                            .addComponent(yonghu, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                        .addGap(20, 20, 20)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabel2)
                            .addComponent(mima, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                        .addGap(20, 20, 20)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(B1)
                            .addComponent(B2)
                            .addComponent(B3)))
                    .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(21, 21, 21))
        );
        pack();
    }// </editor-fold>//GEN-END:initComponents

    private void B11ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_B11ActionPerformed
// 学生学籍修改
          if(jTextField9.getText().equals("")||jTextField10.getText().equals("")||jTextField11.getText().equals("")||jTextField12.getText().equals("")||jTextField13.getText().equals("")||jTextField14.getText().equals("")||jTextField15.getText().equals(""))
         JOptionPane.showMessageDialog(null,"输入完整后，再点修改！","错误信息",1);
     else{
               if(jTextField9.getText().length()!=8||jTextField9.getText().charAt(0)!='0'
               ||jTextField9.getText().charAt(1)<'4'||jTextField9.getText().charAt(1)>'7'||jTextField9.getText().charAt(2)!='1'
               ||jTextField9.getText().charAt(3)<'3'||jTextField9.getText().charAt(3)>'5'
               ||jTextField9.getText().charAt(4)!='8'||jTextField9.getText().charAt(5)<'0'
               ||jTextField9.getText().charAt(5)>'9'||jTextField9.getText().charAt(6)<'0'||jTextField9.getText().charAt(6)>'9')
                JOptionPane.showMessageDialog(null,"学号输入有误，请重新输入！","错误信息",1);    
        else{
          int op=JOptionPane.showConfirmDialog(null,"确定要修改吗","提示",0);
        if(op==0)
        {
              try {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    } catch (ClassNotFoundException ce) {
        System.out.println(ce);
    } try {
      String url = "jdbc:odbc:XSXJGLXT";
      Connection con = DriverManager.getConnection(url);
      Statement s = con.createStatement();
      String sno=jTextField9.getText();
      String sname=jTextField10.getText();
      String chushengriqi=jTextField11.getText();
      String xingbie= jTextField12.getText(); 
      String minzu=jTextField13.getText();
      String dianhua=jTextField14.getText();
      String jiatingzhuzhi=jTextField15.getText();
       int m=s.executeUpdate("update KC1 set 姓名='"+sname+
               "',出生日期='"+chushengriqi+"',性别='"+xingbie+"',民族='"+minzu
               +"',电话='"+dianhua+ "',家庭住址='"+jiatingzhuzhi+"' where 学号='"+sno+"'");
      if(m==1)  JOptionPane.showMessageDialog(null, "修改成功", "提示", JOptionPane.INFORMATION_MESSAGE);
       else  JOptionPane.showMessageDialog(null, "修改失败", "提示", JOptionPane.INFORMATION_MESSAGE); 
        jTextField9.setText("");
        jTextField10.setText("");
        jTextField11.setText("");
        jTextField12.setText("");
        jTextField13.setText("");
        jTextField14.setText("");
        jTextField15.setText("");
       s.close();
      con.close();
    } catch (SQLException ce) {
        JOptionPane.showMessageDialog(null, "修改失败!/n "+ce, "提示", JOptionPane.INFORMATION_MESSAGE); 
    }
        }
        else
            JB3.setVisible(true);
      }                  
    }
    }//GEN-LAST:event_B11ActionPerformed

    private void B13ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_B13ActionPerformed
// 学生学籍的添加
        if(jTextField9.getText().equals("")||jTextField10.getText().equals("")||jTextField11.getText().equals("")||jTextField12.getText().equals("")||jTextField13.getText().equals("")||jTextField14.getText().equals("")||jTextField15.getText().equals(""))
         JOptionPane.showMessageDialog(null,"请检查是否输入完整！", "提示", JOptionPane.INFORMATION_MESSAGE);
     else{
               if(jTextField9.getText().length()!=8||jTextField9.getText().charAt(0)!='0'
               ||jTextField9.getText().charAt(1)<'4'||jTextField9.getText().charAt(1)>'7'||jTextField9.getText().charAt(2)!='1'
               ||jTextField9.getText().charAt(3)<'3'||jTextField9.getText().charAt(3)>'5'
               ||jTextField9.getText().charAt(4)!='8'||jTextField9.getText().charAt(5)<'0'
               ||jTextField9.getText().charAt(5)>'9'||jTextField9.getText().charAt(6)<'0'||jTextField9.getText().charAt(6)>'9')
                JOptionPane.showMessageDialog(null,"学号输入有误，请重新输入！","错误信息",1);               
                else{
                   try {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    } catch (ClassNotFoundException ce) {
        System.out.println(ce);
    } try {
      String url = "jdbc:odbc:XSXJGLXT";
      Connection con = DriverManager.getConnection(url);
      Statement s = con.createStatement();
      int m=s.executeUpdate("insert into KC1"+ 
             " values('"+jTextField9.getText()+"','"+jTextField10.getText()+"','"+
              jTextField12.getText()+"','"+jTextField13.getText()+"','"+
             jTextField11.getText()+"','" +jTextField14.getText()+"','"+jTextField15.getText()+
             "')");      
      if(m==1)
        JOptionPane.showMessageDialog(null, "添加成功", "提示", JOptionPane.INFORMATION_MESSAGE);
        jTextField9.setText("");
        jTextField10.setText("");
        jTextField11.setText("");
        jTextField12.setText("");
        jTextField13.setText("");
        jTextField14.setText("");
        jTextField15.setText("");
        s.close();
        con.close();
    } catch (SQLException ce) {     
         JOptionPane.showMessageDialog(null,"添加失败！\n"+ce, "提示", JOptionPane.INFORMATION_MESSAGE);        
    }
                }
     }
    }//GEN-LAST:event_B13ActionPerformed

    private void B14ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_B14ActionPerformed
if(evt.getActionCommand()=="返回")
{ dispose();
  System.exit(0);
}
    }//GEN-LAST:event_B14ActionPerformed

    private void B12ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_B12ActionPerformed
//学生学籍的删除
          try {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    } catch (ClassNotFoundException ce) {
        System.out.println(ce);
    } try {
      String url = "jdbc:odbc:XSXJGLXT";
      Connection con = DriverManager.getConnection(url);
      Statement s = con.createStatement();
        String xuehao=jTextField1.getText();
        int m= s.executeUpdate("delete from  KC1 where 学号='"+xuehao+"'");
       if(m==1)
        JOptionPane.showMessageDialog(null, "删除成功！", "提示", JOptionPane.INFORMATION_MESSAGE);
      else
          JOptionPane.showMessageDialog(null, "删除失败！数据库中不存在该数据！\n", "提示", JOptionPane.INFORMATION_MESSAGE);
       s.close();
    } catch (SQLException ce) {
        System.out.println(ce);
    } 
    }//GEN-LAST:event_B12ActionPerformed

    private void B1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_B1ActionPerformed
try {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    } catch (ClassNotFoundException ce) {
        System.out.println(ce);
    } try {
      String url = "jdbc:odbc:XSXJGLXT";
      Connection con = DriverManager.getConnection(url);
      Statement s = con.createStatement();
        String xuehao=yonghu.getText();
      ResultSet rs = s.executeQuery("select * from KC3 where yonghu='"+xuehao+"'");
     if(rs.next())
      { if(xuehao.equals(rs.getString(1))&& String.valueOf(mima.getPassword()).equals(rs.getString(2)))
            {  
            this.setVisible(false);
                JB3.setVisible(true);
                JB3.setSize(900,600);
               }
       }   
    } catch (SQLException ce) {
        System.out.println(ce);
    }
    
    
    }//GEN-LAST:event_B1ActionPerformed

    private void B9ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_B9ActionPerformed
// 学生成绩添加
         if(jTextField2.getText().equals("")||jTextField6.getText().equals("")||jTextField5.getText().equals("")||jTextField7.getText().equals("")||jTextField8.getText().equals(""))
         JOptionPane.showMessageDialog(null,"请检查是否输入完整！", "提示", JOptionPane.INFORMATION_MESSAGE);
            else{
               if(jTextField2.getText().length()!=8||jTextField2.getText().charAt(0)!='0'
               ||jTextField2.getText().charAt(1)<'4'||jTextField2.getText().charAt(1)>'7'||jTextField2.getText().charAt(2)!='1'
               ||jTextField2.getText().charAt(3)<'3'||jTextField2.getText().charAt(3)>'5'
               ||jTextField2.getText().charAt(4)!='8')
                JOptionPane.showMessageDialog(null,"学号输入有误，请重新输入！","错误信息",1);        
                else{
                   try {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    } catch (ClassNotFoundException ce) {
        System.out.println(ce);
    } try {
      String url = "jdbc:odbc:XSXJGLXT";
      Connection con = DriverManager.getConnection(url);
      Statement s = con.createStatement();
      int m=s.executeUpdate("insert into KC2"+ 
             " values('"+jTextField2.getText()+"','"+jTextField5.getText()+"','"+
              jTextField6.getText()+"','"+jTextField7.getText()+"',"+
             jTextField8.getText()+")");      
      if(m==1)
        JOptionPane.showMessageDialog(null, "添加成功", "提示", JOptionPane.INFORMATION_MESSAGE);
        jTextField2.setText("");
        jTextField6.setText("");
        jTextField5.setText("");
        jTextField7.setText("");
        jTextField8.setText("");
        s.close();
        con.close();
    } catch (SQLException ce) {     
         JOptionPane.showMessageDialog(null,"添加失败！\n"+ce, "提示", JOptionPane.INFORMATION_MESSAGE);        
    }
                }
     }
    }//GEN-LAST:event_B9ActionPerformed

    private void B4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_B4ActionPerformed
// 用户注册
        if(jTextField3.getText().equals("")||String.valueOf(jPasswordField1.getPassword()).equals("")||String.valueOf(jPasswordField2.getPassword()).equals(""))
         JOptionPane.showMessageDialog(null,"请检查是否输入完整！", "提示", JOptionPane.INFORMATION_MESSAGE);
     else{
              
             if(!(String.valueOf(jPasswordField1.getPassword()).equals(String.valueOf(jPasswordField2.getPassword()))))
                    JOptionPane.showMessageDialog(null,"前后输入密码不一致！", "提示", JOptionPane.INFORMATION_MESSAGE);
                else{
                   try {