import java.sql.*;
import java.util.Vector;
import sun.jdbc.odbc.*;

public class OdbcConn {
  private String driver ;
  private String url ;
  private String user ;
  private String pwd ;

  private Connection conn = null ;
  private Statement stmt = null ;

  public OdbcConn() {
   
    //JDBC-ODBC??
    driver = "sun.jdbc.odbc.JdbcOdbcDriver" ;
    url = "jdbc:odbc:131.1.6.9:5000/db" ;
    user = "sa" ;
    pwd = "111" ;

    try {
      Class.forName(this.driver) ;

      conn = DriverManager.getConnection(url,user,pwd) ;

      stmt = conn.createStatement() ;
    }
    catch (ClassNotFoundException ex) {
      ex.printStackTrace();
    }
    catch(SQLException ex){
      ex.printStackTrace();
    }
  }
  public Connection getConnection(){
    return this.conn ;
  }
  public boolean  execute(String sql){
    boolean rt = false ;
    try{
      rt = stmt.execute(sql) ;
    }
    catch(SQLException ex){
      ex.printStackTrace() ;
    }
    return rt ;
  }
  public int getSize(String sql){
    int rt = 0 ;
    try {
      rt = stmt.executeUpdate(sql);
    }
    catch (SQLException ex) {
    }
    return rt ;
  }
  public ResultSet executeQuery(String sql){
    ResultSet rt = null ;
    try{
      rt = stmt.executeQuery(sql);
    }
    catch(SQLException ex){
      ex.printStackTrace() ;
    }
    return rt ;
  }
  public int executeUpdate(String sql){
    int rt = 0 ;
    try{
      rt = stmt.executeUpdate(sql) ;
    }
    catch(SQLException ex){
      ex.printStackTrace() ;
    }
    return rt ;
  }
  public void closeConnection(){
    try{
      stmt.close() ;
      conn.close() ;
    }
    catch(SQLException ex){
      ex.printStackTrace() ;
    }
  }
}