text box can't get local variable value in jsp retrieved from the database

Question

I am interested in getting out the value from the DATABASE and get it into textbox value property, here is my code:

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<%@ page import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Update Your Data</title>
</head>
<body>
    <%! ResultSet rs; %>
    <%! Connection con;%>
    <%! PreparedStatement pstmt;%>
    <%! String sql = "SELECT * FROM USERS WHERE USERNAME = ?"; %>
    **<%! String unm,pwd; %>**
<h3>Update Your Details</h3>
<hr/>

<form action="UpdateSrvlt" method="post">
    <%
        try{
        Class.forName("com.mysql.jdbc.Driver");
        }catch(ClassNotFoundException cnfe){
            System.out.println("Error :"+cnfe.getMessage());
        }
        try{
        con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","");
        pstmt = con.prepareStatement(sql);
        pstmt.setString(1,request.getParameter("username"));
        rs = pstmt.executeQuery();
        while(rs.next()){
            **unm = rs.getString("username");**
            System.out.println("Username at Update.jsp: "+unm);
            **pwd = rs.getString("password");**
            System.out.println("Password at Update.jsp: "+pwd);

        }
        }catch(SQLException se){
            System.out.println("Error :"+ se.getMessage());
        }       
    %>
    <table>
        <tr>
            <td align="left">
                Username :
            </td>
            <td align="left">

                <input type="text" name="username" value="${unm}"/>
            </td>
        </tr>
        <tr>

            <td align="left">
                Password :
            </td>
            <td>
                <input type="text" name="password" value="${pwd}"  />
            </td>
        </tr>

        <tr>
            <td><input type="submit" value="Update" /></td>
        </tr>
        <%
            pstmt.close();
            con.close();
        %>
    </table>
    </form>
</body>
</html>

Anybody know the reason what is the reason for getting null..inspite of getting variable value.

I am getting querystring value on the page.. and i even got the value when i am printing them on server side but some how i can't get the value in the tag value. — Zealous, Feb 03 '14 at 08:06

Bhushan · Answer 1 · 2014-02-04T04:26:22.943

0

Try this:

<body>
<%! 
    String unm="", pwd="";
%>
<form>
<%
    //your code to get userName and password here
    pageContext.setAttribute("unm", unm);
    pageContext.setAttribute("pwd", pwd);
%>
<input type="text" name="username" value="${unm}"/>
<input type="text" name="password" value="${pwd}"/>
</form>
</body>

edited Feb 04 '14 at 04:26

answered Feb 03 '14 at 08:05

Bhushan

6,151
13
58
91

I am getting null values..in these two textboxes. via any of the method. Earlier I have tried out the second one and I got the null printed in the textboxes. – Zealous Feb 03 '14 at 15:03
@Zealous Please have a look at update, I have tested it, and its working. – Bhushan Feb 04 '14 at 04:27

score 0 · Answer 2 · answered Feb 03 '14 at 09:01

0

<input type="text" name="username" value="<%=unm%>"/>
<input type="text" name="password" value="<%=pwd%>"/>

answered Feb 03 '14 at 09:01

Saurabh Kachhia

300
3
12

I got null printed in my textboxes. and yes, Thanks for your reply..! – Zealous Feb 03 '14 at 15:06
You are getting NULL because of `pstmt.setString(1,request.getParameter("username"));` – Saurabh Kachhia Feb 04 '14 at 06:34

text box can't get local variable value in jsp retrieved from the database

2 Answers2