showsearch.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.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.KeyStroke;
import javax.swing.table.DefaultTableModel;

public class ShowSearch 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("退出");

	private String name = "";

	private String id = "";

	private String zhiwu = "";

	private String part = "";

	private String sql = "";

	public ShowSearch() {
		super("查询结果");
		initialize();

	}

	public void setName(String newName) {
		name = newName;
	}

	public String getName() {
		return name;

	}

	public void setID(String newID) {
		id = newID;
	}

	public String getID() {
		return id;
	}

	public void setZhiwu(String newzhiwu) {
		zhiwu = newzhiwu;
	}

	public String getZhiwu() {
		return zhiwu;
	}

	public void setPart(String newpart) {
		part = newpart;
	}

	public String getPart() {
		return part;
	}

	public String getSql() {
		String NAME = "";
		String ID = "";
		String PART = "";
		String ZHIWU = "";
		if (!getName().equals("")) {
			NAME = " name='" + getName() + "'";
		}
		if (!getID().equals("")) {
			ID = "and id='" + getID() + "'";
		}
		if (!getZhiwu().equals("")) {
			ZHIWU = "and zhiwu='" + getZhiwu() + "'";
		}
		if (!getPart().equals("")) {
			PART = "and part='" + getPart() + "'";
		}
		sql = "select*from user where" + NAME + ID + ZHIWU + PART + "";	
		return sql;
	}

	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();
				dispose();
				SearchScreen screen = new SearchScreen();
				screen.repaint();
				screen.setVisible(true);
			}
		});
		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 void showResult() {
		DataBase db = new DataBase();
		String sql1 = getSql();
		sql1=changeChar.gbToiso(sql1);
		System.out.println(sql1);
		boolean flag = false;
		ResultSet rs = null;
		try {
			Statement stmt = db.conn.createStatement();
			rs = stmt.executeQuery(sql1);
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		try {
			if (rs.first()) {
				flag = true;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		if (!flag) {
			JOptionPane.showMessageDialog(null, "对不起没有你要的查询");
			dispose();
			SearchScreen screen = new SearchScreen();
			screen.repaint();
			screen.setVisible(true);
		}
		try {
			if (rs.first()) {
				rs.beforeFirst();
			}
		} catch (SQLException e1) {
			e1.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

	}

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