Hi Nelson Rodrigo,
after retrieving the FullName from Database you have to store it in
any one of these scopes:
request,session or application
like
*if* (rs.next()) {
String *stFullName* = rs.getString("FullName");
//add this line to your code
response.setAttribute("fullname",stFullName);
response.sendRedirect("MainFrame.jsp");
}
*In JSP use Like this
*
//typecast the Object into String
String sUserName = (String)request.getAttribute("fulllname");
out.println("Name : " + sUserName );
On Mon, Aug 23, 2010 at 5:14 PM, Nelson Rodrigo - LHQ <
nelson.rodr...@loadstarlk.com> wrote:
>
>
> Dear Friends
>
> Hi Friends
>
>
>
> *In my login servlet I have use as follows*
>
> ResultSet rs = stmt.executeQuery("SELECT UsrName, PWord, FullName, SAPNo,
> eMail FROM tbllogin WHERE UsrName='" +lgNam+"'and PWord='"+lgPas+"'");
>
>
>
> *And if success I want to use those db values to my jsp*
>
> *if* (rs.next()) {
>
> String *stFullName* = rs.getString("FullName");
>
>
>
> response.sendRedirect("MainFrame.jsp");
>
>
>
> } *else* {
>
>
>
> *In JSP I have use*
>
> String sUserName = request.getParameter("stFullName");
>
> out.println("Name : " + sUserName );
>
>
>
> but result is null
>
> what happened? Where I missed?
>
>
>
> Thanks & Kind Regards,
>
> Nelson Rodrigo
> Executive – Software Development
> *LOADSTAR (PRIVATE) LIMITED
> *Sri Lanka | Tel: +94 11 483 7914 | Fax: +94 11 224 0892 | Mobile: +94 77
> 311 6556
>
> P *SAVE PAPER* - *Please consider our environment before printing *ü
>
>
>
> --
> You received this message because you are subscribed to the Google
> Groups "Java EE (J2EE) Programming with Passion!" group.
> To post to this group, send email to
> java-ee-j2ee-programming-with-passion@googlegroups.com
> To unsubscribe from this group, send email to
> java-ee-j2ee-programming-with-passion+unsubscr...@googlegroups.com<java-ee-j2ee-programming-with-passion%2bunsubscr...@googlegroups.com>
> For more options, visit this group at
>
> http://groups.google.com/group/java-ee-j2ee-programming-with-passion?hl=en?hl=en
--
Thanks & Regards,
Ramesh K
--
You received this message because you are subscribed to the Google
Groups "Java EE (J2EE) Programming with Passion!" group.
To post to this group, send email to
java-ee-j2ee-programming-with-passion@googlegroups.com
To unsubscribe from this group, send email to
java-ee-j2ee-programming-with-passion+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/java-ee-j2ee-programming-with-passion?hl=en?hl=en
