tongji.java

档案管理(java).rar

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,"统计日期输入错误!!");
	     }
	}
		
}