jsp mysql级联下拉框_实现jsp页面二级下拉框联动，实时读取数据库数据

以下为引用的内容：

//导入相应的包

//这部分代码用于执行查询数据库，返回字符串

if (request.getparameter("findobject")!=null)...{

if (request.getparameter("findobject").equals("hy_dm"))...{

dbconnect conn = null;

resultset rs = null;

try...{

out.print("");

string sql = "select * from dm_hy group by left(hy_dm,7)";

conn = new dbconnect();

conn.setpstmt(sql);

rs = conn.executequery(sql);

while(rs.next())...{

out.print(""+rs.getstring("hy_mc")+"");

}

out.print("");

}

catch (exception e)...{

}

finally...{

try...{

if (rs != null)

rs.close();

if (conn != null)

conn.close();

}

catch (exception e)...{

e.printstacktrace();

}

}

}

if (request.getparameter("findobject").equals("hymx_dm"))...{

dbconnect conn = null;

resultset rs = null;

try...{

out.print("");

string sql = null;

if (request.getparameter("initvalue").equals(""))...{

sql = "select * from dm_hy";

}

else...{

sql = "select * from dm_hy where hy_dm like '"+request.getparameter("initvalue")+"%'";

}

conn = new dbconnect();

conn.setpstmt(sql);

rs = conn.executequery(sql);

while(rs.next())...{

out.print(""+rs.getstring("hy_mc")+"");

}

out.print("");

}

catch (exception e)...{

}

finally...{

try...{

if (rs != null)

rs.close();

if (conn != null)

conn.close();

}

catch (exception e)...{

e.printstacktrace();

}

}

}

return;

}

%>

//导入两个js文件

所属行业：

所属明细行业：

findobject("hy_dm","");

findobject("hymx_dm","");//这两条是页面执行是调用