New Topic/Question
Reply
I am writing the code how i have linked the 2 dropdown menus.
<%@page contentType="text/html" pageEncoding="UTF-8" import="java.sql.*"%>
office_name.jsp
<html>
<head>
<script language="javascript" type="text/javascript">
var xmlHttp
var xmlHttp
function showState(str){
if (typeof XMLHttpRequest != "undefined"){
xmlHttp= new XMLHttpRequest(); }
else if (window.ActiveXObject){
xmlHttp= new ActiveXObject("Microsoft.XMLHTTP");
}
if (xmlHttp==null){
alert("Browser does not support XMLHTTP Request")
return; }
var url="dep_name.jsp";
url +="?count=" +str;
xmlHttp.onreadystatechange = stateChange;
xmlHttp.open("GET", url, true);
xmlHttp.send(null); }
function stateChange(){
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete"){
document.getElementById("dep_name").innerHTML=xmlHttp.responseText}}
<%--function selValue()
{
var mytext = document.form.sel.options[document.form.sel.selectedIndex].text;
document.getElementById('lab').style.visibility="visible";
document.getElementById('val').style.visibility="visible";
document.form.val.value=mytext;
}--%>
</script>
</head>
<body>
<select name="officename" onchange="showState(this.value);">
<%--<option value="select">Select</option>--%>
<%Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c = DriverManager.getConnection("jdbc:odbc:jsw");
Statement stt=c.createStatement();
ResultSet rss=stt.executeQuery("Select * from office_name");
while(rss.next()){ %>
<option value="<%=rss.getInt("officenameid")%>"><%=rss.getString("officename")%></option> <% } %>
</select> <br> <%--<div id='dep_name'>
<select name='dep_name' >
<option value='-1'></option>
</select>
</div>--%>
</body>
</html>
dep_name.jsp
<%@page contentType="text/html" pageEncoding="UTF-8" import="java.sql.*"%>
<%String office_name=request.getParameter("count");
int id=Integer.parseInt(office_name);
String buffer="<select name='dep_name'>";
try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:jsw");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("Select * from dep_name where officenameid="+id+" ");
while(rs.next()){ buffer=buffer+"<option value='"+rs.getInt("depnameid")+"'>"+rs.getString("depname")+"</option>"; }
buffer=buffer+"</select>";
response.getWriter().println(buffer); }
catch(Exception e){ System.out.println(e); } %>
MultiQuote
| 