java - Validation Required Before Loading jsp -
i have 1 scenario want validation before welcome.jsp page loaded. validation have user id (using request.getremoteuser) want check in db whether there or not. if yes, want redirect page login.jsp. if not, redirect welcome.jsp. have declare 1 servlet (checkuser.java) calling dopost doget , included same servlet in welcome.jsp before loading doget invoke.
**checkuser.java** package dbresource; import java.io.ioexception; import java.io.printwriter; import java.sql.connection; import java.sql.preparedstatement; import java.sql.resultset; import java.sql.sqlexception; import java.util.logging.level; import java.util.logging.logger; import javax.servlet.requestdispatcher; import javax.servlet.servletconfig; import javax.servlet.servletexception; import javax.servlet.http.httpservlet; import javax.servlet.http.httpservletrequest; import javax.servlet.http.httpservletresponse; public class checkuser extends dbconnection { string page="listprojects.jsp"; public connection conn= null; // happens once , reused @override public void init(servletconfig config) throws servletexception { super.init(config); } public boolean searchuser(string usrid) throws sqlexception{ try{ // establishing connection using data source conn=ds.getconnection(); preparedstatement stmt=conn.preparestatement("select * oss_user user_email='"+usrid+"'"); resultset rs = stmt.executequery(); boolean hasresult = rs.next(); return hasresult; } catch (exception e){ e.printstacktrace(); return false; } { if (conn != null) conn.close(); } } @override protected void doget(httpservletrequest request, httpservletresponse response) throws servletexception, ioexception { system.out.println("on checkuser doget..........."); dopost(request,response); } @override protected void dopost(httpservletrequest request, httpservletresponse response) throws servletexception, ioexception { system.out.println("on checkuser dopost.........."); //string usrid= request.getremoteuser(); string usrid= "abc@tr.com"; contextpath = request.getcontextpath(); page = "/listprojects.jsp"; try { boolean susr = searchuser(usrid); if (susr==true) { response.sendredirect(contextpath + "/listprojects.jsp"); } } catch (sqlexception ex) { logger.getlogger(dbconnection.class.getname()).log(level.severe, null, ex); } { if (conn != null) try { conn.close(); } catch (sqlexception ex) { logger.getlogger(dbconnection.class.getname()).log(level.severe, null, ex); } } } /** * returns short description of servlet. * * @return string containing servlet description */ @override public string getservletinfo() { return "short description"; }// </editor-fold> }
welcome.jsp
<body> <jsp:include page="/checkuser" flush="true" />
this issue resolved using beans & scriptlet. in jsp page have import java class(storeusrdetails) , declare jsp use bean (storeusr).
in jsp page
<%@page import="com.thomsonreuters.alpaca.storeusrdetails" %> <jsp:usebean id="storeusr" class="com.thomsonreuters.alpaca.storeusrdetails" scope="request" /> using bean call method inside java method (validateuser) returns wheather user details present in database or not. after have written scriplet code @ start of jsp body. , based on retun value of validateuser method redirect them page.
jsp body
<body> <% if(storeusr.validateuser(request.getremoteuser())) response.sendredirect("listprojects.jsp"); %>
Comments
Post a Comment