package com.aptech.cdjj.sex.action;


import com.aptech.cdjj.sex.database.SDBManager;
import java.sql.ResultSet;
import java.sql.*;
import java.sql.*;
import java.util.ArrayList;
import java.util.Vector;

public class Cid {
    Connection con = null;
    Statement s = null;
    ResultSet rs = null;
    ArrayList  arraylist = new ArrayList();
    SDBManager sd = new SDBManager();
    private Vector vect;

    /**
     * 接收輸入的編號進行查詢
     * @param id String
     * @return Vector
     * @throws SQLException
     */
    public Vector query(String id) {
        SDBManager.ConnToDB();
        String sql = "select * from client where cid = '"+id+"'";
        ResultSet rs = SDBManager.executeQuery(sql);
        Vector vect = new Vector();
        try {
            while (rs.next()) {
                Vector vec = new Vector();
                vec.add(rs.getString(1));
                vec.add(rs.getString(2));
                vec.add(rs.getString(3));
                vec.add(rs.getString(4));
                vec.add(rs.getString(5));
                vec.add(rs.getString(6));
                vec.add(rs.getString(7));
                vec.add(rs.getString(8));
                vec.add(rs.getString(9));
                vec.add(rs.getString(10));
                vec.add(rs.getString(11));
                vec.add(rs.getString(12));
                vect.add(vec);
            }
        } catch (SQLException ex) {
        }
        SDBManager.closeObj();
        return vect;
    }
//    public boolean mua(String id) {
//        SDBManager.ConnToDB();
//        String sql = "select cid from client where cid = '"+id+"'";
//          ResultSet rs = SDBManager.executeQuery(sql);
//          try{
//              while(rs.next()){
//                  return true;
//              }
//          }catch(SQLException ex){
//              ex.printStackTrace();
//              return false;
//          }finally{
//              SDBManager.closeObj();
//          }
//         return false;
//    }

    public boolean isInof(String id){
        SDBManager.ConnToDB();
        String sql = "delete from client where cid = '"+id+"'";
        int num = SDBManager.executeUpdate(sql);
        SDBManager.closeObj();
        if(num > 0){
            return true;
        }else{
            return false;
        }
    }

    /**
     * 接收增加的數據信息
     * @param id String 編號
     * @param name String 姓名
     * @param client String 客戶類型
     * @param sexs String 客戶性別
     * @param age String 年齡
     * @param phone String 電話
     * @param add String 地址
     * @param date String 日期
     * @param remark String 備注
     * @return ArrayList
     */
    public ArrayList add(String id,String monye,String discut,String area,String name,String type,String sex,String age,String phone,String date,String place,String remark){
        SDBManager.ConnToDB();
        String sql = "insert into client values('"+id+"','"+name+"','"+type+"','"+monye+"','"+discut+"','"+area+"','"+sex+"','"+age+"','"+phone+"','"+place+"','"+date+"','"+remark+"') ";
        SDBManager.executeUpdate(sql);
        SDBManager.closeObj();
        return arraylist;

    }
    /**
     * 接收用戶輸入的修改信息
     * @param id String 編號
     * @param name String 姓名
     * @param client String 客戶類型
     * @param sex String 姓名
     * @param age String 年齡
     * @param phone String 電話
     * @param add String 地址
     * @param date String 日期
     * @param remark String 備注
     * @return ArrayList
     */
    public ArrayList amend(String id,String name,String client,String sex,String age,String phone,String add,String date,String remark){
        SDBManager.ConnToDB();
        String sql="update client set cid='"+id+"',cname ='"+name+"',cclass='"+client+"',csex='"+sex+"',cage='"+age+"',cphone='"+phone+"',caddress='"+add+"',cdate='"+date+"',cremark='"+remark+"' where cid='"+id+"'";
        SDBManager.executeUpdate(sql);
        SDBManager.closeObj();
        return arraylist;
    }

    /**
     * 接收擁護輸入的編號（刪除）
     * @param id String
     * @return ArrayList
     */
    public ArrayList delete(String id){
        SDBManager.ConnToDB();
        String sql = "delete client where cid='"+id+"' ";
        SDBManager.executeUpdate(sql);
        SDBManager.closeObj();
        return arraylist;
    }
}