My jsp program with combo error

jeanhmz · #1 (**permalink**) 08-20-2008

I have a logical error here like that in jsp.

My JSP program is like that. I couldn't extract the data from the database. I want to extract the Department name then put the combo box in jsp program. I want to do like that. But can't. pls help me and suggest me.

<%@ page language="java" import="java.sql.*, java.io.*" %>

<%
Connection con=null;
try
{
String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String connectionUrl = "jdbc:sqlserver://localhost:1433;" + "databaseName=Raffles;user=sa;password=raffles;";

Class.forName(driver);
con = DriverManager.getConnection(connectionUrl);

Statement statement = con.createStatement();
ResultSet rs = statement.executeQuery("SELECT * FROM RaffleDept");
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<style type="text/css">


</style>

<style type="text/css">

</style>

<SCRIPT SRC="Scripts/ssm.js" language="JavaScript1.2">

//Dynamic-FX slide in menu v6.5 (By maXimus, http://maximus.ravecore.com/)
//Updated July 8th, 03' for doctype bug
//For full source, and 100's more DHTML scripts, visit Dynamic Drive DHTML(dynamic html) & JavaScript code library

</SCRIPT>

</head>
<body>

<form method="post" name="RafflesUsers" class="style1" action="RafflesVessel.jsp">

<table width="1246" height="180" border="0" cellpadding="0" cellspacing="0">

<tr>
<td width="1246" height="161" valign="top"><img src="images/Banner.jpg" width="1246" height="184">

</td>
</tr>

</table>


<table width="1245" border="0" cellpadding="0" cellspacing="0">

<tr>
<td height="250" valign="middle">

<fieldset class="style1" style="border-color:#418BFA; border-width:thin">

<table width="668" height="211" border="0" cellspacing="3">
<tr>
<td width="86">Vessel Name </td>
<td width="569"><input name="txtvessel" type="text" id="txtvessel" size="60"></td>
</tr>
<tr>
<td>Dept Name </td>
<td>

<select name="cbodeptname" id="cbodeptname">
<%
while ( rs.next() ) {
%>
<option value= <%= rs.getString("DeptName")%>></option>
<% }
rs.close();
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if ( con != null ) {
con.close();
}
} catch (SQLException sqle) {
out.println(sqle.getMessage());
}
}
%>
</select>

</td>
</tr>
<tr>
<td>Remarks</td>
<td><textarea name="txtremark" id="txtremark"></textarea></td>
</tr>
<tr>
<td height="62"> </td>
<td>
<div align="left">
<input type="submit" name="Submit" value="Submit">
</div></td></tr>
</table>
</fieldset></td>
</tr>
</table>

</form>

</body>
</html>

it_uday · #2 (**permalink**) 10-16-2008

Here I use oracle database.I have a dbConnection.jsp file.I include that file in my current jsp page.say my current jsp page name is Test.jsp.In this page I fetch Qualification from database and display it in combo box.

<%@include file="dbConnection.jsp"%>
<html>
<head>
<title>Test Page</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#FFFFFF" text="#000000">
<form name="form1" method="post" action="">
<table width="100%" border="0">
<tr>
<td width="38%">
<div align="right"><b>Qualification </b></div>
</td>
<td width="2%"> </td>
<%
String sql="select QUALIFICATION from TEST_DIPA_QUALIFICATION";
PreparedStatement prep=con.prepareStatement(sql);
ResultSet rs=prep.executeQuery();

%>
<td width="60%">
<select name="qual">
<option value="" selected>---select---</option>
<%
while(rs.next())
{
String strQualification=rs.getString(1);
System.out.println(strQualification);
%>
<option value=""><%=strQualification%></option>

<%
}
%>
</select>
</td>
</tr>
<tr>
<td width="38%"> </td>
<td width="2%"> </td>
<td width="60%"> </td>
</tr>
</table>
</form>
</body>
</html>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Error while recording Combo Box	bapuji6	QTP	1	10-26-2007 07:36 AM
Sorting and Editing Dropdown Combo	sweetychinnu	ASP.NET	1	10-19-2007 05:23 AM
BDC program of KP06 gives error	Geek_Guest	SAP R/3	0	06-04-2007 11:40 PM
combo in jsp	vmshenoy	JSP	4	03-19-2007 12:07 PM
Select a different value from the combo box	JobHelper	WinRunner	1	12-26-2006 11:17 AM

My jsp program with combo error

My jsp program with combo error

Similar Threads