从数据库取值的问题???? 不知为何,运行jsp页面,编译不了 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 <%@ page language="java" contentType="text/html; charset=gb2312" %><%@ page import="java.io.*"%><%@ page import="java.util.*"%><%@ page import="java.sql.*"%><%@ page import="com.db.*"%><jsp:useBean id="book" class="com.db.Books" /> <HTML><HEAD><TITLE>query_menu</TITLE><META content="text/html; charset=gb2312" http-equiv=Content-Type><STYLE type=text/css>A:link { COLOR: #FFCC33; TEXT-DECORATION: none}A:visited { COLOR: #ff6633; TEXT-DECORATION: none}A:hover { COLOR: #339933; TEXT-DECORATION: underline}A:active { COLOR: #990099}</STYLE><SCRIPT language=JavaScript src="images/TgToc.js"></SCRIPT><STYLE type=text/css>.TgSpToc1ItemFolderNoLink { COLOR: #FFFFFF; FONT-FAMILY: "宋体"; FONT-SIZE: 14px; FONT-WEIGHT: normal; TEXT-DECORATION: none}.TgSpToc1ItemFolderLink { COLOR: black; FONT-FAMILY: "宋体"; FONT-SIZE: 14px; FONT-WEIGHT: normal; TEXT-DECORATION: none}.TgSpToc1ItemNoLink { COLOR: #FFFFFF; FONT-FAMILY: "宋体"; FONT-SIZE: 14px; FONT-WEIGHT: bold}.TgSpToc1ItemLink { COLOR: #FFCC33; FONT-FAMILY: "宋体"; FONT-SIZE: 14px; FONT-WEIGHT: normal; TEXT-DECORATION: none}</STYLE> <% book.connect(); String cc = "SELECT * FROM BADWDJ where bdsszd='长春市经侦支队' "; ResultSet rs = book.viewBooks(cc); Vector list = new Vector() ; while (rs.next()) { String zd =rs.getString("bdsszd"); list.addElement(zd) ; %> <SCRIPT>var myToc1 = new TgSpToc_toc('myToc1');myToc1.styleItemLink ='TgSpToc1ItemLink';myToc1.styleItemNoLink ='TgSpToc1ItemNoLink';myToc1.styleItemFolderLink ='TgSpToc1ItemFolderLink';myToc1.styleItemFolderNoLink='TgSpToc1ItemFolderNoLink';myToc1.showRoot = true;myToc1.showIcons = true;myToc1.showTextLinks = true;myToc1.iconPath = 'images/';myToc1.iconWidth = '24';myToc1.iconHeight = '22';myToc1.iconEmpty = 'images/Line2.gif';myToc1.iconPlus = 'images/Plus.gif';myToc1.iconPlus1 = 'images/Plus2.gif';myToc1.iconPlus2 = 'images/Plus2.gif';myToc1.iconMinus = 'images/Minus.gif';myToc1.iconMinus1 = 'images/Minus2.gif';myToc1.iconMinus2 = 'images/Minus2.gif';myToc1.iconLine1 = 'images/Line2.gif';myToc1.iconLine2 = 'images/Line2.gif';myToc1.iconLine3 = 'images/Line3.gif';myToc1.iconItem = 'images/Item.gif';myToc1.iconFolderExpanded = 'images/FolderExp.gif';myToc1.iconFolderCollapsed = 'images/FolderCol.gif';myToc1_node1= myToc1.makeFolder('<%= rs.getString("bdssod") %>','','MAIN','');<%for (int i=1;i<list.size();i++){%>myToc1_node2= myToc1.makeFolder('<%= list.elementAt(i) %>','','','');myToc1.insertNode(myToc1_node1, myToc1_node2);这样写对吗? try:<%@ page language="java" contentType="text/html; charset=gb2312" %><%@ page import="java.io.*"%><%@ page import="java.util.*"%><%@ page import="java.sql.*"%><%@ page import="com.db.*"%><jsp:useBean id="book" class="com.db.Books" /> <HTML><HEAD><TITLE>query_menu</TITLE><META content="text/html; charset=gb2312" http-equiv=Content-Type><STYLE type=text/css>A:link { COLOR: #FFCC33; TEXT-DECORATION: none}A:visited { COLOR: #ff6633; TEXT-DECORATION: none}A:hover { COLOR: #339933; TEXT-DECORATION: underline}A:active { COLOR: #990099}</STYLE><SCRIPT language=JavaScript src="images/TgToc.js"></SCRIPT><STYLE type=text/css>.TgSpToc1ItemFolderNoLink { COLOR: #FFFFFF; FONT-FAMILY: "宋体"; FONT-SIZE: 14px; FONT-WEIGHT: normal; TEXT-DECORATION: none}.TgSpToc1ItemFolderLink { COLOR: black; FONT-FAMILY: "宋体"; FONT-SIZE: 14px; FONT-WEIGHT: normal; TEXT-DECORATION: none}.TgSpToc1ItemNoLink { COLOR: #FFFFFF; FONT-FAMILY: "宋体"; FONT-SIZE: 14px; FONT-WEIGHT: bold}.TgSpToc1ItemLink { COLOR: #FFCC33; FONT-FAMILY: "宋体"; FONT-SIZE: 14px; FONT-WEIGHT: normal; TEXT-DECORATION: none}</STYLE> <% book.connect(); String cc = "SELECT * FROM BADWDJ where bdsszd='长春市经侦支队' "; ResultSet rs = book.viewBooks(cc); Vector list = new Vector() ; while (rs.next()) { String zd =rs.getString("bdsszd"); list.addElement(zd) ; %> <SCRIPT>var myToc1 = new TgSpToc_toc('myToc1');myToc1.styleItemLink ='TgSpToc1ItemLink';myToc1.styleItemNoLink ='TgSpToc1ItemNoLink';myToc1.styleItemFolderLink ='TgSpToc1ItemFolderLink';myToc1.styleItemFolderNoLink='TgSpToc1ItemFolderNoLink';myToc1.showRoot = true;myToc1.showIcons = true;myToc1.showTextLinks = true;myToc1.iconPath = 'images/';myToc1.iconWidth = '24';myToc1.iconHeight = '22';myToc1.iconEmpty = 'images/Line2.gif';myToc1.iconPlus = 'images/Plus.gif';myToc1.iconPlus1 = 'images/Plus2.gif';myToc1.iconPlus2 = 'images/Plus2.gif';myToc1.iconMinus = 'images/Minus.gif';myToc1.iconMinus1 = 'images/Minus2.gif';myToc1.iconMinus2 = 'images/Minus2.gif';myToc1.iconLine1 = 'images/Line2.gif';myToc1.iconLine2 = 'images/Line2.gif';myToc1.iconLine3 = 'images/Line3.gif';myToc1.iconItem = 'images/Item.gif';myToc1.iconFolderExpanded = 'images/FolderExp.gif';myToc1.iconFolderCollapsed = 'images/FolderCol.gif';myToc1_node1= myToc1.makeFolder('<%= rs.getString("bdssod") %>','','MAIN','');<%}%><%for (int i=0;i<list.size();i++){%>myToc1_node2= myToc1.makeFolder('<%= list.elementAt(i) %>','','','');myToc1.insertNode(myToc1_node1, myToc1_node2);<%}%></script> var myToc1 = new TgSpToc_toc('myToc1');TgSpToc_toc是在TgToc.js中自己定义的类吗? 是的Andrawu(Andrawu) ,你说的方法,我试了,基本可以但还有些小毛病, <SCRIPT><% book.connect(); String cc = "SELECT * FROM BADWDJ"; ResultSet rs = book.viewBooks(cc); Vector list = new Vector() ; Vector lt = new Vector() ; int k=0; int q=1; while (rs.next()) { String zd =rs.getString("bdsszd"); String dd =rs.getString("bdssdd"); // list.addElement(zd) ; lt.addElement(dd) ; k++; q++;%> var myToc1 = new TgSpToc_toc('myToc1');myToc1.styleItemLink ='TgSpToc1ItemLink';myToc1.styleItemNoLink ='TgSpToc1ItemNoLink';myToc1.styleItemFolderLink ='TgSpToc1ItemFolderLink';myToc1.styleItemFolderNoLink='TgSpToc1ItemFolderNoLink';myToc1.showRoot = true;myToc1.showIcons = true;myToc1.showTextLinks = true;myToc1.iconPath = 'images/';myToc1.iconWidth = '24';myToc1.iconHeight = '22';myToc1.iconEmpty = 'images/Line2.gif';myToc1.iconPlus = 'images/Plus.gif';myToc1.iconPlus1 = 'images/Plus2.gif';myToc1.iconPlus2 = 'images/Plus2.gif';myToc1.iconMinus = 'images/Minus.gif';myToc1.iconMinus1 = 'images/Minus2.gif';myToc1.iconMinus2 = 'images/Minus2.gif';myToc1.iconLine1 = 'images/Line2.gif';myToc1.iconLine2 = 'images/Line2.gif';myToc1.iconLine3 = 'images/Line3.gif';myToc1.iconItem = 'images/Item.gif';myToc1.iconFolderExpanded = 'images/FolderExp.gif';myToc1.iconFolderCollapsed = 'images/FolderCol.gif';myToc1_node1= myToc1.makeFolder('<%= rs.getString("bdssod") %>','','MAIN','');<%}%><%for (int i=0;i<list.size();i++){ String chaxun="select * from BADWDJ where bdsszd=<%=rs.getString("bdsszd")%>"; ResultSet ss = book.viewBooks(chaxun); Vector lk = new Vector() ; lk.addElement(ss.getString("bdsszd")) ; %>myToc1_node<%=q%>= myToc1.makeFolder('<%= lk.elementAt(i) %>','','','');myToc1.insertNode(myToc1_node1, myToc1_node<%=q%>);myToc1_node<%=k%>= myToc1.makeItem('<%= lt.elementAt(i) %>', 'ld_rytd_main.jsp','_parent','');myToc1.insertNode(myToc1_node<%=q%>, myToc1_node<%=k%>); <% } rs.close();%></SCRIPT> 上面的代码是我改进的但执行for (int i=0;i<list.size();i++){ String chaxun="select * from BADWDJ where bdsszd=<%=rs.getString("bdsszd")%>"; ResultSet ss = book.viewBooks(chaxun); Vector lk = new Vector() ; lk.addElement(ss.getString("bdsszd")) ; %>myToc1_node<%=q%>= myToc1.makeFolder('<%= lk.elementAt(i) %>','','','');myToc1.insertNode(myToc1_node1, myToc1_node<%=q%>);myToc1_node<%=k%>= myToc1.makeItem('<%= lt.elementAt(i) %>', 'ld_rytd_main.jsp','_parent','');myToc1.insertNode(myToc1_node<%=q%>, myToc1_node<%=k%>); <% } rs.close();%>说这段代码有问题 <SCRIPT language=JavaScript src="images/TgToc.js"><SCRIPT><% book.connect(); String cc = "SELECT * FROM BADWDJ "; ResultSet rs = book.viewBooks(cc); Vector list = new Vector() ; Vector lis = new Vector() ; int k=0; int q=1; while (rs.next()) { String zd =rs.getString("bdsszd"); String dd =rs.getString("bdssdd"); list.addElement(zd) ; lis.addElement(dd); k++; q++;%> var myToc1 = new TgSpToc_toc('myToc1');myToc1.styleItemLink ='TgSpToc1ItemLink';myToc1.styleItemNoLink ='TgSpToc1ItemNoLink';myToc1.styleItemFolderLink ='TgSpToc1ItemFolderLink';myToc1.styleItemFolderNoLink='TgSpToc1ItemFolderNoLink';myToc1.showRoot = true;myToc1.showIcons = true;myToc1.showTextLinks = true;myToc1.iconPath = 'images/';myToc1.iconWidth = '24';myToc1.iconHeight = '22';myToc1.iconEmpty = 'images/Line2.gif';myToc1.iconPlus = 'images/Plus.gif';myToc1.iconPlus1 = 'images/Plus2.gif';myToc1.iconPlus2 = 'images/Plus2.gif';myToc1.iconMinus = 'images/Minus.gif';myToc1.iconMinus1 = 'images/Minus2.gif';myToc1.iconMinus2 = 'images/Minus2.gif';myToc1.iconLine1 = 'images/Line2.gif';myToc1.iconLine2 = 'images/Line2.gif';myToc1.iconLine3 = 'images/Line3.gif';myToc1.iconItem = 'images/Item.gif';myToc1.iconFolderExpanded = 'images/FolderExp.gif';myToc1.iconFolderCollapsed = 'images/FolderCol.gif';myToc1_node1= myToc1.makeFolder('<%= rs.getString("bdssod") %>','','MAIN','');<%}%><%for (int i=0;i<list.size();i++){%>myToc1_node<%=k%>= myToc1.makeFolder('<%= list.elementAt(i) %>','','','');myToc1.insertNode(myToc1_node1, myToc1_node<%=k%>);myToc1_node<%=q%>= myToc1.makeItem('<%= lis.elementAt(i) %>', 'ld_rytd_main.jsp','_parent','');myToc1.insertNode(myToc1_node<%=k%>, myToc1_node<%=q%>); <% } rs.close();%></SCRIPT>我是想把数据库里的数据显示在js树里面。。 <SCRIPT><% book.connect(); String cc = "SELECT * FROM BADWDJ "; ResultSet rs = book.viewBooks(cc); Vector list = new Vector() ; Vector lis = new Vector() ; int k=0; int q=1; while (rs.next()) { String zd =rs.getString("bdsszd"); String dd =rs.getString("bdssdd"); list.addElement(zd) ; lis.addElement(dd); k++; q++;%> var myToc1 = new TgSpToc_toc('myToc1');myToc1.styleItemLink ='TgSpToc1ItemLink';myToc1.styleItemNoLink ='TgSpToc1ItemNoLink';myToc1.styleItemFolderLink ='TgSpToc1ItemFolderLink';myToc1.styleItemFolderNoLink='TgSpToc1ItemFolderNoLink';myToc1.showRoot = true;myToc1.showIcons = true;myToc1.showTextLinks = true;myToc1.iconPath = 'images/';myToc1.iconWidth = '24';myToc1.iconHeight = '22';myToc1.iconEmpty = 'images/Line2.gif';myToc1.iconPlus = 'images/Plus.gif';myToc1.iconPlus1 = 'images/Plus2.gif';myToc1.iconPlus2 = 'images/Plus2.gif';myToc1.iconMinus = 'images/Minus.gif';myToc1.iconMinus1 = 'images/Minus2.gif';myToc1.iconMinus2 = 'images/Minus2.gif';myToc1.iconLine1 = 'images/Line2.gif';myToc1.iconLine2 = 'images/Line2.gif';myToc1.iconLine3 = 'images/Line3.gif';myToc1.iconItem = 'images/Item.gif';myToc1.iconFolderExpanded = 'images/FolderExp.gif';myToc1.iconFolderCollapsed = 'images/FolderCol.gif';myToc1_node1= myToc1.makeFolder('<%= rs.getString("bdssod") %>','','MAIN','');<%}%><%for (int i=0;i<list.size();i++){%>myToc1_node<%=i%>= myToc1.makeFolder('<%= list.elementAt(i) %>','','','');myToc1.insertNode(myToc1_node1, myToc1_node<%=k%>);myToc1_node<%=(i+1)%>= myToc1.makeItem('<%= lis.elementAt(i) %>', 'ld_rytd_main.jsp','_parent','');myToc1.insertNode(myToc1_node<%=k%>, myToc1_node<%=q%>); <% } rs.close();%></SCRIPT> myToc1_node <%=i% >= myToc1.makeFolder(' <%= list.elementAt(i) % >','','',''); myToc1.insertNode(myToc1_node1, myToc1_node <%=k% >); myToc1_node <%=(i+1)% >= myToc1.makeItem(' <%= lis.elementAt(i) % >', 'ld_rytd_main.jsp','_parent',''); myToc1.insertNode(myToc1_node <%=k% >, myToc1_node <%=q% >); 其实这段编译之后,应该显示:myToc1_node2= myToc1.makeFolder('1经侦支队','','','');myToc1.insertNode(myToc1_node1, myToc1_node2);myToc1_node3= myToc1.makeItem('11经侦大队', 'ld_rytd_main.jsp','_parent','');myToc1.insertNode(myToc1_node2, myToc1_node3); try:<%int j = 0for (int i=0;i<list.size();i++){ j++;%>myToc1_node<%=j%>= myToc1.makeFolder('<%= list.elementAt(i) %>','','','');myToc1.insertNode(myToc1_node<%=j%>, myToc1_node<%=j%>);<%j++ ;%>myToc1_node<%=(j)%>= myToc1.makeItem('<%= lis.elementAt(i) %>', 'ld_rytd_main.jsp','_parent','');myToc1.insertNode(myToc1_node<%=j%>, myToc1_node<%=j%>); <% } rs.close();%> try:<%int j = 0for (int i=0;i<list.size();i++){ j++;%>myToc1_node<%=j%>= myToc1.makeFolder('<%= list.elementAt(i) %>','','','');myToc1.insertNode(myToc1_node<%=j%>, myToc1_node<%=j%>);<%j++ ;%>myToc1_node<%=(j)%>= myToc1.makeItem('<%= lis.elementAt(i) %>', 'ld_rytd_main.jsp','_parent','');myToc1.insertNode(myToc1_node<%=j%>, myToc1_node<%=j%>); <% } rs.close();%> try:<%int j = 0for (int i=0;i<list.size();i++){ j++;%>myToc1_node<%=j%>= myToc1.makeFolder('<%= list.elementAt(i) %>','','','');myToc1.insertNode(myToc1_node<%=j%>, myToc1_node<%=j%>);<%j++ ;%>myToc1_node<%=(j)%>= myToc1.makeItem('<%= lis.elementAt(i) %>', 'ld_rytd_main.jsp','_parent','');myToc1.insertNode(myToc1_node<%=j%>, myToc1_node<%=j%>); <% } rs.close();%> "select * from BADWDJ where bdsszd='" + <%=rs.getString("bdsszd")%> + "'"; 请问<jsp:xxx />与JSTL有什么区别呢? 使用dom4j迭代读取XML 求启动(停止)tomcat6的java代码 找茬。 ============救命!!!配置数据源老是不成功啊!========= 向oracle的一个数据表中插入一条记录 报出以下错误应该怎么解决?高手指点 大侠求助了! web的访问速度 web应用入口问题,在线等待! 用spring-security-acl-3.1.0.RC1.jar的包做登录,用户名或密码错了,怎么返回错误提示啊??? [问题点数:40分] 分页显示问题? 这个问题有点难!
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="com.db.*"%>
<jsp:useBean id="book" class="com.db.Books" />
<HTML>
<HEAD>
<TITLE>query_menu</TITLE>
<META content="text/html; charset=gb2312" http-equiv=Content-Type>
<STYLE type=text/css>A:link {
COLOR: #FFCC33; TEXT-DECORATION: none
}
A:visited {
COLOR: #ff6633; TEXT-DECORATION: none
}
A:hover {
COLOR: #339933; TEXT-DECORATION: underline
}
A:active {
COLOR: #990099
}
</STYLE>
<SCRIPT language=JavaScript src="images/TgToc.js">
</SCRIPT>
<STYLE type=text/css>.TgSpToc1ItemFolderNoLink {
COLOR: #FFFFFF; FONT-FAMILY: "宋体"; FONT-SIZE: 14px; FONT-WEIGHT: normal; TEXT-DECORATION: none
}
.TgSpToc1ItemFolderLink {
COLOR: black; FONT-FAMILY: "宋体"; FONT-SIZE: 14px; FONT-WEIGHT: normal; TEXT-DECORATION: none
}
.TgSpToc1ItemNoLink {
COLOR: #FFFFFF; FONT-FAMILY: "宋体"; FONT-SIZE: 14px; FONT-WEIGHT: bold
}
.TgSpToc1ItemLink {
COLOR: #FFCC33; FONT-FAMILY: "宋体"; FONT-SIZE: 14px; FONT-WEIGHT: normal; TEXT-DECORATION: none
}
</STYLE>
<%
book.connect();
String cc = "SELECT * FROM BADWDJ where bdsszd='长春市经侦支队' ";
ResultSet rs = book.viewBooks(cc);
Vector list = new Vector() ;
while (rs.next()) {
String zd =rs.getString("bdsszd");
list.addElement(zd) ;
%>
<SCRIPT>
var myToc1 = new TgSpToc_toc('myToc1');
myToc1.styleItemLink ='TgSpToc1ItemLink';
myToc1.styleItemNoLink ='TgSpToc1ItemNoLink';
myToc1.styleItemFolderLink ='TgSpToc1ItemFolderLink';
myToc1.styleItemFolderNoLink='TgSpToc1ItemFolderNoLink';
myToc1.showRoot = true;
myToc1.showIcons = true;
myToc1.showTextLinks = true;
myToc1.iconPath = 'images/';
myToc1.iconWidth = '24';
myToc1.iconHeight = '22';
myToc1.iconEmpty = 'images/Line2.gif';
myToc1.iconPlus = 'images/Plus.gif';
myToc1.iconPlus1 = 'images/Plus2.gif';
myToc1.iconPlus2 = 'images/Plus2.gif';
myToc1.iconMinus = 'images/Minus.gif';
myToc1.iconMinus1 = 'images/Minus2.gif';
myToc1.iconMinus2 = 'images/Minus2.gif';
myToc1.iconLine1 = 'images/Line2.gif';
myToc1.iconLine2 = 'images/Line2.gif';
myToc1.iconLine3 = 'images/Line3.gif';
myToc1.iconItem = 'images/Item.gif';
myToc1.iconFolderExpanded = 'images/FolderExp.gif';
myToc1.iconFolderCollapsed = 'images/FolderCol.gif';
myToc1_node1= myToc1.makeFolder('<%= rs.getString("bdssod") %>','','MAIN','');
<%
for (int i=1;i<list.size();i++)
{
%>
myToc1_node2= myToc1.makeFolder('<%= list.elementAt(i) %>','','','');
myToc1.insertNode(myToc1_node1, myToc1_node2);
这样写对吗?
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="com.db.*"%>
<jsp:useBean id="book" class="com.db.Books" />
<HTML>
<HEAD>
<TITLE>query_menu</TITLE>
<META content="text/html; charset=gb2312" http-equiv=Content-Type>
<STYLE type=text/css>A:link {
COLOR: #FFCC33; TEXT-DECORATION: none
}
A:visited {
COLOR: #ff6633; TEXT-DECORATION: none
}
A:hover {
COLOR: #339933; TEXT-DECORATION: underline
}
A:active {
COLOR: #990099
}
</STYLE>
<SCRIPT language=JavaScript src="images/TgToc.js">
</SCRIPT>
<STYLE type=text/css>.TgSpToc1ItemFolderNoLink {
COLOR: #FFFFFF; FONT-FAMILY: "宋体"; FONT-SIZE: 14px; FONT-WEIGHT: normal; TEXT-DECORATION: none
}
.TgSpToc1ItemFolderLink {
COLOR: black; FONT-FAMILY: "宋体"; FONT-SIZE: 14px; FONT-WEIGHT: normal; TEXT-DECORATION: none
}
.TgSpToc1ItemNoLink {
COLOR: #FFFFFF; FONT-FAMILY: "宋体"; FONT-SIZE: 14px; FONT-WEIGHT: bold
}
.TgSpToc1ItemLink {
COLOR: #FFCC33; FONT-FAMILY: "宋体"; FONT-SIZE: 14px; FONT-WEIGHT: normal; TEXT-DECORATION: none
}
</STYLE>
<%
book.connect();
String cc = "SELECT * FROM BADWDJ where bdsszd='长春市经侦支队' ";
ResultSet rs = book.viewBooks(cc);
Vector list = new Vector() ;
while (rs.next()) {
String zd =rs.getString("bdsszd");
list.addElement(zd) ;
%>
<SCRIPT>
var myToc1 = new TgSpToc_toc('myToc1');
myToc1.styleItemLink ='TgSpToc1ItemLink';
myToc1.styleItemNoLink ='TgSpToc1ItemNoLink';
myToc1.styleItemFolderLink ='TgSpToc1ItemFolderLink';
myToc1.styleItemFolderNoLink='TgSpToc1ItemFolderNoLink';
myToc1.showRoot = true;
myToc1.showIcons = true;
myToc1.showTextLinks = true;
myToc1.iconPath = 'images/';
myToc1.iconWidth = '24';
myToc1.iconHeight = '22';
myToc1.iconEmpty = 'images/Line2.gif';
myToc1.iconPlus = 'images/Plus.gif';
myToc1.iconPlus1 = 'images/Plus2.gif';
myToc1.iconPlus2 = 'images/Plus2.gif';
myToc1.iconMinus = 'images/Minus.gif';
myToc1.iconMinus1 = 'images/Minus2.gif';
myToc1.iconMinus2 = 'images/Minus2.gif';
myToc1.iconLine1 = 'images/Line2.gif';
myToc1.iconLine2 = 'images/Line2.gif';
myToc1.iconLine3 = 'images/Line3.gif';
myToc1.iconItem = 'images/Item.gif';
myToc1.iconFolderExpanded = 'images/FolderExp.gif';
myToc1.iconFolderCollapsed = 'images/FolderCol.gif';
myToc1_node1= myToc1.makeFolder('<%= rs.getString("bdssod") %>','','MAIN','');
<%}%>
<%
for (int i=0;i<list.size();i++)
{
%>
myToc1_node2= myToc1.makeFolder('<%= list.elementAt(i) %>','','','');
myToc1.insertNode(myToc1_node1, myToc1_node2);
<%}%>
</script>
Andrawu(Andrawu) ,你说的方法,我试了,基本可以
但还有些小毛病,
<%
book.connect();
String cc = "SELECT * FROM BADWDJ";
ResultSet rs = book.viewBooks(cc);
Vector list = new Vector() ;
Vector lt = new Vector() ;
int k=0;
int q=1;
while (rs.next()) {
String zd =rs.getString("bdsszd");
String dd =rs.getString("bdssdd");
// list.addElement(zd) ;
lt.addElement(dd) ;
k++;
q++;
%>
var myToc1 = new TgSpToc_toc('myToc1');
myToc1.styleItemLink ='TgSpToc1ItemLink';
myToc1.styleItemNoLink ='TgSpToc1ItemNoLink';
myToc1.styleItemFolderLink ='TgSpToc1ItemFolderLink';
myToc1.styleItemFolderNoLink='TgSpToc1ItemFolderNoLink';
myToc1.showRoot = true;
myToc1.showIcons = true;
myToc1.showTextLinks = true;
myToc1.iconPath = 'images/';
myToc1.iconWidth = '24';
myToc1.iconHeight = '22';
myToc1.iconEmpty = 'images/Line2.gif';
myToc1.iconPlus = 'images/Plus.gif';
myToc1.iconPlus1 = 'images/Plus2.gif';
myToc1.iconPlus2 = 'images/Plus2.gif';
myToc1.iconMinus = 'images/Minus.gif';
myToc1.iconMinus1 = 'images/Minus2.gif';
myToc1.iconMinus2 = 'images/Minus2.gif';
myToc1.iconLine1 = 'images/Line2.gif';
myToc1.iconLine2 = 'images/Line2.gif';
myToc1.iconLine3 = 'images/Line3.gif';
myToc1.iconItem = 'images/Item.gif';
myToc1.iconFolderExpanded = 'images/FolderExp.gif';
myToc1.iconFolderCollapsed = 'images/FolderCol.gif';
myToc1_node1= myToc1.makeFolder('<%= rs.getString("bdssod") %>','','MAIN','');
<%}%>
<%
for (int i=0;i<list.size();i++)
{
String chaxun="select * from BADWDJ where bdsszd=<%=rs.getString("bdsszd")%>";
ResultSet ss = book.viewBooks(chaxun);
Vector lk = new Vector() ;
lk.addElement(ss.getString("bdsszd")) ;
%>
myToc1_node<%=q%>= myToc1.makeFolder('<%= lk.elementAt(i) %>','','','');
myToc1.insertNode(myToc1_node1, myToc1_node<%=q%>);
myToc1_node<%=k%>= myToc1.makeItem('<%= lt.elementAt(i) %>', 'ld_rytd_main.jsp','_parent','');
myToc1.insertNode(myToc1_node<%=q%>, myToc1_node<%=k%>);
<%
}
rs.close();
%>
</SCRIPT>
但执行
for (int i=0;i<list.size();i++)
{
String chaxun="select * from BADWDJ where bdsszd=<%=rs.getString("bdsszd")%>";
ResultSet ss = book.viewBooks(chaxun);
Vector lk = new Vector() ;
lk.addElement(ss.getString("bdsszd")) ;
%>
myToc1_node<%=q%>= myToc1.makeFolder('<%= lk.elementAt(i) %>','','','');
myToc1.insertNode(myToc1_node1, myToc1_node<%=q%>);
myToc1_node<%=k%>= myToc1.makeItem('<%= lt.elementAt(i) %>', 'ld_rytd_main.jsp','_parent','');
myToc1.insertNode(myToc1_node<%=q%>, myToc1_node<%=k%>);
<%
}
rs.close();
%>
说这段代码有问题
<SCRIPT>
<%
book.connect();
String cc = "SELECT * FROM BADWDJ ";
ResultSet rs = book.viewBooks(cc);
Vector list = new Vector() ;
Vector lis = new Vector() ;
int k=0;
int q=1;
while (rs.next()) {
String zd =rs.getString("bdsszd");
String dd =rs.getString("bdssdd");
list.addElement(zd) ;
lis.addElement(dd);
k++;
q++;
%>
var myToc1 = new TgSpToc_toc('myToc1');
myToc1.styleItemLink ='TgSpToc1ItemLink';
myToc1.styleItemNoLink ='TgSpToc1ItemNoLink';
myToc1.styleItemFolderLink ='TgSpToc1ItemFolderLink';
myToc1.styleItemFolderNoLink='TgSpToc1ItemFolderNoLink';
myToc1.showRoot = true;
myToc1.showIcons = true;
myToc1.showTextLinks = true;
myToc1.iconPath = 'images/';
myToc1.iconWidth = '24';
myToc1.iconHeight = '22';
myToc1.iconEmpty = 'images/Line2.gif';
myToc1.iconPlus = 'images/Plus.gif';
myToc1.iconPlus1 = 'images/Plus2.gif';
myToc1.iconPlus2 = 'images/Plus2.gif';
myToc1.iconMinus = 'images/Minus.gif';
myToc1.iconMinus1 = 'images/Minus2.gif';
myToc1.iconMinus2 = 'images/Minus2.gif';
myToc1.iconLine1 = 'images/Line2.gif';
myToc1.iconLine2 = 'images/Line2.gif';
myToc1.iconLine3 = 'images/Line3.gif';
myToc1.iconItem = 'images/Item.gif';
myToc1.iconFolderExpanded = 'images/FolderExp.gif';
myToc1.iconFolderCollapsed = 'images/FolderCol.gif';
myToc1_node1= myToc1.makeFolder('<%= rs.getString("bdssod") %>','','MAIN','');
<%}%>
<%
for (int i=0;i<list.size();i++)
{
%>
myToc1_node<%=k%>= myToc1.makeFolder('<%= list.elementAt(i) %>','','','');
myToc1.insertNode(myToc1_node1, myToc1_node<%=k%>);
myToc1_node<%=q%>= myToc1.makeItem('<%= lis.elementAt(i) %>', 'ld_rytd_main.jsp','_parent','');
myToc1.insertNode(myToc1_node<%=k%>, myToc1_node<%=q%>);
<%
}
rs.close();
%>
</SCRIPT>
我是想把数据库里的数据显示在js树里面。。
<%
book.connect();
String cc = "SELECT * FROM BADWDJ ";
ResultSet rs = book.viewBooks(cc);
Vector list = new Vector() ;
Vector lis = new Vector() ;
int k=0;
int q=1;
while (rs.next()) {
String zd =rs.getString("bdsszd");
String dd =rs.getString("bdssdd");
list.addElement(zd) ;
lis.addElement(dd);
k++;
q++;
%>
var myToc1 = new TgSpToc_toc('myToc1');
myToc1.styleItemLink ='TgSpToc1ItemLink';
myToc1.styleItemNoLink ='TgSpToc1ItemNoLink';
myToc1.styleItemFolderLink ='TgSpToc1ItemFolderLink';
myToc1.styleItemFolderNoLink='TgSpToc1ItemFolderNoLink';
myToc1.showRoot = true;
myToc1.showIcons = true;
myToc1.showTextLinks = true;
myToc1.iconPath = 'images/';
myToc1.iconWidth = '24';
myToc1.iconHeight = '22';
myToc1.iconEmpty = 'images/Line2.gif';
myToc1.iconPlus = 'images/Plus.gif';
myToc1.iconPlus1 = 'images/Plus2.gif';
myToc1.iconPlus2 = 'images/Plus2.gif';
myToc1.iconMinus = 'images/Minus.gif';
myToc1.iconMinus1 = 'images/Minus2.gif';
myToc1.iconMinus2 = 'images/Minus2.gif';
myToc1.iconLine1 = 'images/Line2.gif';
myToc1.iconLine2 = 'images/Line2.gif';
myToc1.iconLine3 = 'images/Line3.gif';
myToc1.iconItem = 'images/Item.gif';
myToc1.iconFolderExpanded = 'images/FolderExp.gif';
myToc1.iconFolderCollapsed = 'images/FolderCol.gif';
myToc1_node1= myToc1.makeFolder('<%= rs.getString("bdssod") %>','','MAIN','');
<%}%>
<%
for (int i=0;i<list.size();i++)
{
%>
myToc1_node<%=i%>= myToc1.makeFolder('<%= list.elementAt(i) %>','','','');
myToc1.insertNode(myToc1_node1, myToc1_node<%=k%>);
myToc1_node<%=(i+1)%>= myToc1.makeItem('<%= lis.elementAt(i) %>', 'ld_rytd_main.jsp','_parent','');
myToc1.insertNode(myToc1_node<%=k%>, myToc1_node<%=q%>);
<%
}
rs.close();
%>
</SCRIPT>
myToc1.insertNode(myToc1_node1, myToc1_node <%=k% >);
myToc1_node <%=(i+1)% >= myToc1.makeItem(' <%= lis.elementAt(i) % >', 'ld_rytd_main.jsp','_parent','');
myToc1.insertNode(myToc1_node <%=k% >, myToc1_node <%=q% >);
其实这段编译之后,应该显示:
myToc1_node2= myToc1.makeFolder('1经侦支队','','','');
myToc1.insertNode(myToc1_node1, myToc1_node2);
myToc1_node3= myToc1.makeItem('11经侦大队', 'ld_rytd_main.jsp','_parent','');
myToc1.insertNode(myToc1_node2, myToc1_node3);
int j = 0
for (int i=0;i<list.size();i++)
{
j++;
%>
myToc1_node<%=j%>= myToc1.makeFolder('<%= list.elementAt(i) %>','','','');
myToc1.insertNode(myToc1_node<%=j%>, myToc1_node<%=j%>);
<%j++ ;%>
myToc1_node<%=(j)%>= myToc1.makeItem('<%= lis.elementAt(i) %>', 'ld_rytd_main.jsp','_parent','');
myToc1.insertNode(myToc1_node<%=j%>, myToc1_node<%=j%>);
<%
}
rs.close();
%>
int j = 0
for (int i=0;i<list.size();i++)
{
j++;
%>
myToc1_node<%=j%>= myToc1.makeFolder('<%= list.elementAt(i) %>','','','');
myToc1.insertNode(myToc1_node<%=j%>, myToc1_node<%=j%>);
<%j++ ;%>
myToc1_node<%=(j)%>= myToc1.makeItem('<%= lis.elementAt(i) %>', 'ld_rytd_main.jsp','_parent','');
myToc1.insertNode(myToc1_node<%=j%>, myToc1_node<%=j%>);
<%
}
rs.close();
%>
int j = 0
for (int i=0;i<list.size();i++)
{
j++;
%>
myToc1_node<%=j%>= myToc1.makeFolder('<%= list.elementAt(i) %>','','','');
myToc1.insertNode(myToc1_node<%=j%>, myToc1_node<%=j%>);
<%j++ ;%>
myToc1_node<%=(j)%>= myToc1.makeItem('<%= lis.elementAt(i) %>', 'ld_rytd_main.jsp','_parent','');
myToc1.insertNode(myToc1_node<%=j%>, myToc1_node<%=j%>);
<%
}
rs.close();
%>