public   class  Users_cl {

           private  Statement statement;
           private  Connection connection;

      public  Users_cl()  throws  SQLException {
               String url= "jdbc:oracle:thin:@server_name:1521:Base";
               String DRIVER = "oracle.jdbc.driver.OracleDriver";
              try  {
                            Class .forName(DRIVER);
                         }
                          catch  (Exception e) {
                            throw   new  RuntimeException(e.getMessage());
                         }
        connection = DriverManager.getConnection(url, "user", "pass");
        statement = connection.createStatement ();
         }


     public   void  doGet (HttpServletRequest req, HttpServletResponse resp)  throws  IOException, ServletException {


        ResultSet result =  null ;
     try  {
        result = statement.executeQuery("select * from table");

        HttpSession session = req.getSession();
        session.setAttribute("resultScr", result);

    }  catch  (SQLException e) {
        e.printStackTrace();
    }

    req.getRequestDispatcher("index.jsp").forward(req,resp);

}
}