代码如下:
function readLogDb(firstDay,endDay)//查询当月的所有日志信息
{
this.logDbs = new Array();
this.logDbsIdex = new Array();//记录不同天数数字
var idx = 0,i = 0,e = 0,n = 0;
var conn = new ActiveXObject("ADODB.Connection");
conn.Open("DBQ="+dbpath +";DRIVER={Microsoft Access Driver (*.mdb)};");
var rs = new ActiveXObject("ADODB.Recordset");
var sql = "SELECT * FROM daily_adversaria WHERE (daily_adversaria.createTime) > #2009-7-1# AND (daily_adversaria.createTime) < #2009-7-31# ORDER BY daily_adversaria.createTime DESC";
rs.open(sql,conn);
while(!rs.EOF)
{
var dys = getMyTimeNow(2,rs("createTime")).split("-");
var dy = getMyTimeNow(null,rs("createTime"));
var idt = rs("id");//日志索引
var til = rs("title");//日志标题
var cont = rs("content");//日志摘要
var mdy = parseInt(dys[2]);
if( idx != dys[2])
{
this.logDbsIdex[e] = mdy;//把不同的天数记录下来
// alert(this.logDbsIdex);
this.logDbs[mdy] = new Array();
this.logDbs[mdy][i] = new Array();
this.logDbs[mdy][i]["day"] = mdy;//当前所在日
this.logDbs[mdy][i]["createTime"] = dy;
this.logDbs[mdy][i]["id"] = idt;
this.logDbs[mdy][i]["title"] = til;
this.logDbs[mdy][i]["content"] = cont;
e ++;
i ++ ;
n = 0;
}else
{
this.logDbs[idx][n]["day"] = mdy;//当前所在日
this.logDbs[idx][n]["createTime"] = dy;
this.logDbs[idx][n]["id"] = idt;
this.logDbs[idx][n]["title"] = til;
this.logDbs[idx][n]["content"] = cont;
i = 0;//初始化下标
n++;
} idx = mdy;
rs.moveNext;
}
rs.close();
rs = null;
conn.close();
conn = null;
}
function readLogDb(firstDay,endDay)//查询当月的所有日志信息
{
this.logDbs = new Array();
this.logDbsIdex = new Array();//记录不同天数数字
var idx = 0,i = 0,e = 0,n = 0;
var conn = new ActiveXObject("ADODB.Connection");
conn.Open("DBQ="+dbpath +";DRIVER={Microsoft Access Driver (*.mdb)};");
var rs = new ActiveXObject("ADODB.Recordset");
var sql = "SELECT * FROM daily_adversaria WHERE (daily_adversaria.createTime) > #2009-7-1# AND (daily_adversaria.createTime) < #2009-7-31# ORDER BY daily_adversaria.createTime DESC";
rs.open(sql,conn);
while(!rs.EOF)
{
var dys = getMyTimeNow(2,rs("createTime")).split("-");
var dy = getMyTimeNow(null,rs("createTime"));
var idt = rs("id");//日志索引
var til = rs("title");//日志标题
var cont = rs("content");//日志摘要
var mdy = parseInt(dys[2]);
if( idx != dys[2])
{
this.logDbsIdex[e] = mdy;//把不同的天数记录下来
// alert(this.logDbsIdex);
this.logDbs[mdy] = new Array();
this.logDbs[mdy][i] = new Array();
this.logDbs[mdy][i]["day"] = mdy;//当前所在日
this.logDbs[mdy][i]["createTime"] = dy;
this.logDbs[mdy][i]["id"] = idt;
this.logDbs[mdy][i]["title"] = til;
this.logDbs[mdy][i]["content"] = cont;
e ++;
i ++ ;
n = 0;
}else
{
this.logDbs[idx][n]["day"] = mdy;//当前所在日
this.logDbs[idx][n]["createTime"] = dy;
this.logDbs[idx][n]["id"] = idt;
this.logDbs[idx][n]["title"] = til;
this.logDbs[idx][n]["content"] = cont;
i = 0;//初始化下标
n++;
} idx = mdy;
rs.moveNext;
}
rs.close();
rs = null;
conn.close();
conn = null;
}
解决方案 »
- JS中实现自动添加一个可信任站点问题?
- jsp的loading怎么做?
- 请教两个JavaScript实现下拉框图片显示和Input可自动调整大小的问题
- javascript实现图片切换
- 怎么把小写数字转换大写?
- ext 是否有updown控件
- [求助]一个JSP页面中的javascript如何调用另一个JSP页面的javascript
- 一个简单问题:JS如何获得鼠标所在的超链接(可以是DIV,甚至层)位置(坐标)?
- JavaScript脚本中的另存为能否实现远程保存。
- 检测URL的正则表达式无法工作, 大家来快帮忙呀..
- 一个eclipse+spket的问题
- 要在这个函数里增加一个删除确认 怎么做
主要想请教下这样写二维数组是否正确
不是像你这么创建的,
var a = [];
var b = [];//b可以是任何对象
a.push(b);