cgettable.java~4~

管理系统

package com.aptech.cdjj.sex.action;

import java.sql.*;
import java.util.*;

import javax.swing.*;

import com.aptech.cdjj.sex.database.*;

public class CGetTable {
    ResultSet rs = null;
    public JTable getTable(String sql){
        Vector vRow = new Vector();
        Vector vCol = new Vector();
        Vector temp = null;
        JTable table = 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));
                temp.addElement(rs.getString(5));
                temp.addElement(rs.getString(6));
                temp.addElement(rs.getString(7));
                temp.addElement(rs.getString(8));
                temp.addElement(rs.getString(9));
                temp.addElement(rs.getString(10));
                temp.addElement(rs.getString(11));
                temp.addElement(rs.getString(12));
                vRow.addElement(temp);
                temp = null;
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        vCol.addElement("编号");vCol.addElement("姓名");vCol.addElement("类型");vCol.addElement("累计金额(￥)");
        vCol.addElement("享受折扣(￥)");vCol.addElement("地区");vCol.addElement("性别");vCol.addElement("年龄");
        vCol.addElement("电话");vCol.addElement("地址");vCol.addElement("日期");vCol.addElement("备注");
        table = new JTable(vRow,vCol);
        return table;
    }
    //删除数据
        public boolean info1(String id){
            SDBManager.ConnToDB();
            String sql = "delete  from client where cid = '"+id+"'";
            SDBManager.executeUpdate(sql);
           SDBManager.closeObj();
            return true;

        }
        public JTable getSTable(String sql){
        Vector vRow = new Vector();
        Vector vCol = new Vector();
        Vector temp = null;
        JTable table = 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));
                vRow.addElement(temp);
                temp = null;
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        vCol.addElement("姓名");
        vCol.addElement("地区");
        vCol.addElement("电话");
        table = new JTable(vRow,vCol);
        return table;
    }
}