一:将下面的数组的值作为表的标题:
var myarray = new Array("使用单位","资产编号","资产名称", "使用部门", "使用职员","复核状态");二:然后从数据库读写相应的记录形成一个完整的表格:下面是代码但是形成不了表格的,谁帮忙看看
conn = "Provider=OraOLEDB.Oracle;data source=ora;user id=gaczdata0004;password=gold;";
sSQL = "select * from tb1";
rsXML.open(sSQL,conn);
document.write("<table>");
//for(var i = 0;i < rsXML.fields.count;i++){
//document.write("<td style=\"background:'ffcfff' ;font:bold;\">" + myarray[i] + "</td>") ;
//}
//document.write("</tr>");
while(!rsXML.eof){
document.write("<tr>");
for(var i=0;i<rsXML.fields.count;i++){
//document.write("<td>" + "rsXML.fields(i).value" + "</td>");
document.write("<td>" + rsXML.fields(i).value + " </td>");
//document.write(rsXML.fields(i).value);
}
document.write("</tr>");
rsXML.MoveNext
}
document.write("</table>");
var myarray = new Array("使用单位","资产编号","资产名称", "使用部门", "使用职员","复核状态");二:然后从数据库读写相应的记录形成一个完整的表格:下面是代码但是形成不了表格的,谁帮忙看看
conn = "Provider=OraOLEDB.Oracle;data source=ora;user id=gaczdata0004;password=gold;";
sSQL = "select * from tb1";
rsXML.open(sSQL,conn);
document.write("<table>");
//for(var i = 0;i < rsXML.fields.count;i++){
//document.write("<td style=\"background:'ffcfff' ;font:bold;\">" + myarray[i] + "</td>") ;
//}
//document.write("</tr>");
while(!rsXML.eof){
document.write("<tr>");
for(var i=0;i<rsXML.fields.count;i++){
//document.write("<td>" + "rsXML.fields(i).value" + "</td>");
document.write("<td>" + rsXML.fields(i).value + " </td>");
//document.write(rsXML.fields(i).value);
}
document.write("</tr>");
rsXML.MoveNext
}
document.write("</table>");
不知道我说的对不对我没测试,希望共同提高.
document.write()是正确的,关键是如何根据查询的数据生成一个完整的表
//用 JavaScript 写服务器端连接数据库的代码示例
var conn = new ActiveXObject("ADODB.Connection");
conn.Open("Provider=SQLOLEDB.1; Data Source=localhost; User ID=sa; "
+"Password=; Initial Catalog=pubs");
var rs = new ActiveXObject("ADODB.Recordset");
var sql="select * from authors";
rs.open(sql, conn);
shtml = "<table width='100%' border=1>";
shtml +="<tr bgcolor='#f4f4f4'><td>au_id</td><td>au_lname</td><td>au_fname</td><td>phone</td><td>address</td><td> city</td><td>state</td><td>zip</td></tr>";
while(!rs.EOF)
{
shtml += "<tr><td>" + rs("au_id") + "</td><td>" + rs("au_lname") + "</td><td>" + rs("au_fname") + "</td><td>" + rs("phone") + "</td><td>" + rs("address") + "</td><td>" + rs("city") + "</td><td>" + rs("state") + "</td><td>" + rs("zip") + "</td></tr>";
rs.moveNext;
}
shtml += "</table>";
document.write(shtml);
rs.close();
rs = null;
conn.close();
conn = null;
</script>
看这个例子和你的取法不一样。
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>Right read all data</title>
<script language="javascript">
function ReadData(){
var sSQL;
var conn = new ActiveXObject("ADODB.Connection");
var XDom = new ActiveXObject("MSXML.DOMDocument");
var rs = new ActiveXObject("ADODB.Recordset");
var flag = 0;
var myarray = new Array("使用单位","资产编号","资产名称", "使用部门", "使用职员","复核状态");
conn = "Provider=OraOLEDB.Oracle;data source=ora;user id=gaczdata0004;password=gold;";
sSQL = "select co.COMPANY_NAME,ca.ASSET_CARD_NO,ca.ASSET_CARD_NAME,da.DEPARTMENT_NAME,pe.FIRST_NAME || pe.LAST_NAME as";
sSQL = sSQL + " Name,us.USER_NAME FROM COMPANY co,ZC_ASSET_CARD ca,DEPARTMENT da,PERSON pe,USER_LOGIN us where ";
sSQL = sSQL + "co.COMPANY_PARTY_ID = ca.COMPANY_PARTY_ID and da.DEPARTMENT_PARTY_ID = ca.DEPARTMENT_ID and ";
sSQL = sSQL + "pe.PARTY_ID=ca.EMPLOYEE_ID and us.USER_LOGIN_ID = ca.FH_USER_LOGIN_ID and ca.FH_USER_LOGIN_ID='01'";
rs.open(sSQL,conn);
shtml = "<table width='70%' border=1>";
shtml +="<tr bgcolor='#f4f4f4'><td>使用单位</td><td>资产编号</td><td>资产名称</td><td>使用部门</td><td>使用职员</td>";
shtml += "<td>复核状态</td></tr>";
while(!rs.EOF){
shtml += "<tr><td>" + rs("COMPANY_NAME") + "</td><td>" + rs("ASSET_CARD_NO") + "</td><td>" + rs("ASSET_CARD_NAME") + "</td> <td>" + rs("DEPARTMENT_NAME") + "</td><td>" + rs("Name") + "</td><td>" + rs("USER_NAME") + "</td>" + "</tr>";
rs.moveNext;
}
shtml += "</table>";
document.write(shtml);
rs.close();
rs = null;
conn.close();
conn = null;
}
</script>
</head>
<body>
<input type="button" id="bt1" value="查询" onclick="ReadData();" />
</body>
</html>