/*
 * 創建日期 2008-3-12
 *
 * TODO 要更改此生成的文件的模板，請轉至
 * 窗口 － 首選項 － Java － 代碼樣式 － 代碼模板
 */
package appsm.util;
import java.util.Vector;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import javax.swing.table.DefaultTableModel;
/**
 * @author bjq
 *
 * TODO 要更改此生成的類型注釋的模板，請轉至
 * 窗口 － 首選項 － Java － 代碼樣式 － 代碼模板
 */
public class RetrieveObject {
	  public static PreparedStatement  ps;
	  public static ResultSet rs;
	  public static Connection connection;
    public Vector getObjectRow(String sqlstr){
        Vector vdata=new Vector();
        try{ 
           connection=CommonaJdbc.connection;
           ps=connection.prepareStatement(sqlstr);
           rs=ps.executeQuery();
            ResultSetMetaData rsmd=rs.getMetaData();
            
           while(rs.next()){
               for(int i=1;i<=rsmd.getColumnCount();i++){
                   vdata.addElement(rs.getObject(i));
                   }
               }
           rs.close();
           ps.close();
          
            return vdata;
           
            
           }catch(SQLException sql){
               sql.printStackTrace();
               return null;
               }
      
        }
 
   public DefaultTableModel getTM(String[] name,String sqlStr){
       Vector vname=new Vector();
       for(int i=0;i<name.length;i++){
           vname.addElement(name[i]);
           }
       DefaultTableModel tableModel=new DefaultTableModel(vname,0);
       connection=CommonaJdbc.connection;
       try{
          ps=connection.prepareStatement(sqlStr);
          rs=ps.executeQuery();
           ResultSetMetaData rsmd=rs.getMetaData();
           while(rs.next()){
               Vector vdata=new Vector();
               for(int i=1;i<=rsmd.getColumnCount();i++){
                   vdata.addElement(rs.getObject(i));
                   }
               tableModel.addRow(vdata);
               }
           rs.close();
           ps.close();
           }catch(SQLException sql){
               sql.printStackTrace();
               return null;
               }
           return tableModel;
       }
  /* public Collection getTableCollection(String sqlStr){
   
    Collection collection = new Vector();
    connection= CommonaJdbc.connection;
    try{
    	ps=connection.prepareStatement(sqlStr);
        rs = ps.executeQuery();
        ResultSetMetaData rsmd = rs.getMetaData();
        while(rs.next()){
            Vector vdata = new Vector();
            for ( int i = 1 ; i <= rsmd.getColumnCount() ; i ++){
                vdata.addElement(rs.getObject(i));
            }
            collection.add(vdata);
        }
        rs.close();
        ps.close();
    }catch(java.sql.SQLException sql){
        
        sql.printStackTrace();
        return null;
    }
    return collection;
}*/
  
}