📄 求jsp+sql二级联动菜单！ - 程序开发 - techweb-技术社区 - powered by techweb_com_cn!.htm
字号:
style="FONT-SIZE: 0px; COLOR: #ffffff">tech.techweb.com.cn8C(?)~
k%K$K&I</FONT><BR>分公司名称和用电地点都是在一个表里面，表dfbzb，字段fgs，yddd； <FONT
style="FONT-SIZE: 0px; COLOR: #ffffff">TechWeb-技术社区:x,s'W7C0k9x#N</FONT><BR><BR><SPAN
style="DISPLAY: none">(L"d,m!V9m9o1D</SPAN>这个查询页面要怎么实现? <FONT
style="FONT-SIZE: 0px; COLOR: #ffffff">tech.techweb.com.cn!M;E6u"f*e"c</FONT><BR><BR><SPAN
style="DISPLAY: none">(~!r2?)|/n#}</SPAN>希望能给详细代码，小弟急用，谢谢！</B></DIV><BR><FONT
style="FONT: 12px Tahoma, Verdana; COLOR: #333333"></FONT></TD></TR>
<TR>
<TD align=right><A
href="http://tech.techweb.com.cn/post.php?action=reply&fid=10&tid=247154&repquote=849220&extra=&page=1">引用</A>
<A onclick="fastreply('回复 #1 大腕 的帖子')"
href="http://tech.techweb.com.cn/viewthread.php?tid=247154###">回复</A>
<A onclick=scroll(0,0)
href="http://tech.techweb.com.cn/viewthread.php?tid=247154###"><IMG
alt=顶部
src="求JSP+sql二级联动菜单！ - 程序开发 - TechWeb-技术社区 - Powered by TechWeb_com_cn!.files/top.gif"
border=0></A> </TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></DIV>
<DIV class=spaceborder style="MARGIN-BOTTOM: 4px; WIDTH: 98%">
<TABLE class=t_row cellSpacing=0 cellPadding=6 width="100%" align=center>
<TBODY>
<TR style="HEIGHT: 100%">
<TD class=t_user vAlign=top width="18%"><A name=pid868357></A><SPAN
class=bold>游客</SPAN> <SPAN class=smalltxt></SPAN><BR><SPAN
class=smalltxt>未注册 <BR><BR><BR><BR><BR><BR><BR><BR><BR><BR></SPAN></TD>
<TD
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px"
vAlign=top width="82%">
<TABLE class=t_msg cellSpacing=0 cellPadding=6 border=0>
<TBODY>
<TR>
<TD>
<DIV>
<DIV class="right t_number"><A class=bold title=复制帖子链接到剪贴板
onclick="setcopy('http://tech.techweb.com.cn/viewthread.php?tid=247154&page=1#pid868357', '已经复制到剪贴板')"
href="http://tech.techweb.com.cn/viewthread.php?tid=247154###">#2</A></DIV>
<DIV style="PADDING-TOP: 6px">发表于 2008-8-20 12:01 </DIV></DIV></TD></TR>
<TR>
<TD class=line style="PADDING-TOP: 10px" vAlign=top height="100%">
<DIV style="FLOAT: right" align=right><A title="评分 0"
href="http://tech.techweb.com.cn/misc.php?action=viewratings&tid=247154&pid=868357"></A></DIV>
<DIV class=t_msgfont id=message868357>我刚写针对你要求写的，看看你就会了
<BR>%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
<BR><二>一个 下拉 动态 读取 数据库 <BR>FOR: <BR>1. <BR>package Test;
<BR><BR>import java.sql.Connection; <BR>import java.sql.ResultSet;
<BR>import java.sql.Statement; <BR><BR>import
javax.servlet.http.HttpServletRequest; <BR>import
javax.servlet.jsp.JspWriter; <BR><BR>import DBConnect.DBConn;
<BR><BR>public class Bumen { <BR>public void
getBumen(HttpServletRequest request,JspWriter out) { <BR>
Connection conn = null; <BR>
Statement stmt = null; <BR>
ResultSet rs = null; <BR><BR>
try { <BR>
DBConn db = new DBConn(); <BR>
conn =
db.getConnection(); <BR>
stmt = conn.createStatement(); <BR>
String sql = "select
distinct bm_name from PJ_BM"; <BR>
rs = stmt.executeQuery(sql); <BR>
String html ="";
<BR> while
(rs.next()) <BR>
{ <BR>
String bm_name=rs.getString("bm_name");
<BR>
out.print(" <option>"+bm_name+" </option>");
<BR> } <BR>
} catch (Exception e) { <BR>
e.getMessage();
<BR> } finally { <BR>
try { <BR>
rs.close(); <BR>
stmt.close(); <BR>
conn.close();
<BR> } catch
(Exception e) { <BR>
e.getMessage(); <BR>
} <BR>
} <BR> } <BR>} <BR><BR>2.JSP
<BR><td> <BR><select name="city">
<BR><option>-请选择城市- </option> <BR>
<% <BR>
Bumen bm=new Bumen(); <BR>
bm.getBumen(request,out); <BR>
%> <BR></select> <BR>
</td>
<BR>%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%</DIV><BR><FONT
style="FONT: 12px Tahoma, Verdana; COLOR: #333333"></FONT></TD></TR>
<TR>
<TD align=right><A
href="http://tech.techweb.com.cn/post.php?action=reply&fid=10&tid=247154&repquote=868357&extra=&page=1">引用</A>
<A onclick="fastreply('回复 #2 的帖子')"
href="http://tech.techweb.com.cn/viewthread.php?tid=247154###">回复</A>
<A onclick=scroll(0,0)
href="http://tech.techweb.com.cn/viewthread.php?tid=247154###"><IMG
alt=顶部
src="求JSP+sql二级联动菜单！ - 程序开发 - TechWeb-技术社区 - Powered by TechWeb_com_cn!.files/top.gif"
border=0></A> </TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></DIV>
<DIV class=spaceborder style="MARGIN-BOTTOM: 4px; WIDTH: 98%">
<TABLE class=t_row cellSpacing=0 cellPadding=6 width="100%" align=center>
<TBODY>
<TR style="HEIGHT: 100%">
<TD class=t_user vAlign=top width="18%"><A name=pid868358></A><SPAN
class=bold>游客</SPAN> <SPAN class=smalltxt></SPAN><BR><SPAN
class=smalltxt>未注册 <BR><BR><BR><BR><BR><BR><BR><BR><BR><BR></SPAN></TD>
<TD
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px"
vAlign=top width="82%">
<TABLE class=t_msg cellSpacing=0 cellPadding=6 border=0>
<TBODY>
<TR>
<TD>
<DIV>
<DIV class="right t_number"><A class=bold title=复制帖子链接到剪贴板
onclick="setcopy('http://tech.techweb.com.cn/viewthread.php?tid=247154&page=1#pid868358', '已经复制到剪贴板')"
href="http://tech.techweb.com.cn/viewthread.php?tid=247154###">#3</A></DIV>
<DIV style="PADDING-TOP: 6px">发表于 2008-8-20 12:01 </DIV></DIV></TD></TR>
<TR>
<TD class=line style="PADDING-TOP: 10px" vAlign=top height="100%">
<DIV style="FLOAT: right" align=right><A title="评分 0"
href="http://tech.techweb.com.cn/misc.php?action=viewratings&tid=247154&pid=868358"></A></DIV>
<DIV class=t_msgfont id=message868358>Java code<BR><%@ page
language="java" import="java.util.*"
pageEncoding="gb2312"%><BR><%@ page
import="java.lang.*,java.sql.*,java.text.*,java.io.*"%><BR><jsp:useBean
scope="page" id="OpenDB" class="dfbz.OpenDB"
/><BR><jsp:useBean scope="page" id="ExecuteWay"
class="dfbz.ExecuteWay" /><BR><!DOCTYPE HTML PUBLIC
"-//W3C//DTD HTML 4.01
Transitional//EN"><BR><html><BR><head><BR>
<title>电费报账明细查询</title><BR><style><BR>body{background:#E8FBFF;}<BR></style><BR><BR><BR><BR><%<BR>
String str1="select *
from dzb";<BR>
ResultSet
rs2=ExecuteWay.exeSqlQuery(str1);<BR>
int count=0;<BR>
<BR>%><BR><script language=
"javascript "> <BR> var
scount1=0; <BR> var stype=new
Array(); <BR> <% <BR>
while(rs2.next()){ <BR>
%> <BR>
stype[<%=count%>]=new
Array("<%=rs2.getString("yddd")%>","<%=rs2.getString("fid")%>",<%=rs2.getInt("id")%>);
<BR> <% <BR>
count++; <BR>
} <BR> %>
<BR> scount1=<%=count%>;
<BR> function changetext(fid)
<BR> { <BR>
document.test.yddd.length=0; <BR>
var
fid=fid; <BR>
var i; <BR>
document.test.yddd.options[0]=new
Option('---请选择分公司---',''); <BR>
for(i=0;i<scount1;i++) <BR>
{
<BR>
if(stype<I>[1]==fid) <BR>
{ <BR>
document.test.yddd.options[document.test.yddd.length]=new
Option(stype<I>[0],stype<I>[2]); <BR>
} <BR>
} <BR>
}
<BR></script> <BR><BR><BR><BR><script
language="javascript"><BR>function Check(yf){<BR> var
yf = document.test.yf.value;<BR> var test =
document.getElementById("test");<BR> if(yf ==
0)<BR> {<BR> test.action =
"bhnresult2.jsp";<BR> }<BR> else<BR>
{<BR> test.action = "bhnresult1.jsp";<BR>
}<BR>}<BR></script><BR><BR><BR></head><BR><body><BR>
<BR>
<form method="post" name="test"
id="test" target=_self><BR><table
width="300" height="178" cellspacing="2" cellpadding="1"
align="center" border="0" id="mysjs"><BR>
<TR> <BR> <BR>
<td width="20%" align="right">分
公 司:</td><BR> <td
width="20%" align=right><BR>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -