state.java

java+mysql开发的档案管理系统

package system;

import java.awt.BorderLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.KeyEvent;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;

import javax.swing.JButton;
import javax.swing.JComponent;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.KeyStroke;
import javax.swing.table.DefaultTableModel;

public class State extends JFrame implements ActionListener {
	private static final long serialVersionUID = 1L;

	private JScrollPane pane = new JScrollPane();

	private DefaultTableModel model = new DefaultTableModel();

	private Vector list = new Vector(1, 1);

	private JLabel label = new JLabel("档案统计");

	private JButton cancelButton = new JButton("退出");

	DataBase db = new DataBase();

	ResultSet rs = null;

	Statement stmt = null;

	State() {
		super("浏览统计");
	}

	public void initialize(String msg) {
		setSize(600, 400);
		setLocation(250, 200);
		cancelButton.setSize(40, 20);
		if (msg.equals("sex")) {
			pane = getsexPane();
		} else if (msg.equals("wenhua")) {
			pane = getwenhuaPane();
		} else if (msg.equals("part")) {
			pane = getpartPane();
		} else if (msg.equals("zhiwu")) {
			pane = getzhiwuPane();
		}
		JPanel panel1 = new JPanel();
		panel1.add(label);
		JPanel panel = new JPanel();
		panel.add(cancelButton);
		cancelButton.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent evt) {
				dispose();
			}
		});
		this.getContentPane().add(panel1, BorderLayout.NORTH);
		this.getContentPane().add(pane, BorderLayout.CENTER);
		this.getContentPane().add(panel, BorderLayout.SOUTH);
		if (msg.equals("sex")) {
			showsexResult();
		} else if (msg.equals("wenhua")) {
			showwenhuaResult();
		} else if (msg.equals("part")) {
			showpartResult();
		} else if (msg.equals("zhiwu")) {
			showzhiwuResult();
		}
		ActionListener s = new ActionListener() {
			public void actionPerformed(ActionEvent evt) {
				dispose();
			}
		};
		this.getRootPane().registerKeyboardAction(s,
				KeyStroke.getKeyStroke(KeyEvent.VK_ENTER, 0, false),
				JComponent.WHEN_IN_FOCUSED_WINDOW);
	}

	public JScrollPane getsexPane() {
		JTable table = new JTable(model);
		JScrollPane scrollpane = new JScrollPane();
		model.addColumn("男");
		model.addColumn("女");
		scrollpane.getViewport().add(table, null);
		return scrollpane;
	}

	public JScrollPane getwenhuaPane() {
		JTable table = new JTable(model);
		JScrollPane scrollpane = new JScrollPane();
		model.addColumn("大学");
		model.addColumn("研究生");
		model.addColumn("博士");
		model.addColumn("教授");
		scrollpane.getViewport().add(table, null);
		return scrollpane;
	}

	public JScrollPane getpartPane() {
		JTable table = new JTable(model);
		JScrollPane scrollpane = new JScrollPane();
		model.addColumn("人事管理部");
		model.addColumn("后勤部");
		model.addColumn("财政部");
		scrollpane.getViewport().add(table, null);
		return scrollpane;
	}

	public JScrollPane getzhiwuPane() {
		JTable table = new JTable(model);
		JScrollPane scrollpane = new JScrollPane();
		model.addColumn("员工");
		model.addColumn("经理");
		scrollpane.getViewport().add(table, null);
		return scrollpane;
	}

	public void showsexResult() {
		int a = 0;
		int b = 0;
		try {
			stmt = db.conn.createStatement();
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		// 对男统计
		try {
			rs = stmt.executeQuery(changeChar
					.gbToiso("select*from user where sex='男'"));
			while (rs.next()) {
				a = a + 1;
			}
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		// 对女统计
		try {
			rs = stmt.executeQuery(changeChar
					.gbToiso("select*from user where sex='女'"));
			while (rs.next()) {
				b = b + 1;
			}
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		Integer s = new Integer(a);
		list.add(s.toString()+"人");
		Integer s1 = new Integer(b);
		list.add(s1.toString()+"人");
		model.addRow(list);
	}

	public void showzhiwuResult() {
		int a = 0;
		int b = 0;
		try {
			stmt = db.conn.createStatement();
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		try {
			rs = stmt.executeQuery(changeChar
					.gbToiso("select*from user where zhiwu='员工'"));
			while (rs.next()) {
				a++;
			}
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		try {
			rs = stmt.executeQuery(changeChar
					.gbToiso("select*from user where zhiwu='经理'"));
			while (rs.next()) {
				b++;
			}
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		Integer s = new Integer(a);
		list.add(s.toString()+"人");
		Integer s1 = new Integer(b);
		list.add(s1.toString()+"人");
		model.addRow(list);
	}

	public void showpartResult() {
		int a = 0;
		int b = 0;
		int c = 0;
		try {
			stmt = db.conn.createStatement();
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		try {
			rs = stmt.executeQuery(changeChar
					.gbToiso("select*from user where part='人事管理部'"));
			while (rs.next()) {
				a++;
			}
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		try {
			rs = stmt.executeQuery(changeChar
					.gbToiso("select*from user where part='后勤部'"));
			while (rs.next()) {
				b++;
			}
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		try {
			rs = stmt.executeQuery(changeChar
					.gbToiso("select*from user where part='财政部'"));
			while (rs.next()) {
				c++;
			}
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		Integer s = new Integer(a);
		list.add(s.toString()+"人");
		Integer s1 = new Integer(b);
		list.add(s1.toString()+"人");
		Integer s2 = new Integer(c);
		list.add(s2.toString()+"人");
		model.addRow(list);
	}

	public void showwenhuaResult() {
		int a = 0;
		int b = 0;
		int c = 0;
		int d = 0;
		try {
			stmt = db.conn.createStatement();
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		try {
			rs = stmt.executeQuery(changeChar
					.gbToiso("select*from user where wenhua='大学'"));
			while (rs.next()) {
				a++;
			}
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		try {
			rs = stmt.executeQuery(changeChar
					.gbToiso("select*from user where wenhua='研究生'"));
			while (rs.next()) {
				b++;

			}
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		try {
			rs = stmt.executeQuery(changeChar
					.gbToiso("select*from user where wenhua='博士'"));
			while (rs.next()) {
				c++;
			}
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		try {
			rs = stmt.executeQuery(changeChar
					.gbToiso("select*from user where wenhua='教授'"));
			while (rs.next()) {
				d++;
			}
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		Integer s = new Integer(a);
		list.add(s.toString()+"人");
		Integer s1 = new Integer(b);
		list.add(s1.toString()+"人");
		Integer s2 = new Integer(c);
		list.add(s2.toString()+"人");
		Integer s3 = new Integer(d);
		list.add(s3.toString()+"人");
		model.addRow(list);
	}

	public void actionPerformed(ActionEvent arg0) {
		// TODO Auto-generated method stub

	}
}