 |  |  |  |  |  |  |  |
jsp code for values from database to textbox
Please support our JSP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Thread Solved |
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>
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>
•
•
Join Date: Dec 2004
Posts: 4,285
Reputation: 
Solved Threads: 494
JSP is very bad choise for setting connection to database you better do it in servlet/front controler
then in JSP just say
then in JSP just say
JSP Syntax (Toggle Plain Text)
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
•
•
•
•
Originally Posted by 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
JSP Syntax (Toggle Plain Text)
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
•
•
Join Date: Dec 2004
Posts: 4,285
Reputation:
Solved Threads: 494
•
•
•
•
Originally Posted by karpaklu
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
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
 |
Similar Threads
- Will the jsp code will change if we connected to the oracle database ? (JSP)
- jsp code to send values to database (JSP)
- insert values to mysql database (JSP)
- Please help(Problem in insertion data to database) (JSP)
Other Threads in the JSP Forum
- Previous Thread: Red5 and MySQL
- Next Thread: package javax.servlet does not exist :>
Views: 8799 | Replies: 3
| Thread Tools | Search this Thread |
Latest JSP Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for JSP
apache array backbutton combobox comma connection csv database development directorystructure dropdownlist dynamicpagetitles eclipse frames glassfish ie8 imagetodatabse imageupload integer internet java javaee javascript jsf jsp jsppagetitles levels mvc2 mvcmodel2 mysql netbeans network parameters passing ping printinserverinsteadofclient project read redirect request.getparameter response seperated servlet servletdopost()readxml sessions software sql ssl state_saving_method stocks sun tomcat tutorial update values video web write
