person_info.java~118~

一款高校科研管理系统

package scince;

import java.awt.*;
import java.sql.*;
import java.awt.event.*;
import java.awt.*;
import javax.swing.*;
import java.awt.Rectangle;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import com.borland.dx.dataset.TableDataSet;
import com.borland.dbswing.JdbTable;
import java.io.*;
import javax.swing.event.AncestorEvent;
import javax.swing.event.AncestorListener;
import java.awt.Dimension;
import java.awt.Font;

public class person_Info extends JFrame {
    public person_Info() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        jLabel1.setText("编码*");
        jLabel1.setBounds(new Rectangle(30, 16, 69, 27));
        getContentPane().setSize(500, 580);
        jButton1.addActionListener(new person_Info_jButton1_actionAdapter(this));
        jButton1.setBounds(new Rectangle(64, 387, 91, 37));
        jButton1.setText("查看");
        jLabel12.setText("津贴工资");
        jLabel12.setBounds(new Rectangle(297, 276, 65, 31));
        jLabel11.setText("岗位工资");
        jLabel11.setBounds(new Rectangle(300, 234, 57, 29));
        jLabel10.setText("基本工资");
        jLabel10.setBounds(new Rectangle(299, 170, 67, 45));
        jLabel9.setText("职称");
        jLabel9.setBounds(new Rectangle(301, 122, 62, 31));
        jLabel8.setText("参加工作时间");
        jLabel8.setBounds(new Rectangle(303, 70, 73, 43));
        jLabel7.setText("所在部门");
        jLabel7.setBounds(new Rectangle(303, 9, 72, 35));
        jLabel6.setText("文化程度");
        jLabel6.setBounds(new Rectangle(22, 269, 53, 30));
        jLabel5.setText("民族");
        jLabel5.setBounds(new Rectangle(22, 219, 45, 41));
        jLabel4.setText("出生年月日");
        jLabel4.setBounds(new Rectangle(22, 164, 65, 49));
        jLabel3.setText("性别");
        jLabel3.setBounds(new Rectangle(30, 109, 51, 29));
        jLabel2.setText("姓名");
        jLabel2.setBounds(new Rectangle(30, 57, 55, 32));
        jButton2.setBounds(new Rectangle(212, 384, 80, 40));
        jButton2.setText("删除");
        jButton2.addActionListener(new person_Info_jButton2_actionAdapter(this));
        jButton3.setBounds(new Rectangle(340, 387, 88, 37));
        jButton3.setText("添加");
        jButton3.addActionListener(new person_Info_jButton3_actionAdapter(this));
        jLabel13.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        jLabel13.setText("在上面的对话框中任意输入查找");
        jLabel13.setBounds(new Rectangle(89, 318, 242, 55));
        jLabel14.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel14.setText("带*  必须输");
        jLabel14.setBounds(new Rectangle(342, 352, 100, 28));
        this.getContentPane().add(jLabel1, null);

