Hi,
If might not move the counter to the first record..
'try rs.movefirst or rs.first (check the command as I don't remember that..
then use rs.getString('column name');
like ...
while (rs.next() )
{
rs.first()//check //the command here..
String st = rs.getString('column name');
}
and yes, check if the column type is string..
lastly, try to use session instead of request object to store variable.
Regards,
jd
On 8/25/10, Nelson Rodrigo - LHQ <nelson.rodr...@loadstarlk.com> wrote:
> Hi Jd
> Thanks for your reply.
>
> Why I used > if (rs.next()) { is there are only one value came then no
> need
> to use while statement.
>
> No errors came actually application working I want to use these servlet
> values (db login values) in jsp for validation purpose.
> In this case no values come with variables that is my main issue.
>
>
> 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
> SAVE PAPER - Please consider our environment before printing
>
>
> -----Original Message-----
> From: jitesh dundas [mailto:jbdun...@gmail.com]
> Sent: Wednesday, August 25, 2010 9:05 AM
> To: nelson.rodr...@loadstarlk.com
> Cc: java-ee-j2ee-programming-with-passion@googlegroups.com;
> rameshcharyko...@gmail.com; mearajah...@gmail.com; harshani perera; Ramesh A
> Subject: Re: [java ee programming] Servlet Error
>
> Please check if the values are present in the database I.e. table -tbllogin
>
> Next, please use a while loop,remove if stmt..
>
> PLEASE GIVE THE ERROR STACK TRace that you get..
> use exception handling with try catch block..
>
> regards
> jd
>
> On 8/25/10, Nelson Rodrigo - LHQ <nelson.rodr...@loadstarlk.com> wrote:
>> 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: java-ee-j2ee-programming-with-passion@googlegroups.com
>> [mailto:java-ee-j2ee-programming-with-pass...@googlegroups.com] On Behalf
>> Of
>> jitesh dundas
>> Sent: Tuesday, August 24, 2010 12:18 PM
>> To: nelson.rodr...@loadstarlk.com
>> Cc: rameshcharyko...@gmail.com;
>> java-ee-j2ee-programming-with-passion@googlegroups.com
>> 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 <rameshcharyko...@gmail.com>
>> 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
>> <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
>> <mailto: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?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
>> 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
>> <mailto: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?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
>> 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?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
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
