2014.12.04从数据库中查找数据，并以表格显示

1.

<span style="font-size:18px;">package com.hechao;import java.util.ArrayList;import javax.swing.JFrame;import javax.swing.JScrollPane;import javax.swing.JTable;import javax.swing.table.DefaultTableModel;/** * 查询窗口 * @author hechao * */@SuppressWarnings("serial")public class MyFrame extends JFrame {private JTable empTable = null;private static String[] columnNames = {"工号", "姓名", "职位", "隶属领编号", "工资", "补贴", "隶属部门编号"};/** * 构造器 */public MyFrame(){this.setTitle("表格查询");this.setSize(600, 300);this.setResizable(false);this.setLocationRelativeTo(null);this.setDefaultCloseOperation(EXIT_ON_CLOSE);ini();}/** * 刷新表格模型 */public void refreshTableModel() {if(empTable != null) {Manage manage = new Manage();ArrayList<Employee> list = manage.findAll();Object[][] data = new Object[list.size()][columnNames.length];for(int i = 0; i < data.length; i++) {Employee temp = list.get(i);data[i][0] = temp.getEno();data[i][1] = temp.getEname();data[i][2] = temp.getJob();data[i][3] = temp.getMgr();data[i][4] = temp.getSal();data[i][5] = temp.getComm();data[i][6] = temp.getDno();}empTable.setModel(new DefaultTableModel(data, columnNames) {@Overridepublic boolean isCellEditable(int row, int column) {// 不允许编辑单元格return false;}});}}/** * 初始化窗口 */private void ini(){empTable = new JTable();empTable.getTableHeader().setReorderingAllowed(false);refreshTableModel();this.add(new JScrollPane(empTable));}}</span>

2.

<span style="font-size:18px;">package com.hechao;/** * 员工类（POJO） * @author hechao * */public class Employee {private int eno;  //员工编号private String ename;//员工姓名private String job;//职位private int mgr;//隶属领编号private int sal;//工资private int comm;//补贴private int dno;//部门编号public Employee(){};public int getEno() {return eno;}public void setEno(int eno) {this.eno = eno;}public String getEname() {return ename;}public void setEname(String ename) {this.ename = ename;}public String getJob() {return job;}public void setJob(String job) {this.job = job;}public int getMgr() {return mgr;}public void setMgr(int mgr) {this.mgr = mgr;}public int getSal() {return sal;}public void setSal(int sal) {this.sal = sal;}public int getComm() {return comm;}public void setComm(int comm) {this.comm = comm;}public int getDno() {return dno;}public void setDno(int dno) {this.dno = dno;}@Overridepublic String toString() {return "Employee [eno=" + eno + ", ename=" + ename + ", job=" + job+ ", mgr=" + mgr + ", sal=" + sal + ", comm=" + comm + ", dno="+ dno + "]";}}</span>

3.

<span style="font-size:18px;">package com.hechao;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.ArrayList;/** * 管理类 * @author hechao * */public class Manage {/** * 查找所有员工信息 * @return 返回一个装员工的数组容器 */public ArrayList<Employee> findAll(){ArrayList<Employee> list = new ArrayList<Employee>();Connection con = null;Statement stmt = null;ResultSet rs = null;try {Class.forName("com.mysql.jdbc.Driver");con = DriverManager.getConnection("jdbc:mysql://localhost:3306/school","root", "123456");stmt = con.createStatement();rs = stmt.executeQuery("select * from emp");while(rs.next()) {Employee employee = new Employee();employee.setEno(rs.getInt("eno"));employee.setEname(rs.getString("ename"));employee.setJob(rs.getString("job"));employee.setMgr(rs.getInt("mgr"));employee.setSal(rs.getInt("sal"));employee.setComm(rs.getInt("comm"));employee.setDno(rs.getInt("dno"));list.add(employee);}return list;} catch (ClassNotFoundException e) {e.printStackTrace();}catch (SQLException e) {e.printStackTrace();}finally {if(rs != null) {try {rs.close();}catch (SQLException e) {e.printStackTrace();}}if(stmt != null) {try {stmt.close();}catch (SQLException e) {e.printStackTrace();}}if(con != null) {try {con.close();}catch (SQLException e) {e.printStackTrace();}}}return null;}}</span>

4.

<span style="font-size:18px;">package com.hechao;/** * 查询 * @author hechao * */public class Search {public static void main(String[] args) {new MyFrame().setVisible(true);}}</span>