JavaScriptÁ¬½ÓSqlServer²¢ÊµÏÖ·ÖÒ³

//×ܼǼÊý
function sumRecord()
{
var conn= Server.CreateObject("ADODB.connection");
var rs= Server.CreateObject("adodb.recordset");
conn.open("PROVIDER=SQLOLEDB;DATA SOURCE=127.0.0.1;UID=sa;PWD=123456;DATABASE=test");
var sql = "select count(*) as RecordCount from baoming";
rs.open(sql,conn);
TotalRecords = rs('RecordCount');
}
function baoming()
{
//¼ÆËã×ܵÄÒ³Êý
TotalPages = (((TotalRecords % PageSize) == 0) ? (TotalRecords / PageSize)
: (TotalRecords / PageSize + 1));
//»ñÈ¡´«²Î¹ýÀ´µÄÒ³Êý
var toppage;
var home = Request.Form("home");
var up = Request.Form("up");
var uppage = parseInt(Request.Form("uppage"));
var down = Request.Form("down");
var downpage = parseInt(Request.Form("downpage"));

if(home=="Ê×Ò³")
{
PageSize=30;
}else if(up=="ÉÏÒ»Ò³")
{
toppage = uppage;
if(toppage !=0)
{
CurPageNum = toppage;
if (CurPageNum > TotalPages)
{
CurPageNum = TotalPages;
} else if (CurPageNum <= 0)
{
showCurPageNumPage = 1;
}
}
}else if(down=="ÏÂÒ»Ò³")
{
toppage = downpage;
if(toppage !=0)
{
CurPageNum = toppage;
if (CurPageNum > TotalPages)
{
CurPageNum = TotalPages;
} else if (CurPageNum <= 0)
{
showCurPageNumPage = 1;
}
}
}
//rs.Absolute((CurPageNum - 1) * PageSize + 1);

var conn= Server.CreateObject("ADODB.connection");
var rs= Server.CreateObject("adodb.recordset");
conn.open("PROVIDER=SQLOLEDB;DATA SOURCE=127.0.0.1;UID=sa;PWD=123456;DATABASE=test");
var sql = "select top "+PageSize+" truename,activeid,chrtel,CONVERT(varchar(30),dtappenddate,20) as dtappenddate from baoming where id not in(select top "+(PageSize*(CurPageNum-1))+" id from baoming order by id desc) order by id desc";
rs.open(sql,conn);
var i =0;

if(TotalRecords < 1)
{
Response.write("<mce:script type="text/javascript"><!--
alert('ûÓмǼ');
// --></mce:scri