課件與代碼js-day04培訓(xùn)內(nèi)容

1、培訓(xùn)要1）掌jQuery AJAX- Oracle過(guò)培訓(xùn)要1）掌jQuery AJAX- Oracle過(guò)程與函一）jQuery AJAX-簡(jiǎn)單形式：jQuery 對(duì)象jQuery 對(duì)象代表的Servlet GET 復(fù)雜形式：jQuery 對(duì)象sendData=JSON T load方法而言，如果請(qǐng)求體無(wú)參數(shù)發(fā)送的話，load方法GET 方式提交load 方法而言，如果請(qǐng)求體有參數(shù)發(fā)送的話，load T load scriptvar url =ime+new Date().getTime();varsendData=var jsonJAVA = ajax.responseText; varjso

2、nJS=eval(+jsonJAVA+); var strTime = jsonJS.strTime;參數(shù)一：url ey:參數(shù)一：url ey:alue,ey:alue參數(shù)三：function 處理函數(shù)，類似于傳統(tǒng)方式ajax.onreadysechange = 處理函數(shù)function處理函數(shù)最多可以接收三個(gè)參數(shù)，含義如下第二個(gè)參數(shù)：服務(wù)端狀態(tài)碼的文本描述，例如：第三個(gè)參數(shù)：ajx XMLHtpequet gett （3）jQuery 對(duì)象JSON jQuery name name script/定位按鈕，同時(shí)添加單擊事/獲取用戶名var username = $(:text:var pa

3、ssword = $(:text:last).val();/去空username=$.trim(username); password=/異步發(fā)送到服務(wù)varurlw Date().getTime();/*手工書寫JSON文var sendData = /*工具生成JSON文本varsendData=publicclassRegisterActionpublicclassRegisterActionprivateUserpublicUsergetUser()returnpublicvoidsetUser(Useruser)this.user=檢用戶名是否存publicStringcheckMe

4、thod()throwsException tip = images/MsgSent.gif;if(帥帥.equals(user.getUsername() tip=returnprivateStringpublicStringgetTip()returnvarbackData=/backData是一個(gè)JSON文本/對(duì)象，你得通過(guò).其vartip=/創(chuàng)建img節(jié)/清空span節(jié)點(diǎn)中的內(nèi)/將img節(jié)點(diǎn)添加到span節(jié)點(diǎn)$(span).append($img（5）省份-（5）省份-jQuery的AJAX Struts2 AJAXscriptvar url =var sendData = null;

5、/將xml文件轉(zhuǎn)成jquery對(duì)象，目的是用jqueryxml文var$xml=var$city=/獲取每一個(gè)city節(jié)varcity=$(this).text(); varxml=ajax.responseXML; var $xml = $(xml);var$city=/獲取每一個(gè)city節(jié)varcity=$(this).text(); ?xml=1.0encoding=UTF-廣州中山佛山 keyscript keyscript/刪除原城市下拉框中的內(nèi)容，除第一項(xiàng)$(#cityoption:gt(0).remove(); var province = $(#provinceif(選擇省份o

6、vince?time=+new Date().getTime(),/js對(duì)varcity=/jquery對(duì)var$city=/this表示每個(gè)城var$option=$(+this$(#city).append($optionselect選擇省份湖南select選擇城市packagename=packagename=timePackageextends=json-default global-resultname=ok/global-publicclassProvinceCityActionprivateStringpublicvoidtringprovince)vince=p

7、ublicStringfindCityByProvince()throwsException cityList = new ArrayList();cityList.add(湛江cityList.add(汕頭elseif(湖南.equals(province) cityList.add(瀏陽(yáng)returnistpublicListgetCityList()returnvarbackData=cityList:邵陽(yáng),瀏陽(yáng) -createorreplaceprocedureget_rax(salaryinnumber,raxoutnumber) bal number;bal:=salary-3500

8、; if bal=1500 thenrax:=bal*0.03-0; elsif bal=4500 thenrax:=bal*0.1-105; elsif bal=9000 thenrax:=bal*0.2-555; elsif bal=35000 thenrax:=bal*0.25-1005; elsif bal=55000 thenrax:=bal*0.3-2755; elsif bal=80000 thenrax:=bal*0.35-!-檢查用戶名是否存在-7788 -create or7788 -create or replace function findEmpNameAndJobA

9、ndSal(pempno in numbjob out varchar2,psal out number)penameemp.ename%type; select ename,job,salopename,pjob,psalfromempwhereempno=pempno; return pename;publicclassTestCallOracleProcpublic sicvoidmain(Stringargs)throwsException String sql = call get_rax(?,?);Connection conn = JdbcUtil.getConnection()

10、; ementcstmt=conn.prepareCall(sql); egerrax=ln(10000元需要交rax元稅); rax:=bal*0.45-13505; end if;/-raxsalarynumber:=&salary; /1）基于jQuery 的AJAX 應(yīng)1）基于jQuery 的AJAX 應(yīng)省/市/publicclassTestCallOracleFuncpublic sic void main(String args) throws Exception Stringsql=?=callfindEmpNameAndJobAndSal(?,?,?); Connection conn = JdbcUtil.getConnection();ementcstmt=conn.prepareCall(sql)