eshowtable.java

管理系统

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 com.aptech.cdjj.sex.database.SDBManager;
import java.sql.ResultSet;
import java.sql.*;
import javax.swing.JTable;
public class EShowTable {

    public JTable getTable(String sql){
        Vector vRow = new Vector();
        Vector vCol = new Vector();
        Vector temp = null;
        JTable tempTable = null;
        SDBManager.ConnToDB();
        ResultSet rs = SDBManager.executeQuery(sql);
        try {
            while (rs.next()) {
                temp = new Vector();
                temp.addElement(rs.getString(1));
                temp.addElement(rs.getString(2));
                temp.addElement(rs.getString(3));
                temp.addElement(rs.getString(4));
                vRow.addElement(temp);
                temp = null;
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        vCol.addElement("编号");vCol.addElement("名称");
        vCol.addElement("成本价（￥）");vCol.addElement("售价（￥）");
        tempTable  = new JTable(vRow,vCol);
        SDBManager.closeObj();
        return tempTable;
    }
}