package coursedesign;
import  java.sql.*;
import  java.io.*;
import  java.lang.*;

public class Jdbcconn
{
        private Connection  db=null;
        private Statement  stmt=null;
        ResultSet  result=null;

        public Jdbcconn(){}

        public  void  OpenConn(String dsn,String uid,String pwd)  throws  Exception
        {
                try  {
            String strdsn="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName="+dsn;
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
            db=DriverManager.getConnection(strdsn,uid,pwd);
                        }
                catch  (Exception  e)
                        {
                                e.printStackTrace();
                        }
        }

        public  ResultSet  getResults(String  sproc) throws  Exception
      {
              Statement stmt=db.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
              ResultSet result=stmt.executeQuery(sproc);
              result.last();
              return  result;
      }

      public void executeUpdate(String sql)
      {

                            //stmt=null;
            //result=null;
               try
                 {
                        stmt=db.createStatement();
                        stmt.executeQuery(sql);
                        stmt.close();
                        stmt=null;
                  }
                catch(SQLException ex)
                  {
                         System.err.println("aq.executeQuery: " + ex.getMessage());
                  }
       }


      public void closeStmt()
      {
             try
               {
                     stmt.close();
               }
             catch(SQLException e)
               {
                     e.printStackTrace();
               }
       }

      public void closeConn()
      {
             try
               {
                      db.close();
               }
             catch(SQLException e)
               {
                    e.printStackTrace();
               }
      }


}