Hi Friends,
Thanks for your valuable responses.
But friends sad to say still I’m in same issue. My codes are
here please look in to this, where I missed.
In My Servlet .
ResultSet rs = stmt.executeQuery("SELECT UsrName, PWord, FullName, SAPNo,
eMail FROM tbllogin WHERE UsrName='" +lgNam+"'and PWord='"+lgPas+"'");
if (rs.next()) {
String stFullName =
rs.getString("FullName");
request.setAttribute("fullname",stFullName);
In My JSP
<%
String sUserName = (String)request.getAttribute("fulllname");
out.println("Name : " + sUserName );
%>
But result is Name : null
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 ü
From: [email protected]
[mailto:[email protected]] On Behalf Of
jitesh dundas
Sent: Tuesday, August 24, 2010 12:18 PM
To: [email protected]
Cc: [email protected];
[email protected]
Subject: Re: [java ee programming] Servlet Error
There is one issue in this suggestion my friend...
On Tue, Aug 24, 2010 at 9:27 AM, Ramesh K <[email protected]>
wrote:
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 );
if you print something just before a sendRedirect call, then your servlet
might throw you an error and ofcourse stop processing..so please avoid using
print stmts with redirect callls..
good suggestion though. Nelson my friend, you need to learn from the
tutorials and practise..else you will not be able to gain your skills as
needed..
Java COmplete Reference by Herbert Schildt
Servelts by Dustin Callaway
Java Tutorial on oracle.com
Hope this helps.Please try all the suggestions in this thread and let us
know if needed...
Thanks,
jd
On Mon, Aug 23, 2010 at 5:14 PM, Nelson Rodrigo - LHQ
<[email protected]> 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
[email protected]
To unsubscribe from this group, send email to
java-ee-j2ee-programming-with-passion+unsubscr...@googlegroups.com
<mailto:java-ee-j2ee-programming-with-passion%[email protected]
>
For more options, visit this group at
http://groups.google.com/group/java-ee-j2ee-programming-with-passion?hl=en?h
l=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
[email protected]
To unsubscribe from this group, send email to
java-ee-j2ee-programming-with-passion+unsubscr...@googlegroups.com
<mailto:java-ee-j2ee-programming-with-passion%[email protected]
>
For more options, visit this group at
http://groups.google.com/group/java-ee-j2ee-programming-with-passion?hl=en?h
l=en
--
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
[email protected]
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?h
l=en
--
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
[email protected]
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
