JavaScript连接SqlServer并实现分页

最新推荐文章于 2024-05-22 14:32:23 发布

原创最新推荐文章于 2024-05-22 14:32:23 发布 · 1.5k 阅读

4 ·

CC 4.0 BY-SA版权

文章标签：

#sqlserver #javascript #input #function #database #sql

ExtJS 同时被 2 个专栏收录

34 篇文章

订阅专栏

SQL Server 2000

14 篇文章

订阅专栏

本文展示了一个使用ASP实现的简单分页查询示例，包括计算总记录数、总页数及具体的数据查询过程。通过SQL连接数据库并利用ADO对象进行数据操作。

//总记录数 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"></mce:script>"); }else { while(!rs.EOF && i<PageSize) { i++; Response.Write("<tr align='center'>"); Response.Write("<td>"+i +"</td>"); Response.Write("<td>"+ rs('truename') +"</td>"); Response.Write("<td>"+ getActiveNameById(rs('activeid')) +"</td>"); Response.Write("<td>"+ rs('chrtel') +"</td>"); Response.Write("<td>"+ rs('dtappenddate') +"</td>"); Response.Write("</tr>"); rs.movenext; } } rs.close(); conn.close(); rs=null; conn=null; } function page() { Response.Write("<form action='huodong.asp' method='post'><table width='98%' border='0' align='right' cellpadding='0' cellspacing='0'>"); Response.Write("<tr>"); Response.Write("<td>"); Response.Write("<input type='submit' name='home' value='首页'/>"); Response.Write("<input type='hidden' name='homepage' value='1'/>"); Response.Write("<input type='submit' name='up' value='上一页'/>"); Response.Write("<input type='hidden' name='uppage' value='"+(CurPageNum-1)+"'/>"); Response.Write("<input type='submit' name='down' value='下一页'/>"); Response.Write("<input type='hidden' name='downpage' value='"+(CurPageNum+1)+"'/>"); Response.Write("<input type='hidden' name='ChrName' value='"+username+"'/>"); Response.Write("<input type='hidden' name='ChrPwd' value='"+password+"'/>"); //Response.Write("<input type='submit' name='last' value='最后一页'/>"); Response.Write("</td>"); Response.Write("</tr>"); Response.Write("</table></form>"); }