1,105,371 Community Members

jsp code for values from database to textbox

Member Avatar
vasudha k
Newbie Poster
17 posts since Feb 2007
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Can anyone help me out ?.......
I have written a code for a form. the first five fileds in the form must be filled automatically by capturing the user id from login page.
I have been able to capture the data and print it on the screen
But, Iam not able to put those values in the textbox
Iam pastin the copy of my code.................
Please help me out ................

Iam getting an exception when i write value=<%=id%> for the text box value . It says id is not declared

<%@ page language="java" %>
<%@ page import="javax.servlet.*" %>
<%@ page import="javax.servlet.http.*" %>
<%@ page import="java.sql.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
</HEAD>
<%
String id , name , dept, desig,band;
String username=(String) session.getAttribute("theName");
if(username==null) username="";
try {
       Class.forName("oracle.jdbc.driver.OracleDriver");
    Connection con=DriverManager.getConnection("jdbc:oracle:thin:@192.168.150.252:1521:xdevload","xius","xius");
        out.println("connection established");
  String s ="select emp_id , emp_name ,emp_dept_id, emp_desig_id, band_id from employee_master where emp_id=(select user_id from user_master where user_name='"+username+"')";
     Statement stmt = con.createStatement();
  ResultSet rs=stmt.executeQuery(s);
  out.println("data retrieved");
  while(rs.next())
 {
       id = rs.getString(1);
    name=rs.getString(2);
    dept=rs.getString(3);
    desig=rs.getString(4);
    band=rs.getString(5);
    out.println(id+" "+name+" "+dept+" "+desig+" "+band);

 }
 }
catch(Exception e)
{
}
%>
<!--
<BODY>
<center>
<form name="form1">
EMP ID <input type="text" name="text1">
<br>
EMP name <input type="text" name="text2">
<br>
EMP designatiom <input type="text" name="text3">
</form>
</center>
</BODY>-->
</HTML>
Question Self-Answered as of 7 Years Ago
Member Avatar
peter_budo
Code tags enforcer
7,935 posts since Dec 2004
Reputation Points: 2,502 [?]
Q&As Helped to Solve: 1,028 [?]
Skill Endorsements: 66 [?]
Moderator
Featured
 
0
 

JSP is very bad choise for setting connection to database you better do it in servlet/front controler

then in JSP just say

<textarea rows="10" cols="30"> <%=stringToDisplay%></textarea>
Member Avatar
karpaklu
Newbie Poster
10 posts since Jul 2009
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

JSP is very bad choise for setting connection to database you better do it in servlet/front controler

then in JSP just say

<textarea rows="10" cols="30"> <%=stringToDisplay%></textarea>

hello peter
i just tried with the above statement to set value inside the textbox,
but wats happening is the value is been displayed outside the textbox.can u help me?

thanks in advance

Member Avatar
peter_budo
Code tags enforcer
7,935 posts since Dec 2004
Reputation Points: 2,502 [?]
Q&As Helped to Solve: 1,028 [?]
Skill Endorsements: 66 [?]
Moderator
Featured
 
0
 

hello peter
i just tried with the above statement to set value inside the textbox,
but wats happening is the value is been displayed outside the textbox.can u help me?

thanks in advance

Maybe I can help if you post your code...

Member Avatar
raj_predators@y
Newbie Poster
1 post since Mar 2010
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Maybe I can help if you post your code...

you have to use the values tag in the text area for setting the textboxes.

eg

<input type=text values=<%=string%> ......

You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article