package cg;

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

public class DatabaseUser{
	
    private Connection con;
    
    public DatabaseUser(){
    	
        con = getConnection();     
    }
    
    
    private Connection getConnection(){
    	
        Connection conn = null;
        try{
        	
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            conn = DriverManager.getConnection("jdbc:odbc:myOdbc", "sa", "");
        }
        catch (ClassNotFoundException cnfe){
        	
            cnfe.printStackTrace();
        }
        catch (SQLException sqle){
        	
            sqle.printStackTrace();
        }
        
        return (conn);
    }
    
    public Vector<String> getColumnNamesByTabname(){
    	
        Vector<String> cols = new Vector<String>();
        try{
        	
            Statement sta = con.createStatement();
            String strSql = "SELECT * FROM [user] WHERE 1=2";
            ResultSet rs = sta.executeQuery(strSql);
            ResultSetMetaData rsmd = rs.getMetaData();
            int colCount = rsmd.getColumnCount();
            
            for (int i = 1; i <= colCount; i++){
            	
                cols.add(rsmd.getColumnName(i));
            }
            rs.close();
            sta.close();
        }
        catch (SQLException sqle){
        	
            sqle.printStackTrace();
        }
        
        return (cols);
    }
    
    public Vector<Object> getDataByTabname(){
    	
        Vector<Object> data = new Vector<Object>();
        try{
        	
            Statement sta = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                                                ResultSet.CONCUR_READ_ONLY);
            String strSql = "SELECT * FROM [user]";
            ResultSet rs = sta.executeQuery(strSql);
            int cols = rs.getMetaData().getColumnCount();
            
            while (rs.next()){
            	
                Vector<Object> vec = new Vector<Object>();
                for (int i = 1; i <= cols; i++){
                	
                    vec.add(rs.getObject(i));
                }
                data.add(vec);
            }
            rs.close();
            sta.close();
        }
        catch (SQLException sqle){
        	
            sqle.printStackTrace();     
        }
        
        return (data);
    }
    

    
    public Vector<String> getAllTabelName(){
    	
        Vector<String> vec = new Vector<String>();
        try
        {
            Statement sta = con.createStatement();
            String strSql = "select 用戶名 from [user]";
            ResultSet rs = sta.executeQuery(strSql);
            while (rs.next())
            {
                vec.add(rs.getString("用戶名"));
            }
            rs.close();
            sta.close();
        }
        catch (SQLException sqle)
        {
            sqle.printStackTrace();
        }
        
        return (vec);
    }
    
    public void closeConnection(){
    	
        try{
        	
            con.close();
        }
        catch (SQLException sqle){
        	
            sqle.printStackTrace();
        }
    }
}