changebaseinfo.java

学生档案管理系统

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package 学生档案管理系统;

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;

/**
 *
 * @author Administrator
 */
public class ChangeBaseInfo extends JDialog{
    Statement ps;
    ResultSet rs;
    Connection con;
    String url;
    String strName;
    String strNum;
    String strBirth; 
    String strState;
    String strSex;
    String strDept;
    String strMaj;
    String strClass;
    String strGradute;
    String strHomeTown;
    String strJob;
    String strMinzu;
    String strComeTime;
    String strAddress;
    String strID;
    
    JPanel panel = new JPanel();
    JPanel panelb = new JPanel();
    JLabel labSNum = new JLabel();
    JLabel labSName = new JLabel();
    JLabel labSBirth = new JLabel();
    JLabel labSState = new JLabel();
    JLabel labSSex = new JLabel();
    JLabel labSDept = new JLabel();
    JLabel labSMaj = new JLabel();
    JLabel labSClass = new JLabel();
    JLabel labSGadute = new JLabel();
    JLabel labSHomeTown = new JLabel();
    JLabel labSJob = new JLabel();
    JLabel labSMinzu = new JLabel();
    JLabel labSID = new JLabel();
    JLabel labSComeTime = new JLabel();
    JLabel labSAddress = new JLabel();
    
    JTextField txtSNum = new JTextField();
    JTextField txtSName = new JTextField();
    JTextField txtSBirth = new JTextField();
    JTextField txtSState = new JTextField();
    JTextField txtSSex = new JTextField();
    JTextField txtSDept = new JTextField();
    JTextField txtSMaj = new JTextField();
    JTextField txtSClass = new JTextField();
    JTextField txtSGradute = new JTextField();
    JTextField txtSHomeTown = new JTextField();
    JTextField txtSJob = new JTextField();
    JTextField txtSMinzu = new JTextField();
    JTextField txtSID = new JTextField();
    JTextField txtSComeTime = new JTextField();
    JTextField txtSAddress = new JTextField();
    
    JButton sure = new JButton();
    JButton cancel = new JButton();
    
    public ChangeBaseInfo(Frame frame, String title, boolean modal) {
        super(frame, title, modal);
        try {
            jbInit();
            pack();
        }
        catch (Exception ex) {
            ex.printStackTrace();
        }
    }
    
    public ChangeBaseInfo() {
        this(null, "", true);
    }  
    private void jbInit() throws Exception {
          try {
                try {
                    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                    Connection con = DriverManager.getConnection("jdbc:odbc:学生档案","", "");
                    ps = con.createStatement();
                }
                catch (Exception err) {
                    String error = err.getMessage();
                    JOptionPane.showMessageDialog(null, "连接数据库错误!");
                }
                try {
                    String strSNum = "'"+MainFrame.strSNum+"'";
                    String sqlStr = "Select * from 基本档案信息表 where 学号 ="+ strSNum;
                    rs = ps.executeQuery(sqlStr);  
                    while(rs.next()){
                        strNum = rs.getString(1);                        
                        strName = rs.getString(2);
                        strBirth = rs.getString(3);
                        strMinzu = rs.getString(12);
                        strDept = rs.getString(6);
                        strMaj = rs.getString(7);
                        strClass = rs.getString(8);
                        strJob = rs.getString(11);
                        strHomeTown = rs.getString(10);
                        strState = rs.getString(4);
                        strComeTime = rs.getString(14);
                        strSex = rs.getString(5);
                        strGradute = rs.getString(9);
                        strID = rs.getString(13);
                        strAddress  = rs.getString(15);
                    }
                    ps.close();
                }
                catch (SQLException sqle) {
                    String error = sqle.getMessage();
                    JOptionPane.showMessageDialog(null, error);
                    sqle.printStackTrace();
                }

            }
            catch (Exception ex) {
                ex.getMessage();
                String error = ex.getMessage();
                JOptionPane.showMessageDialog(null, error);
                ex.printStackTrace();
            }
                       
        labSNum.setFont(new java.awt.Font("Dialog", 0, 15));
        labSNum.setText("学      号 ");
        txtSNum.setText(strNum);
        
        labSName.setFont(new java.awt.Font("Dialog", 0, 15));
        labSName.setText("姓      名 ");
        txtSName.setText(strName);
        
        labSBirth.setFont(new java.awt.Font("Dialog", 0, 15));
        labSBirth.setText("出生日期 ");
        txtSBirth.setText(strBirth);
        
        labSState.setFont(new java.awt.Font("Dialog", 0, 15));
        labSState.setText("政治面貌 ");
        txtSState.setText(strState);
        
        labSSex.setFont(new java.awt.Font("Dialog", 0, 15));
        labSSex.setText("性      别 ");
        txtSSex.setText(strSex);
        
        labSDept.setFont(new java.awt.Font("Dialog", 0, 15));
        labSDept.setText("学      院 ");
        txtSDept.setText(strDept);
        
        labSMaj.setFont(new java.awt.Font("Dialog", 0, 15));
        labSMaj.setText("专      业 ");
        txtSMaj.setText(strMaj);
        
        labSClass.setFont(new java.awt.Font("Dialog", 0, 15));
        labSClass.setText("班      级 ");
        txtSClass.setText(strClass);
        
        labSGadute.setFont(new java.awt.Font("Dialog", 0, 15));
        labSGadute.setText("毕业高中 ");
        txtSGradute.setText(strGradute);