Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎĵµ£º

Google ÅÅÃûÖÐµÄ 10 ¸ö×îÖøÃûµÄ JavaScript ¿â

ugmbbc·¢²¼ÓÚ 2009-11-14 09:41:43| 7628 ´ÎÔĶÁ ×ÖÌ壺´ó С ´òÓ¡Ô¤ÀÀ
var ReTitle = '»Ø¸´:Google ÅÅÃûÖÐµÄ 10 ¸ö×îÖøÃûµÄ JavaScript ¿â';
¸ÐлCOMSHARP CMSµÄͶµÝ
ÐÂÎÅÀ´Ô´:tripwiremagazine.com
JavaScript ÊÇ Web ¿ª·¢ÓëÉè¼ÆÖв»¿É»òȱµÄ¶«Î÷£¬²»¹ÜÊÇÒ»¸ö¼òµ¥µÄÍøÒ³»¹ÊÇÒ»¸öרҵµÄÕ¾µã£¬Ò²²»¹ÜÄãÊǸßÊÖ»¹ÊDzËÄñ ......

JavascriptÍÏ×§&ÍÏ·ÅϵÁÐÎÄÕÂ1Ö®offsetParentÊôÐÔ


Õâ¸öϵÁÐÎÄÕÂÖ÷ÒªÊǽ²ÊöʵÏÖJavascriptÍÏ×§¹¦ÄܵĻù´¡ÖªÊ¶£¬²¢½«ÔÚ×îºó¸ø³öÒ»¸öÍêÕûµÄʾÀý¡£Êʺ϶ÔÍÏ×§ÍêÈ«²»¶®µÄÈËÔĶÁ¡£
µÚһƪ¾ÍÏȽ²½²JavascriptÖеÄoffsetParentÊôÐÔ°É¡£
 
 
Ö§³ÖµÄä¯ÀÀÆ÷£ºInternet Explorer 4.0+£¬Mozilla 1.0+£¬Netscape 6.0+£¬Opera 7.0+£¬Safari  ......

javascript+div+css¹ö¶¯²Ëµ¥µÄʵÏÖ.

Ч¹ûͼ
´úÂë:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>Scrollable</title>
<mce:script type="text/javascript"><!--
resizeCallback = function() {
......

SQLServerË÷Òýµ÷ÓÅʵ¼ù£¨1£©

Ë÷ÒýµÄÖØÒªÐÔ
Êý¾Ý¿âÐÔÄÜÓÅ»¯ÖÐË÷Òý¾ø¶ÔÊÇÒ»¸öÖØÁ¿¼¶µÄÒòËØ£¬¿ÉÒÔ˵£¬Ë÷ÒýʹÓò»µ±£¬ÆäËüÓÅ»¯´ëÊ©½«ºÁÎÞÒâÒå¡£
¾Û´ØË÷Òý
(Clustered Index)ºÍ·Ç¾Û´ØË÷Òý
(Non- Clustered Index)
×îͨË׵ĽâÊÍÊÇ:¾Û´ØË÷ÒýµÄ˳Ðò¾ÍÊÇÊý¾ÝµÄÎïÀí´æ´¢Ë³Ðò£¬¶ø¶Ô·Ç¾Û´ØË÷ÒýµÄË÷Òý˳ÐòÓëÊý¾ÝÎïÀíÅÅÁÐ˳ÐòÎ޹ء£¾ÙÀýÀ´Ëµ£¬Äã·­µ½Ð»ª×ÖµäµÄº ......

²»ÖØÆôSQL·þÎñ£¬É¾³ýSQLServerϵͳÈÕÖ¾

    µ±SQLServerµÄϵͳÈÕÖ¾¹ý´ó£¬¾Í»áÒýÆðSQLServer·þÎñÆ÷ÎÞ·¨Æô¶¯µÈһϵÁÐÎÊÌâ¡£½ñÌìÎÒÓöµ½ÁËÕâ¸öÎÊÌ⣬ÔÚÍøÉÏËÑË÷ÁËһϣ¬½â¾ö·½·¨ÊÇɾ³ý¾Í¿ÉÒÔÁË£¬¿ÉÊǵ±Ç°µÄErrorLogÕýÔÚ±»SQLʹÓÃÎÞ·¨É¾³ý°¡£¬ÒªÉ¾³ýÖ»ÄÜÍ£Ö¹SQL·þÎñÆ÷£¬ÄѵÀ¾ÍûÓбðµÃ°ì·¨ÁËÂð£¿
    »Ø´ðÊǿ϶¨µÄ£ºÊ¹ÓÃÒÔÏ´洢¹ý³Ì£º ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