person_info.java~70~

一款高校科研管理系统

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.*;
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, 15, 69, 27));
        getContentPane().setSize(305, 580);
        jButton1.addActionListener(new person_Info_jButton1_actionAdapter(this));
        jTable1.setForeground(Color.red);
        jTable1.setToolTipText("");
        jTable1.setSelectionForeground(Color.red);
        jScrollPane1.setBounds(new Rectangle(242, 370, 749, 324));
        this.getContentPane().add(jLabel1);
        jButton1.setBounds(new Rectangle(62, 305, 91, 37));
        jButton1.setText("查看");
        jTextField12.setBounds(new Rectangle(366, 270, 111, 25));
        jTextField11.setBounds(new Rectangle(373, 220, 99, 34));
        jTextField10.setBounds(new Rectangle(375, 172, 95, 34));
        jTextField9.setBounds(new Rectangle(382, 121, 83, 31));
        jTextField8.setBounds(new Rectangle(381, 66, 92, 37));
        jTextField7.setBounds(new Rectangle(379, 12, 96, 28));
        jTextField6.setBounds(new Rectangle(91, 252, 83, 32));
        jTextField5.setBounds(new Rectangle(98, 207, 73, 31));
        jTextField4.setBounds(new Rectangle(92, 150, 79, 31));
        jTextField3.setBounds(new Rectangle(87, 104, 83, 25));
        jTextField2.setBounds(new Rectangle(86, 65, 84, 24));
        jTextField1.setBounds(new Rectangle(95, 18, 72, 23));
        jLabel12.setText("津贴工资");
        jLabel12.setBounds(new Rectangle(292, 259, 65, 31));
        jLabel11.setText("岗位工资");
        jLabel11.setBounds(new Rectangle(295, 218, 57, 29));
        jLabel10.setText("基本工资");
        jLabel10.setBounds(new Rectangle(294, 164, 67, 45));
        jLabel9.setText("职称");
        jLabel9.setBounds(new Rectangle(296, 120, 62, 31));
        jLabel8.setText("参加工作时间");
        jLabel8.setBounds(new Rectangle(298, 68, 73, 43));
        jLabel7.setText("所在部门");
        jLabel7.setBounds(new Rectangle(298, 9, 72, 35));
        jLabel6.setText("文化程度");
        jLabel6.setBounds(new Rectangle(22, 249, 53, 30));
        jLabel5.setText("民族");
        jLabel5.setBounds(new Rectangle(23, 197, 45, 41));
        jLabel4.setText("出生年月日");
        jLabel4.setBounds(new Rectangle(24, 145, 65, 49));
        jLabel3.setText("性别");
        jLabel3.setBounds(new Rectangle(30, 100, 51, 29));
        this.getContentPane().add(jLabel2);
        this.getContentPane().add(jLabel3);
        this.getContentPane().add(jLabel4);
        this.getContentPane().add(jLabel5);
        this.getContentPane().add(jLabel6);
        this.getContentPane().add(jLabel7);
        this.getContentPane().add(jLabel8);
        this.getContentPane().add(jLabel9);
        this.getContentPane().add(jLabel10);
        this.getContentPane().add(jLabel11);
        this.getContentPane().add(jLabel12);
        this.getContentPane().add(jTextField1);
        this.getContentPane().add(jTextField2);
        this.getContentPane().add(jTextField3);
        this.getContentPane().add(jTextField4);
        this.getContentPane().add(jTextField5);
        this.getContentPane().add(jTextField6);
        this.getContentPane().add(jTextField7);
        this.getContentPane().add(jTextField8);
        this.getContentPane().add(jTextField9);
        this.getContentPane().add(jTextField10);
        this.getContentPane().add(jTextField11);
        this.getContentPane().add(jTextField12);
        this.getContentPane().add(jButton1);
        this.getContentPane().add(jScrollPane1);
        jScrollPane1.getViewport().add(jTable1);
        jLabel2.setText("姓名");
        jLabel2.setBounds(new Rectangle(30, 55, 55, 32));

    }

    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;
    JTable jTable1 = new JTable();
    JScrollPane jScrollPane1 = new JScrollPane();
    public void jButton1_actionPerformed(ActionEvent e) {
        Connection con;
        Statement sql;
        ResultSet rs;
        Object a[][];
        Object columnName[]={"编码","姓名","性别","出生年月日","民族","文化程度","所在部门","参加工作时间","职称","基本工资","岗位工资","津贴工资"};
        a =new Object[60][4];
        jTable1 =new JTable (a,columnName);
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        } catch (java.lang.ClassNotFoundException ee) {
            System.err.print("class not find!");
            System.err.println(ee.getMessage());
        }
        int i=0;
        while(i>0){
            a[i][0]="";
            a[i][1]="";
            a[i][2]="";
            a[i][3]="";
            a[i][4]="";
            a[i][5]="";
            a[i][6]="";
            a[i][7]="";
            a[i][8]="";
            a[i][9]="";
            a[i][10]="";
            a[i][11]="";
             i--;
            }
          i=0;

        try {
            con = DriverManager.getConnection("jdbc:odbc:scince", "", "");
            sql = con.createStatement();
            rs = sql.executeQuery("select * from 人员信息");
            while( 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)));

               String s0,s1,s2,s3,s4,s5,s6,s7,s8,s9,s10,s11;
              s0=rs.getString(1);
              a[i][0]=s0;
            s1=rs.getString(2);
            a[i][1]=s1;
            s2=rs.getString(3);
            a[i][2]=s2;
            s3=rs.getString(4);
            a[i][3]=s3;
            s4=rs.getString(5);
            a[i][4]=s4;
            s5=rs.getString(6);
            a[i][5]=s5;
            s6=rs.getString(7);
            a[i][6]=s6;

            s7=rs.getString(8);
            a[i][7]=s7;
            s8=rs.getString(9);
            a[i][8]=s8;
             s9=Integer.toString(rs.getInt(10));
            a[i][9]=s9;
            s10=Integer.toString(rs.getInt(11));
            a[i][10]=s10;
            s11=Integer.toString(rs.getInt(12));
            a[i][11]=s11;
           i++;
           System.out.print(s1);
           }

            con.close();
            jTable1.repaint();
            jTable1.setVisible(true);
        } 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);
        }
    }


}