addbaseinfo.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 AddBaseInfo extends JDialog{
    Statement ps;
    ResultSet rs;
    Connection con;
    String url;
    
    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 AddBaseInfo(Frame frame, String title, boolean modal) {
        super(frame, title, modal);
        try {
            jbInit();
            pack();
        }
        catch (Exception ex) {
            ex.printStackTrace();
        }
    }
    
    public AddBaseInfo() {
        this(null, "", true);
    }
    
    private void jbInit() throws Exception {
                       
        labSNum.setFont(new java.awt.Font("Dialog", 0, 15));
        labSNum.setText("学      号 ");
      
        labSName.setFont(new java.awt.Font("Dialog", 0, 15));
        labSName.setText("姓      名 ");
        
        labSBirth.setFont(new java.awt.Font("Dialog", 0, 15));
        labSBirth.setText("出生日期 ");
        
        labSState.setFont(new java.awt.Font("Dialog", 0, 15));
        labSState.setText("政治面貌 ");
        
        labSSex.setFont(new java.awt.Font("Dialog", 0, 15));
        labSSex.setText("性      别 ");
        
        labSDept.setFont(new java.awt.Font("Dialog", 0, 15));
        labSDept.setText("学      院 ");
        
        labSMaj.setFont(new java.awt.Font("Dialog", 0, 15));
        labSMaj.setText("专      业 ");
        
        labSClass.setFont(new java.awt.Font("Dialog", 0, 15));
        labSClass.setText("班      级 ");
        
        labSGadute.setFont(new java.awt.Font("Dialog", 0, 15));
        labSGadute.setText("毕业高中 ");
        
        labSHomeTown.setFont(new java.awt.Font("Dialog", 0, 15));
        labSHomeTown.setText("籍      贯 ");
        
        labSJob.setFont(new java.awt.Font("Dialog", 0, 15));
        labSJob.setText("职      务 ");
        
        labSMinzu.setFont(new java.awt.Font("Dialog", 0, 15));
        labSMinzu.setText("民      族 ");
        
        labSID.setFont(new java.awt.Font("Dialog", 0, 15));
        labSID.setText("身份证 ");
        
        labSComeTime.setFont(new java.awt.Font("Dialog", 0, 15));
        labSComeTime.setText("入学时间 ");
        
        labSAddress.setFont(new java.awt.Font("Dialog", 0, 15));
        labSAddress.setText("家庭住址 ");
        
        sure.setText("确定");
        sure.addActionListener(new addBaseInfo_sure_actionAdapter(this));
        cancel.setText("取消");
        cancel.addActionListener(new addBaseInfo_cancel_actionAdapter(this));
        panel.setBorder(BorderFactory.createLoweredBevelBorder());
        panel.setLayout(new GridBagLayout());
        LayoutUtil.add(panel,GridBagConstraints.NONE,GridBagConstraints.CENTER,0,0,0,0,1,1,labSNum);
        LayoutUtil.add(panel,GridBagConstraints.HORIZONTAL,GridBagConstraints.CENTER,1,0,1,0,1,1,txtSNum);
        LayoutUtil.add(panel,GridBagConstraints.NONE,GridBagConstraints.CENTER,0,0,2,0,1,1,labSName);
        LayoutUtil.add(panel,GridBagConstraints.HORIZONTAL,GridBagConstraints.CENTER,1,0,3,0,1,1,txtSName);
        
        LayoutUtil.add(panel,GridBagConstraints.NONE,GridBagConstraints.CENTER,0,0,0,1,1,1,labSDept);
        LayoutUtil.add(panel,GridBagConstraints.HORIZONTAL,GridBagConstraints.CENTER,1,0,1,1,1,1,txtSDept);
        LayoutUtil.add(panel,GridBagConstraints.NONE,GridBagConstraints.CENTER,0,0,2,1,1,1,labSBirth);
        LayoutUtil.add(panel,GridBagConstraints.HORIZONTAL,GridBagConstraints.CENTER,1,0,3,1,1,1,txtSBirth);
        
        LayoutUtil.add(panel,GridBagConstraints.NONE,GridBagConstraints.CENTER,0,0,0,2,1,1,labSState);
        LayoutUtil.add(panel,GridBagConstraints.HORIZONTAL,GridBagConstraints.CENTER,1,0,1,2,1,1,txtSState);
        LayoutUtil.add(panel,GridBagConstraints.NONE,GridBagConstraints.CENTER,0,0,2,2,1,1,labSHomeTown);
        LayoutUtil.add(panel,GridBagConstraints.HORIZONTAL,GridBagConstraints.CENTER,1,0,3,2,1,1,txtSHomeTown);
        
        LayoutUtil.add(panel,GridBagConstraints.NONE,GridBagConstraints.CENTER,0,0,0,3,1,1,labSSex);
        LayoutUtil.add(panel,GridBagConstraints.HORIZONTAL,GridBagConstraints.CENTER,1,0,1,3,1,1,txtSSex);
        LayoutUtil.add(panel,GridBagConstraints.NONE,GridBagConstraints.CENTER,0,0,2,3,1,1,labSMaj);
        LayoutUtil.add(panel,GridBagConstraints.HORIZONTAL,GridBagConstraints.CENTER,1,0,3,3,1,1,txtSMaj);
        
        LayoutUtil.add(panel,GridBagConstraints.NONE,GridBagConstraints.CENTER,0,0,0,4,1,1,labSClass);
        LayoutUtil.add(panel,GridBagConstraints.HORIZONTAL,GridBagConstraints.CENTER,1,0,1,4,1,1,txtSClass);
        LayoutUtil.add(panel,GridBagConstraints.NONE,GridBagConstraints.CENTER,0,0,2,4,1,1,labSJob);
        LayoutUtil.add(panel,GridBagConstraints.HORIZONTAL,GridBagConstraints.CENTER,1,0,3,4,1,1,txtSJob);
        
        LayoutUtil.add(panel,GridBagConstraints.NONE,GridBagConstraints.CENTER,0,0,0,5,1,1,labSMinzu);
        LayoutUtil.add(panel,GridBagConstraints.HORIZONTAL,GridBagConstraints.CENTER,1,0,1,5,1,1,txtSMinzu);
        LayoutUtil.add(panel,GridBagConstraints.NONE,GridBagConstraints.CENTER,0,0,2,5,1,1,labSComeTime);
        LayoutUtil.add(panel,GridBagConstraints.HORIZONTAL,GridBagConstraints.CENTER,1,0,3,5,1,1,txtSComeTime);
        
        LayoutUtil.add(panel,GridBagConstraints.NONE,GridBagConstraints.CENTER,0,0,0,6,1,1,labSID);
        LayoutUtil.add(panel,GridBagConstraints.HORIZONTAL,GridBagConstraints.CENTER,1,0,1,6,1,1,txtSID);
        LayoutUtil.add(panel,GridBagConstraints.NONE,GridBagConstraints.CENTER,0,0,2,6,1,1,labSGadute);
        LayoutUtil.add(panel,GridBagConstraints.HORIZONTAL,GridBagConstraints.CENTER,1,0,3,6,1,1,txtSGradute);
        
        LayoutUtil.add(panel,GridBagConstraints.NONE,GridBagConstraints.CENTER,0,0,0,7,1,1,labSAddress);
        LayoutUtil.add(panel,GridBagConstraints.HORIZONTAL,GridBagConstraints.CENTER,1,0,1,7,1,1,txtSAddress);
        
        panelb.setLayout(new GridBagLayout());
        LayoutUtil.add(panelb,GridBagConstraints.NONE,GridBagConstraints.CENTER,0,0,0,0,1,1,sure);
        LayoutUtil.add(panelb,GridBagConstraints.HORIZONTAL,GridBagConstraints.CENTER,0,0,1,0,1,1,cancel);
       
        this.getContentPane().add(panel,BorderLayout.CENTER);
        this.getContentPane().add(panelb,BorderLayout.SOUTH);
        this.setBounds(100, 100, 400, 300);
        this.setVisible(true);
    }
    void cancel_actionPerformed(ActionEvent e) {
        this.dispose();
    }
    void sure_actionPerformed(ActionEvent e) {
            JOptionPane.showConfirmDialog(null,"确定添加？", "添加基本信息", JOptionPane.YES_NO_OPTION);
            try {
                try {
                    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                    Connection con = DriverManager.getConnection("jdbc:odbc:学生档案","", "");
                    ps = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
                }
                catch (Exception err) {
                    String error = err.getMessage();
                    JOptionPane.showMessageDialog(null, "连接数据库错误!");
                }
                try {
                    String strSNum = "'"+txtSNum.getText().trim()+"'";
                    String strSName = "'"+txtSName.getText().trim()+"'";
                    String strSSex = "'"+txtSSex.getText().trim()+"'";
                    String strSClass = "'"+txtSClass.getText().trim()+"'";
                    String strSMaj = "'"+txtSMaj.getText().trim()+"'";
                    String strSDept = "'"+txtSDept.getText().trim()+"'";
                    String strSID = "'"+txtSID.getText().trim()+"'";
                    String strSBirth = "'"+txtSBirth.getText().trim()+"'";
                    String strSJob = "'"+txtSJob.getText().trim()+"'";
                    String strSComeTime = "'"+txtSComeTime.getText().trim()+"'";
                    String strSGradute = "'"+txtSGradute.getText().trim()+"'";
                    String strSAddress = "'"+txtSAddress.getText().trim()+"'";
                    String strSState = "'"+txtSState.getText().trim()+"'";
                    String strSMinzu = "'"+txtSMinzu.getText().trim()+"'";
                    String strSHomeTown = "'"+txtSHomeTown.getText().trim()+"'";
                    String sqlStr = "Insert Into 基本档案信息表 (学号,姓名,出生日期,政治面貌,民族,性别,学院,专业,班级,毕业高中,籍贯,职务,身份证,入学时间,家庭住址) " +
                                "values(" + strSNum + "," + strSName + "," + strSBirth+ "," + strSState+ "," +strSMinzu+ "," +strSSex+ "," +strSDept+ "," +strSMaj+ "," +strSClass+ "," +strSGradute+ "," +strSHomeTown+ "," +strSJob+ "," +strSID+ "," +strSComeTime+ "," +strSAddress +")";
                    ps.execute(sqlStr);                    
                    ps.close();                   
                    JOptionPane.showMessageDialog(null, "添加成功");
                    this.dispose();
                }
                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();
            }
        }
    }
//}
class addBaseInfo_cancel_actionAdapter
    implements java.awt.event.ActionListener {
    AddBaseInfo adaptee;

    addBaseInfo_cancel_actionAdapter(AddBaseInfo adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.cancel_actionPerformed(e);
    }
}

class addBaseInfo_sure_actionAdapter
    implements java.awt.event.ActionListener {
    AddBaseInfo adaptee;

    addBaseInfo_sure_actionAdapter(AddBaseInfo adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.sure_actionPerformed(e);
    }
}