person_info.java~14~

一款高校科研管理系统

package scince;

import java.awt.*;
import java.sql.*;
import java.awt.*;
import javax.swing.*;
import java.awt.Rectangle;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

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));
        this.getContentPane().add(jLabel1);
        jButton2.setBounds(new Rectangle(218, 305, 91, 35));
        jButton2.setText("下一条");
        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(jButton2);
        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();
    JButton jButton2 = new JButton();

    private String sqlString;
    private  Connection con;
    private Statement query;
    private ResultSet rs;

    public void jButton1_actionPerformed(ActionEvent e) {


   con=scinceconnect.getconn();
   query=con.createStatement();
   sqlString = "Select * from "人员信息" ";
   rs=query.executeQuery(sql);
   while(rs.next())
   {
   }

   scinceconnect.close(rs);
       scinceconnect.close(query);
       scinceconnect.close(con);

    };

}

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);
    }
}