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;

    }
}