showdata.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 ShowData extends JFrame implements ActionListener {
	private static final long serialVersionUID = 1L;

	private JScrollPane pane = new JScrollPane();

	private DefaultTableModel model = new DefaultTableModel();

	private Vector list;

	private JLabel label = new JLabel("全部档案浏览:");

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

	ShowData() {
		super("浏览档案");
		initialize();
	}

	public void initialize() {
		setSize(600, 400);
		setLocation(250, 200);
		cancelButton.setSize(40, 20);
		pane = getPane();
		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);
		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 getPane() {
		JTable table = new JTable(model);
		JScrollPane scrollpane = new JScrollPane();
		model.addColumn("编号");
		model.addColumn("姓名");
		model.addColumn("性别");
		model.addColumn("出生年月");
		model.addColumn("住址");
		model.addColumn("电话");
		model.addColumn("籍贯");
		model.addColumn("文化水平");
		model.addColumn("职务");
		model.addColumn("部门");
		model.addColumn("工资");
		scrollpane.getViewport().add(table, null);
		return scrollpane;
	}

	public static void main(String args[]) {
		ShowData s = new ShowData();
		s.repaint();
		s.setVisible(true);
		s.showResult();
		s.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
	}

	public void showResult() {
		DataBase db = new DataBase();
		String sql = "Select*from user";
		ResultSet rs = null;
		Statement stmt = null;
		try {
			stmt = db.conn.createStatement();
			rs = stmt.executeQuery(sql);
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		try {
			if(rs.first()){
				rs.beforeFirst();
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		try {
			while (rs.next()) {
				list = new Vector(1, 1);
				list.add(changeChar.isoTogb(rs.getString("id")));
				list.add(changeChar.isoTogb(rs.getString("name")));
				list.add(changeChar.isoTogb(rs.getString("sex")));
				list.add(changeChar.isoTogb(rs.getString("date")));
				list.add(changeChar.isoTogb(rs.getString("address")));
				list.add(changeChar.isoTogb(rs.getString("phone")));
				list.add(changeChar.isoTogb(rs.getString("home")));
				list.add(changeChar.isoTogb(rs.getString("wenhua")));
				list.add(changeChar.isoTogb(rs.getString("zhiwu")));
				list.add(changeChar.isoTogb(rs.getString("part")));
				list.add(changeChar.isoTogb(rs.getString("salary")));
				model.addRow(list);
			}
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
	}

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

	}
}