?? biq.java
字號:
package com.source;
import java.awt.*;
import javax.swing.*;
import javax.swing.table.*;
import java.awt.event.*;
import java.util.*;
import javax.swing.JScrollPane.*;
public class BIQ extends JInternalFrame{
JLabel lbl1=new JLabel("基 本 信 息 查 詢");
JLabel lbl2=new JLabel("員工編號：");
JLabel lbl3=new JLabel("員工姓名：");
JTextField btxtid=new JTextField(10);
JTextField btxtname=new JTextField(10);
JButton btn1=new JButton("查詢");
JTable table;
DefaultTableModel dtm;
String columns[] = {"員工編號","員工姓名"," 性別 ","出生日期","婚姻狀況","政治面貌"," 學歷 ","進入公司時間","轉(zhuǎn)正時間"," 部門 "," 職務(wù) ","員工狀態(tài)"," 備注 "};
public BIQ(){
setTitle("基 本 信 息 查 詢");
dtm = new DefaultTableModel();
table = new JTable(dtm);
JScrollPane sl = new JScrollPane();
sl.getViewport().add(table);
dtm.setColumnCount(5);
dtm.setColumnIdentifiers(columns);
// sl.getViewport().add(table,null);
//sl.setVerticalScrollBarPolicy(JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);
//sl.setver
//
// sl.HORIZONTAL_SCROLLBAR_ALWAYS;
// sl.VERTICAL_SCROLLBAR_ALWAYS;
//new JScrollPane().add(table);
//dtm.setColumnCount(columns.length);
// dtm.insertRow(0,columns);
//sl.setAutoscrolls(true);
//設(shè)列頭
/* dtm.setColumnIdentifiers(columns);
TableColumnModel tcm = table.getColumnModel();
for(int i=0;i<columns.length;i++)
{
tcm.getColumn(i).setWidth(180);
}
---------------------------------------------------------------------------------
*/
getContentPane().setLayout(null);
lbl1.setBounds(240,10,300,30);
lbl1.setFont(new Font("宋體",Font.BOLD,24));
getContentPane().add(lbl1);
Font f=new Font("宋體",Font.PLAIN,12);
lbl2.setBounds(10,60,80,25);
lbl2.setFont(f);
getContentPane().add(lbl2);
btxtid.setBounds(80,60,80,23);
btxtid.setFont(f);
getContentPane().add(btxtid);
lbl3.setBounds(10,90,80,25);
lbl3.setFont(f);
getContentPane().add(lbl3);
btxtname.setBounds(80,90,80,23);
btxtname.setFont(f);
getContentPane().add(btxtname);
btn1.setBounds(90,130,60,25);
btn1.setFont(f);
getContentPane().add(btn1);
sl.setBounds(180,60,500,370);
getContentPane().add(sl);
//設(shè)置邊框
btxtid.setBorder(BorderFactory.createLineBorder(Color.black));
btxtname.setBorder(BorderFactory.createLineBorder(Color.black));
btn1.setBorder(BorderFactory.createRaisedBevelBorder());
sl.setBorder(BorderFactory.createLineBorder(Color.black));
//----連接數(shù)據(jù)庫--------------------------------------------------------------------------
Database.joinDB();
String sql="select * from EmployeeInformation";
if(Database.query(sql)){
System.out.println(sql);
try{
while(Database.rs.next()){
String eNumber=(""+Database.rs.getInt("E_Number"));
System.out.println(eNumber);
String eName=Database.rs.getString("E_Name");
System.out.println(eName);
String eSex=Database.rs.getString("E_Sex");
System.out.println(eSex);
String eBornDate=Database.rs.getString("E_BornDate");
System.out.println(eBornDate);
String eMarriage=Database.rs.getString("E_Marriage");
System.out.println(eMarriage);
String ePoliticsVisage=Database.rs.getString("E_PoliticsVisage");
System.out.println(ePoliticsVisage);
String eSchoolAge=Database.rs.getString("E_SchoolAge");
System.out.println(eSchoolAge);
String eEnterDate=Database.rs.getString("E_EnterDate");
System.out.println(eEnterDate);
String eInDueFormDate=Database.rs.getString("E_InDueFormDate");
System.out.println(eInDueFormDate);
String eDepartment=Database.rs.getString("E_Department");
System.out.println(eDepartment);
String eHeadship=Database.rs.getString("E_Headship");
System.out.println(eHeadship);
String eEstate=Database.rs.getString("E_Estate");
System.out.println(eEstate);
String eRemark=Database.rs.getString("E_Remark");
System.out.println(eRemark);
Vector v=new Vector();
v.add(eNumber);
v.add(eName);
v.add(eSex);
v.add(eBornDate);
v.add(eMarriage);
v.add(ePoliticsVisage);
v.add(eSchoolAge);
v.add(eEnterDate);
v.add(eInDueFormDate);
v.add(eDepartment);
v.add(eHeadship);
v.add(eEstate);
v.add(eRemark);
dtm.addRow(v);
}
}
catch(Exception eBIQ){
System.out.println("初始化數(shù)據(jù)失敗！");
}
}
//為查詢按鈕加事件--------------------------------------------------------
btn1.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent eBIQ){
System.out.println("按鈕事件");
String esql;
int rc=dtm.getRowCount();
for(int i=0;i<rc;i++){
dtm.removeRow(0);
}
if(btxtid.getText().equals("")&&btxtname.getText().equals("")){
esql="select * from EmployeeInformation";
}
else if(btxtname.getText().equals("")){
esql="select * from EmployeeInformation where E_Number = '" + btxtid.getText() +"'";
}
else{
esql="select * from EmployeeInformation where E_Number = '" + btxtid.getText() +"' or E_Name like '%"+ btxtname.getText() +"%'";
}
System.out.println(esql);
if(Database.query(esql)){
try{
while(Database.rs.next()){
String eNumber=(""+Database.rs.getInt("E_Number"));
System.out.println(eNumber);
String eName=Database.rs.getString("E_Name");
System.out.println(eName);
String eSex=Database.rs.getString("E_Sex");
System.out.println(eSex);
String eBornDate=Database.rs.getString("E_BornDate");
System.out.println(eBornDate);
String eMarriage=Database.rs.getString("E_Marriage");
System.out.println(eMarriage);
String ePoliticsVisage=Database.rs.getString("E_PoliticsVisage");
System.out.println(ePoliticsVisage);
String eSchoolAge=Database.rs.getString("E_SchoolAge");
System.out.println(eSchoolAge);
String eEnterDate=Database.rs.getString("E_EnterDate");
System.out.println(eEnterDate);
String eInDueFormDate=Database.rs.getString("E_InDueFormDate");
System.out.println(eInDueFormDate);
String eDepartment=Database.rs.getString("E_Department");
System.out.println(eDepartment);
String eHeadship=Database.rs.getString("E_Headship");
System.out.println(eHeadship);
String eEstate=Database.rs.getString("E_Estate");
System.out.println(eEstate);
String eRemark=Database.rs.getString("E_Remark");
System.out.println(eRemark);
Vector v=new Vector();
v.add(eNumber);
v.add(eName);
v.add(eSex);
v.add(eBornDate);
v.add(eMarriage);
v.add(ePoliticsVisage);
v.add(eSchoolAge);
v.add(eEnterDate);
v.add(eInDueFormDate);
v.add(eDepartment);
v.add(eHeadship);
v.add(eEstate);
v.add(eRemark);
dtm.addRow(v);
}
}
catch(Exception eB){
}
}
}
});
//------------------------------------------------------------------
setSize(700,480);
this.setClosable(true);
setVisible(true);
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -