cgettable.java

管理系统

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;
    }

    //以客户的编号进行查询（查询出该编号的客户购买了那些珠宝）
    public Vector query(String id) throws SQLException {

        SDBManager.ConnToDB();
        String sql = "select aname,astyle,aprice from asset where abuy = '"+id+"'";
        rs = SDBManager.executeQuery(sql);
        Vector vect =  new Vector();
        while(rs.next()){
            Vector vec = new Vector();
            vec.add(rs.getString("aname"));
            vec.add(rs.getString("astyle"));
            vec.add(rs.getString("aprice"));
            vect.add(vec);
        }
        return vect;
    }

    //设置表格的表头
    public Vector title(){
        Vector vec = new Vector();
        vec.addElement("珠宝名称");
        vec.addElement("款式");
        vec.addElement("价格");
        return vec;

    }
}