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
Ïà¹ØÎĵµ£º
Õ⼸ÌìÔÚѧJavaScriptµÄ»ù´¡ÖªÊ¶£¬¾Í°Ñ»ù´¡µÄ֪ʶÕûÀíһϡ£
1¡¢JavaScriptµÄËÄÖÖ»ù±¾µÄÊý¾ÝÀàÐÍ£ºÊýÖµ£¨ÕûÊýºÍʵÊý£©¡¢×Ö·û´®ÐÍ£¨ÓÓ”»òÕß‘’À¨ÆðÀ´µÄ×Ö·û»òÕßÊýÖµ£©¡¢²¼¶ûÐÍ£¨true»òfalse£©¡¢¿ÕÖµ¡£
2¡¢JavaScriptµÄ±äÁ¿
ÉùÃ÷±äÁ¿£º±äÁ¿Ôڽű¾ÖеÚÒ»´Î³öÏÖʱºòÔÚÉùÃ÷ÖУ¨var£©£¬±äÁ¿µÄ ......
JavaScriptÔÊÐí´´½¨ºÍ´ò¿ª´ú±íHTMLÎı¾, form¶ÔÏóºÍframeµÄ´°¿Ú.
window¶ÔÏóÊÇJavaScript¿Í»§²ã´Î½á¹¹µÄ×î¶¥²ã¶ÔÏó,
formÔªËØºÍÈ«²¿JavaScript´úÂë¶¼ÊÇ´æÔÚÓÚÎĵµÖÐ,¶øÎĵµ±»×°Ôؽø´°¿Ú. ΪÁËÀí½â´°¿ÚÔõÑù¹¤×÷,Äã¿ÉÒÔ¿ØÖƲÙ×÷ÕâЩ´°¿Ú.
´ò¿ªºÍ¹Ø±Õ´°¿Ú
µ±
Óû§Æô¶¯(launch)Navigatorʱ,½«×Ô¶¯´´½¨Ò»¸ö´°¿Ú.Óû§»¹¿ÉÒ ......
°ÑphpÊý¾Ý»òÖµ´«µÝ¸øjs
£ººÜ¼òµ¥£¬Ö±½ÓÔÚjsÖÐʹÓÃphp´úÂ룬»ì±à¼´¿É¡£
°ÑjsÊý¾Ý´«µÝ¸øphp
£º¿ÉÒÔʹÓôò¿ªÐ´°¿ÚµÄ·½Ê½£¬Í¨¹ýurlµØÖ·°ÑÊý¾Ý´«µÝ¹ýÈ¥¡£Ò²¿ÉÒÔʹÓÃajax£¬Í¨¹ýget»òpost´«µÝ¸øphp£¬Ò²¿ÉÒÔ±£´æcookieÈÃphpÀ´¶Á¡£
ÔÚ´«µÝÊý¾Ý¹ý³ÌÖпÉÄÜÓöµ½ÖÐÎıàÂë
ÎÊÌ⣬¿ÉÒÔͳһ±àÂ뷽ʽΪjsµÄescape£¬unescape£¬Ò²¿ÉÒÔÍ³Ò ......
Java´úÂë import flash.external.ExternalInterface; function hello(){ return "²âÊԳɹ¦ÁËŶ~~"; } //ÔÊÐíflashµ÷ÓÃjsº¯Êý ²ÎÊý1£ºjsº¯ÊýÃû³Æ ²ÎÊý2£ºÏòjsº¯Êý´«µÝµÄ²ÎÊý ExternalInterface.call("hello", "jacky"); ......
µÚÒ»ÖÖ JavaScriptÁ¬½ÓÊý¾Ý¿â£º
<mce:script language="JavaScript"><!--
// ´´½¨Êý¾Ý¿â¶ÔÏó
var objdbConn = new ActiveXObject("ADODB.Connection");
// DSN×Ö·û´®
var strdsn = "Driver={SQL Server};SERVER=192.168.0.210;UID=xhb;PWD=xhb;DATABASE=books";
// ´ò¿ªÊý¾ÝÔ´
objdbConn.Open(strdsn);
// ......