sgettableaction.java~6~

管理系统

package com.aptech.cdjj.sex.action;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
import java.util.*;
import java.sql.ResultSet;
import com.aptech.cdjj.sex.database.SDBManager;
import java.sql.*;
import javax.swing.JTable;
import com.aptech.cdjj.sex.DBbase;

/*****************老彭讲解标准代码*********************************************/
public class SGetTableAction {
    ResultSet rs;
    public JTable getTable(String sql){  //传入sql语句，返回JTable
        Vector vcRow = new Vector();
        Vector vcCol = new Vector();
        Vector vcTemp = null;
        JTable tempTable = null;
        SDBManager.connToDB();
        rs = DBbase.executeQuery(sql);
        try {
            while (rs.next()) {
              vcTemp = new Vector();
              vcTemp.addElement(rs.getString(1));
              vcTemp.addElement(rs.getString(2));
              vcTemp.addElement(rs.getString(3));
              vcTemp.addElement(rs.getString(4));
              vcTemp.addElement(rs.getString(5));
              vcTemp.addElement(rs.getString(6));
              vcTemp.addElement(rs.getString(7));
              vcRow.add(vcTemp);
              vcTemp = null;
            }
        } catch (SQLException ex) {
        }
        vcCol.add("编号");vcCol.add("姓名");vcCol.add("密码");vcCol.add("职务");vcCol.add("性别");
        vcCol.add("地址");vcCol.add("电话");
        tempTable = new JTable(vcRow,vcCol);
        DBbase.closeObj();
        return tempTable;
    }
}