package com.tool;
import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.DriverManager;
public class JDBCConnection {
  ResultSet rs=null;
  Statement sql=null;
  Connection conn=null;
  public JDBCConnection() {
    try
    {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
    catch(ClassNotFoundException ex)
    {
      ex.printStackTrace();
    }
  }
  private Connection getConnection()
  {
    try
    {
     conn=DriverManager.getConnection("jdbc:odbc:student");
    }
    catch(SQLException ex)
    {
      ex.printStackTrace();
    }
    return conn;
  }
  public ResultSet excuteQuery(String s)
  {
    try
    {
     sql= this.getConnection().createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
     rs=sql.executeQuery(s);
     return rs;
    }
    catch(SQLException ex)
    {
      ex.printStackTrace();
    }
    return null;
  }
  public boolean excuteUpdate(String s)
  {
    try
    {
     sql= this.getConnection().createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
    sql.executeUpdate(s);
     return true;
    }
    catch(SQLException ex)
    {
      ex.printStackTrace();
    }
    return false;
  }
public void close()
  {
    try
    {
      conn.close();
      sql.close();
      rs.close();
    }
    catch(SQLException ex)
    {
      ex.printStackTrace();
    }
  }


}