The SQLConnect servlet

public class SQLConnect extends HttpServlet {

. . .

public void doPost(HttpServletRequest req,

HttpServletResponse resp) throws . . . {

try {

String username = req.getParameter(“username”) ;

String password = req.getPassword(“password”) ;

HttpSession session = req.getSession(true) ;

Connection conn =

DriverManager.getConnection(url, username, password) ;

session.setAttribute(“connection”, conn) ;

resp.sendRedirect(

resp.encodeRedirectURL(“/dbc/servlet/SQLCommand”)) ;

} catch (SQLException e) {

. . . make suitable sendError() call . . .

}

}

}

Previous slide

Next slide

Back to first slide

View graphic version