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","");//这两条是页面执行是调用