import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;

public class SQLConnect extends HttpServlet {

    String url = "jdbc:oracle:thin:@sirah.csit.fsu.edu:1521:oralin";

    public void init() {
        System.setProperty("jdbc.drivers", "oracle.jdbc.driver.OracleDriver");
    }

    public void doPost(HttpServletRequest request,
                       HttpServletResponse response)
        throws IOException, ServletException {

        try {
            String username = request.getParameter("username") ;
            String password = request.getParameter("password") ;

            HttpSession session = request.getSession(true) ;

            Connection conn =
                  DriverManager.getConnection(url, username, password);

            session.setAttribute("connection", conn) ;
            session.setMaxInactiveInterval(600) ;  // 10 minutes.

            response.sendRedirect(
                  response.encodeRedirectURL("/dbc/servlet/SQLCommand"));
        } catch (SQLException e) {
            response.sendError(HttpServletResponse.SC_OK,
                               "Failed to make connection: " + e.getMessage()) ;
        }
    }
}