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

/***********************************
 *                                 *
 *       查詢數(shù)據(jù)庫(kù)返回?cái)?shù)組        *
 *                                 *
 ***********************************/
 
 public class getObject
 {  
    static Connection con;
    static String sql;
    static Statement stmt;
    static ResultSet rst;
    static Vector vect;
    static Vector rec_vector;
    static int t;
    
    public static boolean isFound(String sqlstr){
      try{
      	t=0;
    	sql=sqlstr;
    	con=DriverManager.getConnection(phonenum.getConnection());
    	Statement stmt=con.createStatement();
    	ResultSet rs=stmt.executeQuery(sqlstr);
    	while(rs.next())
    	    t++;
    	}
      catch(Exception e){
      	e.printStackTrace();
      }		
      if(t>0)
    	return true;
      else return false;  
    }
    
    public static String getSql(){
    	return sql;
    }
    
    public  static void setSql(String sqlin){
    	sql=sqlin;
    }
    
    public Object getValueAt(int row,int column){
         if(!vect.isEmpty())
            return  ((Vector)vect.elementAt(row)).elementAt(column);
         else
            return null;}//取得單元格中的屬性值

    
    public static Vector getVect(Connection con,String sql){
    	vect=new Vector();
    	vect.removeAllElements();
    	try{
      	   stmt=con.createStatement();
	       rst=stmt.executeQuery(sql);
    	   while(rst.next()){
              rec_vector=new Vector();
              rec_vector.addElement(rst.getString(1));
              rec_vector.addElement(rst.getString(2));
              rec_vector.addElement(rst.getString(3));
              rec_vector.addElement(rst.getString(4));
              vect.addElement(rec_vector);
              }
           
              rst.close();
    	      stmt.close(); 
              con.close();
        }
        
        catch(Exception e){
      	      e.printStackTrace();
        }
        
        return vect;
    } 
    
   public getObject(Connection c,String sqlin){
 	try{	
 		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 		con=c;
 		sql=sqlin;
 		}
	    catch(Exception e){e.printStackTrace();}
    }
}