        jTextField7.setBounds(new Rectangle(385, 12, 91, 28));
        jTextField1.setBounds(new Rectangle(99, 19, 73, 23));
        jTextField2.setBounds(new Rectangle(87, 67, 92, 24));
        jTextField8.setBounds(new Rectangle(387, 68, 87, 37));
        jTextField3.setBounds(new Rectangle(87, 111, 92, 25));
        jTextField9.setBounds(new Rectangle(388, 123, 78, 31));
        jTextField4.setBounds(new Rectangle(94, 164, 85, 31));
        jTextField10.setBounds(new Rectangle(376, 180, 95, 34));
        jTextField5.setBounds(new Rectangle(99, 224, 80, 31));
        jTextField11.setBounds(new Rectangle(376, 232, 97, 34));
        jTextField6.setBounds(new Rectangle(93, 270, 86, 32));
        jTextField12.setBounds(new Rectangle(376, 287, 102, 25));
        this.getContentPane().add(jLabel2, null);
        this.getContentPane().add(jLabel3, null);
        this.getContentPane().add(jLabel4, null);
        this.getContentPane().add(jLabel5, null);
        this.getContentPane().add(jLabel6, null);
        this.getContentPane().add(jLabel7, null);
        this.getContentPane().add(jLabel8, null);
        this.getContentPane().add(jLabel9, null);
        this.getContentPane().add(jLabel10, null);
        this.getContentPane().add(jLabel11, null);
        this.getContentPane().add(jLabel12, null);
        this.getContentPane().add(jTextField1, null);
        this.getContentPane().add(jTextField2, null);
        this.getContentPane().add(jTextField3, null);
        this.getContentPane().add(jTextField4, null);
        this.getContentPane().add(jTextField5, null);
        this.getContentPane().add(jTextField6, null);
        this.getContentPane().add(jTextField7, null);
        this.getContentPane().add(jTextField8, null);
        this.getContentPane().add(jTextField9, null);
        this.getContentPane().add(jTextField10, null);
        this.getContentPane().add(jTextField11, null);
        this.getContentPane().add(jTextField12, null);
        this.getContentPane().add(jButton1, null);
        this.getContentPane().add(jLabel13);
        this.getContentPane().add(jButton3);
        this.getContentPane().add(jButton2);
        this.getContentPane().add(jLabel14);
    }

    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JLabel jLabel6 = new JLabel();
    JLabel jLabel7 = new JLabel();
    JLabel jLabel8 = new JLabel();
    JLabel jLabel9 = new JLabel();
    JLabel jLabel10 = new JLabel();
    JLabel jLabel11 = new JLabel();
    JLabel jLabel12 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JTextField jTextField2 = new JTextField();
    JTextField jTextField3 = new JTextField();
    JTextField jTextField4 = new JTextField();
    JTextField jTextField5 = new JTextField();
    JTextField jTextField6 = new JTextField();
    JTextField jTextField7 = new JTextField();
    JTextField jTextField8 = new JTextField();
    JTextField jTextField9 = new JTextField();
    JTextField jTextField10 = new JTextField();
    JTextField jTextField11 = new JTextField();
    JTextField jTextField12 = new JTextField();
    JButton jButton1 = new JButton();
    private String sqlString;
    private Connection con;
    private Statement query;
    private ResultSet rs;
    JButton jButton2 = new JButton();
    JButton jButton3 = new JButton();
    JLabel jLabel13 = new JLabel();
    JLabel jLabel14 = new JLabel();
    public void jButton1_actionPerformed(ActionEvent e) {
        Connection con;
        Statement sql;
        ResultSet rs;
        String queryString;
        if(jTextField1.getText()!=null)
        queryString ="select * from 人员信息 where 编号=" +Integer.parseInt(jTextField1.getText());
        else queryString="";
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        } catch (java.lang.ClassNotFoundException ee) {
            System.err.print("class not find!");
            System.err.println(ee.getMessage());
        }


        try {
            con = DriverManager.getConnection("jdbc:odbc:scince", "", "");
            sql = con.createStatement();
            rs=sql.executeQuery(queryString);
            if(rs.next()){
                jTextField1.setText(Integer.toString(rs.getInt(1)));
                jTextField2.setText(rs.getString(2));
                jTextField3.setText(rs.getString(3));
                jTextField4.setText(rs.getString(4));
                jTextField5.setText(rs.getString(5));
                jTextField6.setText(rs.getString(6));
                jTextField7.setText(rs.getString(7));
                jTextField8.setText(rs.getString(8));
                jTextField9.setText(rs.getString(9));
                jTextField10.setText(Integer.toString(rs.getInt(10)));
                jTextField11.setText(Integer.toString(rs.getInt(11)));
                jTextField12.setText(Integer.toString(rs.getInt(12)));
            }
            else ;
            con.close();
        } catch (SQLException ex) {}


    }

    public void jButton2_actionPerformed(ActionEvent e) {
               Connection con;
                Statement sql;
                String queryString;
                if(jTextField1.getText()!=null)
                queryString ="DELETE from 人员信息 where 编号=" +Integer.parseInt(jTextField1.getText());
                else queryString="";
                try {
                    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                } catch (java.lang.ClassNotFoundException ee) {
                    System.err.print("class not find!");
                    System.err.println(ee.getMessage());
        }
        try {
           con = DriverManager.getConnection("jdbc:odbc:scince", "", "");
           sql = con.createStatement();
           sql.executeUpdate(queryString);
           //con.close();
       } catch (SQLException ex) {}

    }

    public void jButton3_actionPerformed(ActionEvent e) {
                          Connection con;
                        Statement sql;
                        String queryString;
queryString ="INSERT INTO 人员信息 values("+Integer.parseInt(jTextField1.getText())+","+jTextField2.getText()+","+jTextField3.getText()+","+jTextField4.getText()+","+jTextField5.getText()+","+jTextField6.getText()+","+jTextField7.getText()+", "+jTextField8.getText()+","+jTextField9.getText()+","+Integer.parseInt(jTextField10.getText())+","+Integer.parseInt(jTextField11.getText())+","+Integer.parseInt(jTextField12.getText())+")";
                        try {
                            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                        } catch (java.lang.ClassNotFoundException ee) {
                            System.err.print("class not find!");
                            System.err.println(ee.getMessage());
                }
                try {
                   con = DriverManager.getConnection("jdbc:odbc:scince", "", "");
                   sql = con.createStatement();
                   sql.executeUpdate(queryString);
                   //con.close();
       } catch (SQLException ex) {}
    }


    class person_Info_jButton1_actionAdapter implements ActionListener {
        private person_Info adaptee;
        person_Info_jButton1_actionAdapter(person_Info adaptee) {
            this.adaptee = adaptee;
        }

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


}


class person_Info_jButton2_actionAdapter implements ActionListener {
    private person_Info adaptee;
    person_Info_jButton2_actionAdapter(person_Info adaptee) {
        this.adaptee = adaptee;
    }

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


class person_Info_jButton3_actionAdapter implements ActionListener {
    private person_Info adaptee;
    person_Info_jButton3_actionAdapter(person_Info adaptee) {
        this.adaptee = adaptee;
    }

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