|
首先要建一個(gè)和你取出數(shù)據(jù)相匹配的類：
如在數(shù)據(jù)庫中取出表test：id,name,age的數(shù)據(jù)，就要建一個(gè)test類{id,name,age},然后在給它們加上set和get方法,然后在取值時(shí)，把數(shù)據(jù)賦給這個(gè)類就可以了,
如：select * from test 后,賦值:test t=new test();t.setID(rs.getInt("id"));
要取id的時(shí)候用t.getID()；就可以了
如果取的數(shù)據(jù)很多，還可以用java.util.ArrayList這個(gè)類,把他放到這里就行;
ArrayList al=new ArrayList();al.add(t);取出時(shí)用
for(int i=0;i<al.size();i++)
test t1=(test)al.get(i);Top
不是很明白.
我是調(diào)用自己編寫的javabean取出數(shù)據(jù),返回是ResultSet,
我想知道如何在javascript中，使用ResultSet中的數(shù)據(jù).
想把ResultSet中利用多維數(shù)組保存ResultSet中的數(shù)據(jù).
代碼如下:
<%@ page language = "java" %>
<%@ page contentType = "text/html;charset=gb2312" %>
<%@ page import = "java.sql.*" %>
<jsp:useBean id = "mocata" class = "com.keysoft.smsbean.QueryMobileCata" scope = "page" />
<%
String thisurl = "";
String temp = "";
int rcdNum = 0;
ResultSet cata = null;
cata = mocata.getAllMobileCata();
%>
我編寫了javascript函數(shù),是用來顯示樹型結(jié)構(gòu)目錄的,treemenu(menu),傳入?yún)?shù)是數(shù)組.
<script language = "javascript">
<!--
treemenu("0",menu);
//-->
</script>
我不知道該怎么把取出的數(shù)據(jù)放在jscript的多維數(shù)組中. . 注意: <% %>不能包含在<script>與</script>之間.
代碼如下:
<%@ page language = "java" %>
<%@ page contentType = "text/html;charset=gb2312" %>
<%@ page import = "java.sql.*" %>
<jsp:useBean id = "mocata" class = "com.keysoft.smsbean.QueryMobileCata" scope = "page" />
<%
String thisurl = "";
int rcdNum = 0;
ResultSet cata = null;
cata = mocata.getAllMobileCata();
rcdNum = mocata.getRecordCount();
%>
<script language="Javascript">
menu1 = new Array();
var tmp,tmp1;
var temp;
temp = 1;
</script>
<%
int temp;
temp = 0;
while(cata.next())
{
temp = temp + 1;
%>
<script language="Javascript">
menu1[<%=temp%>] = new Array(5);
tmp = "<%=cata.getString("id")%>";
if(tmp != "null" && tmp != "")
{
menu1[<%=temp%>][1] = tmp;
tmp2 = "<%=cata.getString("parentid")%>";
if(tmp2 != "null" && tmp2 != "")
{
menu1[<%=temp%>][2] = tmp2;
}
else
{
menu1[<%=temp%>][2] = "0";
}
tmp2 = "<%=cata.getString("name")%>";
if(tmp2 != "null" && tmp2 != "")
{
menu1[<%=temp%>][3] = tmp2;
}
else
{
menu1[<%=temp%>][3] = "";
}
tmp2 = "<%=cata.getString("filename")%>";
if(tmp2 != "null" && tmp != "")
{
tmp2 = tmp2 + "?cid=" + menu1[<%=temp%>][1];
menu1[<%=temp%>][4] = tmp2;
}
else
{
menu1[<%=temp%>][4] = "";
}
menu1[<%=temp%>][5] = "smsmain";
document.write(menu1[<%=temp%>][1] + "------");
document.write(menu1[<%=temp%>][2] + "------");
document.write(menu1[<%=temp%>][3] + "------");
document.write(menu1[<%=temp%>][4] + "------");
document.write(menu1[<%=temp%>][5] + "------");
document.write("<br>");
}
</script>
<%
}
%>
<script language="javascript" src="./js/check.js"></script>
<link rel="stylesheet" href="./sms.css">
</head>
<body bgcolor="#8F9C83">
<script language = "javascript">
<!--
treemenu("0",menu1);
//-->
</script>
</body>
</html>Top
|
