package cr;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DBConn {
    private Connection conn;
    private Statement stmt;
    private ResultSet rs;

    Connection getConn(){
            try {
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                conn = DriverManager.getConnection("jdbc:odbc:sun");
                return conn;

            } catch (ClassNotFoundException ex) {
                return null;
            } catch (SQLException ex) {
            /** @todo Handle this exception */
            return null;
        }

    }

    public ResultSet execQuery(String strSQL){
        Connection conn=getConn();
        try {
            stmt = conn.createStatement();
            rs = stmt.executeQuery(strSQL);
            return rs;
        } catch (SQLException ex) {
            return null;
        }

    }

    public int execOther(String strSQL){

        int count = 0;
        Connection conn=getConn();
        try {
            stmt = conn.createStatement();
            count = stmt.executeUpdate(strSQL);
            return count;
        } catch (SQLException ex) {
            return -1;
        }

    }

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		DBConn dbconn = new DBConn();
		Connection conn=dbconn.getConn();
		if(conn == null){
			
			System.out.println("Connection is error");
		}else{
			System.out.println("connection is OK");
			//在這里創建frame，連接到你想連的窗口界面。
			new LoginWindow();
		}

		ResultSet rs = dbconn.execQuery("select * from login");
		try {
			while(rs.next()){
				System.out.println(rs.getInt(1));
				System.out.println(rs.getString(2));
				System.out.println(rs.getString(3));
				System.out.println(rs.getString(4));
				System.out.println(rs.getShort(5));
				System.out.println(rs.getString(6));
				System.out.println(rs.getString(7));
				System.out.println(rs.getString(8));
				System.out.println(rs.getString(9));
				System.out.println(rs.getString(10));
				System.out.println(rs.getInt(11));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

}