职工管理系统
text2 = new TextField(6); text4 = new TextField(6); text5 = new TextField(6); text6 = new TextField(3); text7 = new TextField(12); text8 = new TextField(8); table = new JTable(); pane1 = new JPanel(); pane2 = new JPanel(); pane3 = new JPanel(); pane4 = new JPanel(); pane5 = new JPanel(); pane5.add(table); pane1.add(but1); pane1.add(but2); pane1.add(but3); pane1.add(but4); pane2.add(lab1); pane2.add(text1); pane2.add(lab2); pane2.add(text2); pane2.add(lab3); pane2.add(list); pane3.add(lab4); pane3.add(text4); pane3.add(lab5); pane3.add(text5); pane3.add(lab6); pane3.add(text6); pane4.add(lab7); pane4.add(text7); pane4.add(lab9); pane4.add(lab8); pane4.add(text8); this.add(pane1); this.add(pane2); this.add(pane3); this.add(pane4); this.add(pane5); this.setVisible(true); }
public JTable getJTable() { return table; }
public void setJTable(JTable table) { this.table = table; JScrollPane jsp = new JScrollPane(this.table);
- 36 -
职工管理系统
pane5.removeAll(); pane5.add(jsp, BorderLayout.CENTER); this.repaint(); } public void setText() { text1.setText(null); text2.setText(null); text4.setText(null); text5.setText(null); text6.setText(null); text7.setText(null); text8.setText(null); } }
package mySencondPackage; import java.awt.BorderLayout; import java.awt.Button; import java.awt.Color;
import java.awt.FlowLayout; import java.awt.Frame; import java.awt.Label; import java.awt.Panel; import java.awt.TextArea; import java.awt.TextField;
import javax.swing.BoxLayout; import javax.swing.JPanel;
import javax.swing.JScrollPane; import javax.swing.JTable;
public class MyJPanelWorker extends JPanel{ Button but1,but2,but3,but4; Label lab1,lab2,lab3,lab4,lab5,lab6,lab7; TextField text1,text2,text3,text4,text5,text6; JTable table; Panel pane1,pane2,pane3,pane4,pane5; public MyJPanelWorker(){
- 37 -
职工管理系统
this.setLayout(new BoxLayout(this,BoxLayout.Y_AXIS)); but1=new Button(\计发工资\but2=new Button(\修改工资\but3=new Button(\查询工资\but4=new Button(\查询人员\lab1=new Label(\姓 名：\lab2=new Label(\身份证：\lab3=new Label(\院 系：\lab4=new Label(\总工资：\lab5=new Label(\社 保：\lab6=new Label(\房 租：\lab7=new Label(\显示信息：\text1=new TextField(6); text2=new TextField(6); text3=new TextField(6); text4=new TextField(6); text5=new TextField(6); text6=new TextField(6); table=new JTable(); pane1=new Panel(); pane2=new Panel(); pane3=new Panel(); pane4=new Panel(); pane5=new Panel(); pane1.add(but1); pane1.add(but2); pane1.add(but3); pane1.add(but4); pane2.add(lab1); pane2.add(text1); pane2.add(lab2); pane2.add(text2); pane2.add(lab3); pane2.add(text3); pane3.add(lab4); pane3.add(text4); pane3.add(lab5); pane3.add(text5); pane3.add(lab6); pane3.add(text6);
pane5.add(table,BorderLayout.CENTER); this.add(pane1); this.add(pane2); this.add(pane3); this.add(pane4); this.add(pane5);
- 38 -
职工管理系统
this.setBounds(400, 350, 450, 330); this.setVisible(true); } public JTable getJTable() { return table;} public void setJTable(JTable table) { this.table = table; JScrollPane jsp=new JScrollPane(this.table); pane5.removeAll(); pane5.add(jsp,BorderLayout.CENTER); } public void setText(){ text1.setText(null); text2.setText(null); text3.setText(null); text4.setText(null); text5.setText(null); text6.setText(null); }}
package mySencondPackage;
import java.sql.ResultSet; import java.util.Vector; import javax.swing.JTable; public class OnShow { Vector
- 39 -
职工管理系统
}
worker.setWorker_sex(sc.getString(\as.add(worker);
String[] ss = { \姓名\年龄\性别\职工号 \授课 \所在系\身份证 \ \联系方式\ String[][] jj = new String[as.size()][ss.length]; for (int i = 0; i < as.size(); i++) { int n = 0; jj[i][n++] = as.get(i).getWorker_name(); jj[i][n++] = as.get(i).getWorker_age(); jj[i][n++] = as.get(i).getWorker_sex(); jj[i][n++] = as.get(i).getWorker_num(); jj[i][n++] = as.get(i).getWorker_class(); jj[i][n++] = as.get(i).getWorker_place(); jj[i][n++] = as.get(i).getWorker_code(); jj[i][n++] = as.get(i).getWorker_phone(); } a = new JTable(jj, ss); a.setAutoResizeMode(1); a.show(); a.setColumnSelectionAllowed(false); a.doLayout(); } catch (Exception e) { e.printStackTrace();} return a;}
public JTable onShowSalary(ResultSet sc) { try { while (sc.next()) { Salary salary = new Salary(); salary.setWorker_name(sc.getString(\ salary.setWorker_code(sc.getString(\ salary.setSalary_much(sc.getString(\ salary.setWorker_protect(sc.getString(\ salary.setWorker_rent(sc.getString(\ ac.add(salary); } String[] ss = { \姓名\身份证\总工资\社保 \房租 \ String[][] jj = new String[ac.size()][ss.length]; for (int i = 0; i < ac.size(); i++) { int n = 0; jj[i][n++] = ac.get(i).getWorker_name(); jj[i][n++] = ac.get(i).getWorker_code(); jj[i][n++] = ac.get(i).getSalary_much(); jj[i][n++] = ac.get(i).getWorker_protect();
- 40 -