Member Avatar for vasudha k

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>
Edited by TrustyTony because: fixed formatting
  • 6 Contributors
  • 6 Replies
  • 4K Views
  • 8 Years Discussion Span
  • Latest Post Latest Post by jwenting
Member Avatar for peter_budo

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 for karpaklu

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 for peter_budo

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 for raj_predators@y

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

Member Avatar for javagroup

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

Member Avatar for jwenting

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.