jsp passing value
here i want to pass the two value party_code and party_name and load the value in combo box in another jsp page. please give some idea with exact tag
<html>
<head>
<%@ page language="java" import="java.sql.*" %>
<%
Connection connection =null;
String party_code;
String party_name;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
connection = DriverManager.getConnection("jdbc:odbc:sample","sa","pwd");
Statement st = connection.createStatement();
ResultSet rs = st.executeQuery("select * from cust_details");
while(rs.next())
{
party_code = rs.getString(1);
party_name=rs.getString(2);
out.println(party_code);
out.println(party_name);
}
}
catch (Exception e){
System.out.println(e);
}
%>
</head>
</html>
[1394 byte] By [KevinRaja] at [2007-11-26 22:22:07] 