package Irey;
import java.sql.*;
import java.util.*;public class mxsm{
        String sDBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
       Connection Conn=null;
        ResultSet rs=null;
        Statement stmt=null;
        int mm;
        java.util.Date date;
        CallableStatement cstmt=null;
        public mxsm(){
    try{
                       Class.forName(sDBDriver).newInstance();
   DBConnectionPool pool=new DBConnectionPool("dbc","jdbc:microsoft:sqlserver://192.168.1.1:1433;DatabaseName=mxsm","liu","2108",0);
                       Conn=pool.getConnection();
                  stmt=Conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
                       date=new java.util.Date();
                       mm=date.getMonth()+1;
                       }catch(Exception e){}
                      }
        public ResultSet executeQuery(String SQL){
                      try{
                      if(mm<=2){
                        rs=stmt.executeQuery(SQL);
                                }                                  
                         }catch(Exception e){}              
                          return rs;
                      }
       public void executeUpdate(String s){
                                   try{
                               stmt.executeUpdate(s);
                          }catch(Exception e){}
                                          }
       public void procedureUpdate(String pp){
                                       try{
                             cstmt = Conn.prepareCall(pp);
                             cstmt.executeUpdate();
                             cstmt.close();
                             Conn.close();
                                           }catch(Exception e){}
                               }
        public void Close(){
                                       try{
                               stmt.close();
                               Conn.close();
                          }catch(Exception e){}
                                }
                                }