?? tongji.java
字號:
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.text.*;
import javax.swing.text.*;
import java.sql.*;
import javax.swing.event.*;
import javax.swing.table.*;
import java.util.Vector;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
class TongJi implements ActionListener
{
//總面板
JPanel pane;
//統計面板
JPanel paneTongji;
JLabel lblTongji;
FormatText format;
JButton cmdTongji;
//統計表格
JTable tableTongji;
JScrollPane scroll;
//統計表格Model
DefaultTableModel modelTongji;
//
JTextField[] txtTemp=new JTextField[3];
//構造函數
TongJi() throws ParseException
{
//統計面板
paneTongji=new JPanel();
paneTongji.setLayout(new FlowLayout());
paneTongji.setBackground(Color.orange);
lblTongji=new JLabel("統計日期");
lblTongji.setForeground(new Color(89,89,255));
format=new FormatText();
cmdTongji=new JButton("統計");
cmdTongji.addActionListener(this);
cmdTongji.setBackground(Color.orange);
cmdTongji.setForeground(new Color(89,89,255));
paneTongji.add(lblTongji);
paneTongji.add(format.ftf);
paneTongji.add(cmdTongji);
//統計表格
modelTongji=new DefaultTableModel()
{
public boolean isCellEditable(int row,int col)
{
return false;
}
};
settablemodel(modelTongji);
tableTongji=new JTable(modelTongji);
tableTongji.getTableHeader().setBackground(new Color(255,255,230));
tableTongji.getTableHeader().setForeground(new Color(255,0,255));
tableTongji.setForeground(new Color(77,199,199));
scroll=new JScrollPane(tableTongji);
scroll.getViewport().setBackground(new Color(255,255,240));
//總面板
for(int i=0;i<3;i++)
{
txtTemp[i]=new JTextField(10);
txtTemp[i].setBackground(new Color(255,255,240));
if(i==2)
txtTemp[i].setBackground(Color.orange);
txtTemp[i].setBorder(BorderFactory.createMatteBorder(0,4,0,4,Color.orange));
txtTemp[i].setEditable(false);
}
pane=new JPanel();
pane.setLayout(new BorderLayout());
pane.add(paneTongji,BorderLayout.NORTH);
pane.add(scroll,BorderLayout.CENTER);
pane.add(txtTemp[0],BorderLayout.WEST);
pane.add(txtTemp[1],BorderLayout.EAST);
pane.add(txtTemp[2],BorderLayout.SOUTH);
}
void settablemodel(DefaultTableModel m)
{
Vector head=new Vector();
head.addElement("項目");
head.addElement("總計");
head.addElement("本年新增");
head.addElement("本月新增");
head.addElement("本日新增");
m.setColumnIdentifiers(head);
m.setNumRows(6);
Object[] obj={"招聘單位(家)","招聘信息(條)","人才庫(人)","介紹人才(人)","累計介紹成功數","累計介紹不成功數"};
for(int i=0;i<6;i++)
m.setValueAt(obj[i],i,0);
}
void setinfo1(JTable t,int row,String str,int col)
{
String sFormat=format.ftf.getText().trim();
Date dateFormat=Date.valueOf(sFormat);
//總計
try
{
DataBase db=new DataBase();
db.GetResultSet(str);
int cout1=0;
while (db.rs.next())
{
String s=db.rs.getString(col).trim();
Date date=Date.valueOf(s);
cout1++;
}
db.st.close();
t.setValueAt(String.valueOf(cout1),row,1);
}catch(SQLException e){}
//本年新增
try
{
DataBase db=new DataBase();
db.GetResultSet(str);
int cout2=0;
while (db.rs.next())
{
int yearFormat=dateFormat.getYear();
String sDb=db.rs.getString(col).trim();
Date dateDb=Date.valueOf(sDb);
int yearDb=dateDb.getYear();
if(yearFormat==yearDb)
cout2++;
}
db.st.close();
t.setValueAt(String.valueOf(cout2),row,2);
}catch(SQLException e){}
//本月新增
try
{
DataBase db=new DataBase();
db.GetResultSet(str);
int cout3=0;
while (db.rs.next())
{
int yearFormat=dateFormat.getYear();
int monthFormat=dateFormat.getMonth();
String sDb=db.rs.getString(col).trim();
Date dateDb=Date.valueOf(sDb);
int yearDb=dateDb.getYear();
int monthDb=dateDb.getMonth();
if(yearFormat==yearDb&&monthFormat==monthDb)
cout3++;
}
db.st.close();
t.setValueAt(String.valueOf(cout3),row,3);
}catch(SQLException e){}
//本日新增
try
{
DataBase db=new DataBase();
db.GetResultSet(str);
int cout4=0;
while (db.rs.next())
{
int yearFormat=dateFormat.getYear();
int monthFormat=dateFormat.getMonth();
int dayFormat=dateFormat.getDay();
String sDb=db.rs.getString(col).trim();
Date dateDb=Date.valueOf(sDb);
int yearDb=dateDb.getYear();
int monthDb=dateDb.getMonth();
int dayDb=dateDb.getDay();
if(yearFormat==yearDb&&monthFormat==monthDb&&dayFormat==dayDb)
cout4++;
}
db.st.close();
t.setValueAt(String.valueOf(cout4),row,4);
}catch(SQLException e){}
}
////////////////////
void setchenggong(JTable t,String b,int row,String str,int col)
{
String sFormat=format.ftf.getText().trim();
Date dateFormat=Date.valueOf(sFormat);
//總計
try
{
DataBase db=new DataBase();
db.GetResultSet(str);
int cout1=0;
while (db.rs.next())
{
String s=db.rs.getString(col).trim();
String s1=db.rs.getString(1).trim();
Date date=Date.valueOf(s);
if(s1.equalsIgnoreCase(b)==true)
cout1++;
}
db.st.close();
t.setValueAt(String.valueOf(cout1),row,1);
}catch(SQLException e){}
//本年成功
try
{
DataBase db=new DataBase();
db.GetResultSet(str);
int cout2=0;
while (db.rs.next())
{
int yearFormat=dateFormat.getYear();
String sDb=db.rs.getString(col).trim();
String s1=db.rs.getString(1).trim();
Date dateDb=Date.valueOf(sDb);
int yearDb=dateDb.getYear();
if(yearFormat==yearDb&&s1.equalsIgnoreCase(b)==true)
cout2++;
}
db.st.close();
t.setValueAt(String.valueOf(cout2),row,2);
}catch(SQLException e){}
//本月成功
try
{
DataBase db=new DataBase();
db.GetResultSet(str);
int cout3=0;
while (db.rs.next())
{
int yearFormat=dateFormat.getYear();
int monthFormat=dateFormat.getMonth();
String sDb=db.rs.getString(col).trim();
String s1=db.rs.getString(1).trim();
Date dateDb=Date.valueOf(sDb);
int yearDb=dateDb.getYear();
int monthDb=dateDb.getMonth();
if(yearFormat==yearDb&&monthFormat==monthDb&&s1.equalsIgnoreCase(b)==true)
cout3++;
}
db.st.close();
t.setValueAt(String.valueOf(cout3),row,3);
}catch(SQLException e){}
//本日成功
try
{
DataBase db=new DataBase();
db.GetResultSet(str);
int cout4=0;
while (db.rs.next())
{
int yearFormat=dateFormat.getYear();
int monthFormat=dateFormat.getMonth();
int dayFormat=dateFormat.getDay();
String sDb=db.rs.getString(col).trim();
String s1=db.rs.getString(1).trim();
Date dateDb=Date.valueOf(sDb);
int yearDb=dateDb.getYear();
int monthDb=dateDb.getMonth();
int dayDb=dateDb.getDay();
if(yearFormat==yearDb&&monthFormat==monthDb&&dayFormat==dayDb&&s1.equalsIgnoreCase(b)==true)
cout4++;
}
db.st.close();
t.setValueAt(String.valueOf(cout4),row,4);
}catch(SQLException e){}
}
public void actionPerformed(ActionEvent parm1)
{
try
{
setinfo1(tableTongji,0,"select * from 企業信息",10);
setinfo1(tableTongji,1,"select * from 招聘信息",5);
setinfo1(tableTongji,2,"select * from 人才登記",15);
setinfo1(tableTongji,3,"select * from 介紹信",17);
setchenggong(tableTongji,"1",4,"select * from 介紹信",17);
setchenggong(tableTongji,"0",5,"select * from 介紹信",17);
}catch(Exception e)
{
JOptionPane.showMessageDialog(null,"統計日期輸入錯誤!!");
}
}
}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -