jsp code for values from database to textbox

 
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 8 Years Ago
 
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>
 
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

 
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...

 
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%> ......

 
-1
 

I am designing an Employee registration form.I'm having 3 textfields(empid, emp name,emp salary).In employee registration form I've to do 4 operations(add, delete, update,view),I've done add and view operations successfully. Now I want to do udpate and delete operation.In delete operation if I give empid then it must automatically display the values of its corresponding two fields (ie emp salary and emp name) from database.How to do query for in delete and update operation.please help me!!!

 
0
 

don't hijack 5 year old threads to hang your own question at the end.

You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: