´ó¼ÒÔÚ·ÃÎÊ google»ò°Ù¶ÈµÄʱºò£¬¼ÙÈçÒªËÑË÷“°¢·²´ï”£¬ÎÒÃÇ¿ÉÄÜÖ»ÐèÒªÊäÈëÒ»¸ö “°¢”×Ö£¬ÍøÕ¾¾Í»á×Ô¶¯Æ¥ÅäһЩ´Ê×鹩ÎÒÃÇÑ¡Ôñ£¬Õâ¸öÉè¼Æ·Ç³£ÈËÐÔ»¯¡£½ñÌìÎÒÃǾʹ˼¼Êõ¼òÒª½éÉÜ£¬±¾ÎļÙÉè¶ÁÕß²»Çå³þajax¼¼Êõϸ½Ú¡£
ÏÈ˵˵AJAX£¬ÎÒ֮ǰҲûÓйØ×¢¹ýÕâ·½Ãæ£¬ÉÔ΢Á˽âÁËһϣ¬ÆäʵËü¾ÍÊÇÒ»¸ö¿Í»§¶Ë½Å±¾Óë·þÎñÆ÷¶¯Ì¬Í¨ÐÅ£¬ÔÚWEB½çÃæ²»Ë¢ÐµÄÇé¿öϾͿÉÒÔ½øÐн»»¥µÄÒ»¸ö¼¼Êõ¡£Õâ¸ö¼¼ÊõÄÜ´øÀ´·Ç³£°ôµÄÓû§ÌåÑ飬½«ÍøÒ³´Ó“±íµ¥”Ìá½»·½Ê½£¬±ä³ÉÁ˽çÃæ»¥¶¯·½Ê½£¬Ê¹µÃÕû¸öÒ³Ãæ¿´ÉÏÈ¥½»»¥ÐÔ¸üÇ¿´ó£¬¸ü·½±ã¡£
ajax ´óÖÂÁ÷³ÌÈçÏ£º
1¿Í»§¶Ë½Å±¾ - 2´¥·¢Ê¼þ - 3·ÃÎÊ·þÎñÆ÷½Å±¾ - 4ͨ¹ý¹Ì¶¨Êý¾Ý¸ñʽ»Ø´«Êý¾Ý - 5¿Í»§¶Ë¶¯Ì¬³ÊÏÖ
ÕâÀï4Ò»°ãͨÓõÄÊý¾Ý´«Ê䷽ʽΪXML»òÕßjason£¨ÇáÁ¿¼¶£©
ÏÂÃæ¾ÍÎÒÃÇʵÏÖÕâ¸ö×Ô¶¯Æ¥ÅäÊäÈë¿òµÄһЩÏÞÖÆ×÷ÒªÇó£º
1.´Ê»ãÈ¡×Ô·þÎñÆ÷µÄÒ»¸öÊý¾Ý¿â¡£
2.Ò»´ÎÈ¡10¸ö´Ê¡£
3.´ÊµÄÆ¥ÅäΪ×Ó´®Æ¥Åä¡£
ÏÂÃæ¿´Ò»ÏÂÏà¹ØÖØÒª²¿·ÖµÄ´úÂ룺
¿Í»§¶Ëjavascript
var http_request=false;
function on_search()
{
var content = document.getElementById("searchname").value;
if( content != "" )
document.getElementB ......
AjaxµÄÎÞˢзÖÒ³
ÕâÀïÒÔÁ½¸öÎļþ½øÐдúÂëÏÔʾһ¸öÊÇajax·ÖҳʵÏÖµÄÎļþ£¬ÁíÒ»¸öÊÇ·ÖÒ³ÀàÎļþ
Îļþ1.ajax_page.php
<script type="text/javascript" language="javascript">
function createXMLHttp()
{
var browser=navigator.appName; //get the current browser
if(browser=="Microsoft Internet Explorer")
{
xmlHttp=new ActiveXObject("Microsoft.XMLHttp"); //if is IE
}
else xmlHttp=new XMLHttpRequest();
}
function changePage(url)
{
xmlHttp.onreadystatechange=newPage;
xmlHttp.open("GET",url,true);
xmlHttp.send(null);
}
function newPage()
{
if(xmlHttp.readyState==4)
{
if(xmlHttp.status==200)
{
document.getElementById("newPage").innerHTML=xmlHttp.responseText;
}
}
}
function doPage ......
Ò»¡¢ajaxµÄÈëÃÅ
1¡¢XMLHttpRequest¶ÔÏóµÄʹÓã¨Ê¹ÓÃXMLHttpRequest½âÎöxmlÎļþ£©
onreadystatechange
Ö¸¶¨µ±readyStateÊôÐԸıäʱµÄʼþ´¦Àí¾ä±ú
open()
´´½¨Ò»¸öеÄhttpÇëÇ󣬲¢Ö¸¶¨´ËÇëÇóµÄ·½·¨¡¢URLµÈÐÅÏ¢
send()
·¢ËÍÇëÇóµ½http·þÎñÆ÷²¢½ÓÊÕ»ØÓ¦
readyState
·µ»ØXMLHTTPÇëÇóµÄµ±Ç°×´Ì¬
status
·µ»Øµ±Ç°ÇëÇóµÄhttp״̬Âë
responseText
½«ÏìÓ¦ÐÅÏ¢×÷Ϊ×Ö·û´®·µ»Ø
responseXML
½«ÏìÓ¦ÐÅÏ¢¸ñʽ»¯ÎªXml Document¶ÔÏó²¢·µ»Ø
out»ØÓ¦¿Í»§
£±¡¢“Ìí¼ÓÐÂÏî” Ð½¨Ò»¸öXMLÎļþÀ´´æ·ÅÒª±»µ÷ÓõÄÊý¾Ý¡£
XMLFile.xml
<?xml version="1.0" encoding="utf-8" ?>
<response>
<res>
¶Ô²»Æð,µÇ¼ʧ°Ü!
</res>
</response>
£²¡¢“Ìí¼ÓÐÂÏî” Ð½¨Ò»¸öJSPÒ³£¬Ìí¼Ó´úÂ룺
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-// ......
»ù±¾ÔÀí
FreeTDSΪLinuxϵͳÌṩÁËTDSÐÒéµÄ¿ªÔ´¿Í»§¶Ë¡£ÓÉÓÚMS SQLºÍSybaseʹÓõÄÇ¡ÊÇTDSÐÒ飬ËùÒÔÔÚLinuxÖпÉÒÔÓÃFreeTDSÁ¬½ÓMS SQL¡£
ÎÒÃÇ¿ÉÒÔÀûÓÃOpenOffice.Org Base¼°Linux ODBCʵÏÖ¿ÉÊÓ»¯µÄÊý¾Ý¿â²é¿´·½Ê½¡£·½±ã¸öÈËÓû§Ê¹ÓÃLinuxÔ¶³Ì¹ÜÀí×Ô¼ºµÄÊý¾Ý¿âϵͳ¡£
ÃüÁîÐз½Ê½Ê¹Ó÷½·¨¼ò½é
°²×°FreeTDSºÍsqsh
Ê×ÏȰ²×°FreeTDS£¬ÔÚDebian
/Ubuntu
ϵͳÖеݲװ¿ÉÒÔÖ±½Ó°²×°tdsodbc
ºÍsqsh
Èí¼þ°ü¡£Èç¹ûÄãʹÓõķ¢ÐаæÃ»ÓÐFreeTDS£¬¿ÉÒÔµ½FreeTDSµÄÍøÕ¾
ºÍsqshµÄÍøÕ¾
ÏÂÔØ°²×°¡£
ÏÖÔھͿÉÒÔÓÃsqsh·ÃÎÊSQL ServerÊý¾Ý¿âÁË£¬×î¼òµ¥µÄʹÓ÷½·¨ÈçÏ£º
sqsh -U Óû§Ãû -P ÃÜÂë -S ·þÎñÆ÷µØÖ·
µÈÒ»»á¶ùÈç¹û³öÏÖ1> £¬¾Í˵Ã÷Á¬½Ó³É¹¦ÁË£¬¿ÉÒÔÊÔ×ÅÊäÈëÈçÏÂÓï¾ä£º
SELECT @@version
go
×¢ÒâÊäÈëgoºó²ÅÖ´ÐÐÓï¾ä¡£
ͼÐνçÃæµÄÁ¬½Ó·½Ê½
°²×°Èí¼þ
ÇëÏȰ²×°Ç°ÃæÃüÁîÐйÜÀí½çÃæ
ÖÐËù˵µÄFreeTDSºÍsqsh¡£È»ºó°²×°Èí¼þ°üunixodbc-bin
(Debian/Ubuntu)»òµ½unixODBCµÄÍøÕ¾
È¥ÏÂÔØ¡¢°²×°¡£
ÅäÖÃODBC
ÅäÖÃFreeTDS
FreeTDSµÄÅäÖÃÎļþÔÚ/etc/freetds/freetds.conf
£¨»òÕßÀàËÆµÄµØ·½£©¡£ÓÃ±à¼Æ÷´ò¿ªÕâ¸öÅäÖÃÎļþ£¨ÐèÒªrootȨÏÞ£©£¬²¢Ìí¼ÓÈçÏÂÄÚÈÝ£º
[myTDS]
......
ÔÚWebÓ¦ÓóÌÐòÌØ±ðÊÇWeb2.0³ÌÐò¿ª·¢ÖУ¬¾³£Òª»ñÈ¡Ò³ÃæÖÐij¸öÔªËØ£¬È»ºó¸üиÃÔªËØµÄÑùʽ¡¢ÄÚÈݵȡ£ÈçºÎ»ñȡҪ¸üеÄÔªËØ£¬ÊÇÊ×ÏÈÒª½â¾öµÄÎÊÌâ¡£ÁîÈËÐÀοµÄÊÇ£¬Ê¹ÓÃJavaScript»ñÈ¡½ÚµãµÄ·½·¨ÓкܶàÖÖ£¬ÕâÀï¼òµ¥×öÒ»ÏÂ×ܽᣨÒÔÏ·½·¨ÔÚIE7ºÍFirefox2.0.0.11²âÊÔͨ¹ý£©¡£
1. ͨ¹ý¶¥²ãdocument½Úµã»ñÈ¡£º
(1)document.getElementById(elementId) £º¸Ã·½·¨Í¨¹ý½ÚµãµÄID£¬¿ÉÒÔ׼ȷ»ñµÃÐèÒªµÄÔªËØ£¬ÊDZȽϼòµ¥¿ì½ÝµÄ·½·¨¡£Èç¹ûÒ³ÃæÉϺ¬Óжà¸öÏàͬidµÄ½Úµã£¬ÄÇôֻ·µ»ØµÚÒ»¸ö½Úµã¡£
Èç½ñ£¬ÒѾ³öÏÖÁËÈçprototype¡¢MootoolsµÈ¶à¸öJavaScript¿â£¬ËüÃÇÌṩÁ˸ü¼ò±ãµÄ·½·¨£º$(id)£¬²ÎÊýÈÔÈ»ÊǽڵãµÄid¡£Õâ¸ö·½·¨¿ÉÒÔ¿´×÷ÊÇdocument.getElementById()µÄÁíÍâÒ»ÖÖд·¨£¬²»¹ý$()µÄ¹¦ÄܸüΪǿ´ó£¬¾ßÌåÓ÷¨¿ÉÒԲο¼ËüÃǸ÷×ÔµÄAPIÎĵµ¡£
(2)document.getElementsByName(elementName) £º¸Ã·½·¨ÊÇͨ¹ý½ÚµãµÄname»ñÈ¡½Úµã£¬´ÓÃû×Ö¿ÉÒÔ¿´³ö£¬Õâ¸ö·½·¨·µ»ØµÄ²»ÊÇÒ»¸ö½ÚµãÔªËØ£¬¶øÊǾßÓÐͬÑùÃû³ÆµÄ½ÚµãÊý×顣Ȼºó£¬ÎÒÃÇ¿ÉÒÔͨ¹ýÒª»ñÈ¡½ÚµãµÄij¸öÊôÐÔÀ´Ñ»·ÅжÏÊÇ·ñΪÐèÒªµÄ½Úµã¡£
ÀýÈ磺ÔÚHTMLÖÐcheckboxºÍradio¶¼ÊÇͨ¹ýÏàͬµÄnameÊôÐÔÖµ£¬À´±êʶһ¸ö×éÄÚµÄÔªËØ¡£Èç¹ûÎÒÃÇÏÖÔÚÒª»ñÈ¡±»Ñ¡Öе ......
ÔÚÍøÉÏËÑѰµ½2Öнâ¾ö·½°¸£º
1.ÆäʵֻҪÔÚ±í¸ñ¿ØÖÆÖÐÌí¼ÓÒ»¾ä
<td style="word-break:break-all">¾Í¸ã¶¨ÁË¡£
ÆäÖпÉÄܶÔÓ¢ÎÄ»»ÐпÉÄÜ»á·Ö¿ªÒ»¸öµ¥´ÊÎÊÌ⣺½â¾öÈçÏ£º
Óï·¨£º
word-break : normal | break-all | keep-all
²ÎÊý£º
normal : ¡¡ÒÀÕÕÑÇÖÞÓïÑԺͷÇÑÇÖÞÓïÑÔµÄÎı¾¹æÔò£¬ÔÊÐíÔÚ×ÖÄÚ»»ÐÐ
break-all : ¡¡¸ÃÐÐΪÓëÑÇÖÞÓïÑÔµÄnormalÏàͬ¡£Ò²ÔÊÐí·ÇÑÇÖÞÓïÑÔÎı¾ÐеÄÈÎÒâ×ÖÄÚ¶Ï¿ª¡£¸ÃÖµÊʺϰüº¬Ò»Ð©·ÇÑÇÖÞÎı¾µÄÑÇÖÞÎı¾
keep-all : ¡¡ÓëËùÓзÇÑÇÖÞÓïÑÔµÄnormalÏàͬ¡£¶ÔÓÚÖÐÎÄ£¬º«ÎÄ£¬ÈÕÎÄ£¬²»ÔÊÐí×Ö¶Ï¿ª¡£Êʺϰüº¬ÉÙÁ¿ÑÇÖÞÎı¾µÄ·ÇÑÇÖÞÎı¾
2.style="LEFT: 0px; WIDTH: 100%; WORD-WRAP: break-word" Äã¿ÉÐÞ¸ÄΪָ¶¨µÄ´óСÈç 200px ......