CodeIgniter查詢分頁代碼AndroidSQLiteCursor

1、CodeIgniter查詢分頁代碼/Android SQLite Cursor ,同時(shí)測試代碼中的c遠(yuǎn)程傳輸工具java開發(fā)的代碼生成器 入口，讀LED3數(shù)據(jù)，判斷是否打開成功 while(LED3 = 1); P1DIR |= 0x10; TxData2 = 4; TxData3 = 3; TxData4 = 0; TxData5 = 0; TxData6 = 1; UartSendString(TxData, 8); if(RxData4 = 4) /寫LED4 if(RxData6 = 1) LED4 = ON; P0DIR &= 0xFD; /設(shè)置LED4為輸入口，讀LED4數(shù)據(jù)，判斷

2、是否打開成功/Java的輸入語句 /JSON轉(zhuǎn)OC對(duì)象 while(LED4 != 1); P0DIR |= 0x02; TxData2 = 4; TxData3 = 4; TxData4 = 0; TxData5 = 0; TxData6 = 1; UartSendString(TxData, 8); else LED4 = OFF; P0DIR &= 0xFD; /設(shè)置LED4為輸入口，讀LED2數(shù)據(jù)，判斷是否打開成功 while(LED4 = 1); P0DIR |= 0x02; TxData2 = 4; TxData3 = 4; TxData4 = 0; TxData5 = 0; Tx

3、Data6 = 1; UartSendString(TxData, 8); if(RxData3 = 5) /寫繼電器 if(RxData6 = 1) DELAY = ON; P1DIR &= 0xEF; while(DELAY != 1); P1DIR |= 0x10; TxData2 = 5; TxData3 = 0; TxData4 = 0; TxData5 = 0; TxData6 = 1; UartSendString(TxData, 8); else DELAY = OFF; P1DIR &= 0xEF; while(DELAY = 1); P1DIR |= 0x10; TxDat

4、a2 = 5; TxData3 = 0; TxData4 = 0; TxData5 = 0; TxData6 = 1; UartSendString(TxData, 8); UartState = UART0_RX; count = 0; memset(RxData, 0, SIZE); /清空接收緩沖區(qū) /控制LED CONTROL_LED 代碼 Google Go代碼 package mainimport ( io/ioutil net/http net/ fmt encoding/json) /-/ 黃金數(shù)據(jù)調(diào)用示例代碼 聚合數(shù)據(jù)/ 在線接口文檔：www/docs/29/- const

5、APPKEY = * /您申請(qǐng)的APPKEY func main() /1.上海黃金交易所 Request1() /2.上海期貨交易所 Request2() /3.銀行賬戶黃金 Request3() /1.上海黃金交易所func Request1() /請(qǐng)求地址 juhe :=web:8080/finance/gold/shgold /初始化參數(shù) param:=.Values /配置請(qǐng)求參數(shù),方法內(nèi)部已處理encode問題,中文參數(shù)可以直接傳參 param.Set(key,APPKEY) /APP Key param.Set(v,) /JSON格式版本(0或1)默認(rèn)為0 /發(fā)送請(qǐng)求 data,

6、err:=Get(juhe,param) if err!=nil fmt.Errorf(請(qǐng)求失敗,錯(cuò)誤信息:rn%v,err) else var netReturn mapstringinterface json.Unmarshal(data,&netReturn) if netReturnerror_code.(float64)=0 fmt.Printf(接口返回result字段是:rn%v,netReturnresult) /2.上海期貨交易所func Request2() /請(qǐng)求地址 juhe :=web:8080/finance/gold/shfuture /初始化參數(shù) param:=

7、.Values /配置請(qǐng)求參數(shù),方法內(nèi)部已處理encode問題,中文參數(shù)可以直接傳參 param.Set(key,APPKEY) /APP Key param.Set(v,) /JSON格式版本(0或1)默認(rèn)為0 /發(fā)送請(qǐng)求 data,err:=Get(juhe,param) if err!=nil fmt.Errorf(請(qǐng)求失敗,錯(cuò)誤信息:rn%v,err) else var netReturn mapstringinterface json.Unmarshal(data,&netReturn) if netReturnerror_code.(float64)=0 fmt.Printf(接口

8、返回result字段是:rn%v,netReturnresult) /3.銀行賬戶黃金func Request3() /請(qǐng)求地址 juhe :=web:8080/finance/gold/bankgold /初始化參數(shù) param:=.Values /配置請(qǐng)求參數(shù),方法內(nèi)部已處理encode問題,中文參數(shù)可以直接傳參 param.Set(key,APPKEY) /APP Key /發(fā)送請(qǐng)求 data,err:=Get(juhe,param) if err!=nil fmt.Errorf(請(qǐng)求失敗,錯(cuò)誤信息:rn%v,err) else var netReturn mapstringinterf

9、ace json.Unmarshal(data,&netReturn) if netReturnerror_code.(float64)=0 fmt.Printf(接口返回result字段是:rn%v,netReturnresult) / get 網(wǎng)絡(luò)請(qǐng)求func Get(api string,params .Values)(rsbyte ,err error) var *. ,err=.Parse(api) if err!=nil fmt.Printf(解析錯(cuò)誤:rn%v,err) return nil,err /如果參數(shù)中有中文參數(shù),這個(gè)方法會(huì)進(jìn)行Encode .RawQuery=para

10、ms.Encode() resp,err:=http.Get(.String() if err!=nil fmt.Println(err:,err) return nil,err defer resp.Body.Close() return ioutil.ReadAll(resp.Body) / post 網(wǎng)絡(luò)請(qǐng)求 ,params 是.Values類型func Post(api string, params .Values)(rsbyte,err error) resp,err:=http.PostForm(api, params) if err!=nil return nil ,err de

11、fer resp.Body.Close() return ioutil.ReadAll(resp.Body)代碼描述：基于GO的黃金數(shù)據(jù)接口調(diào)用代碼實(shí)例關(guān)聯(lián)數(shù)據(jù)：黃金數(shù)據(jù)代碼 C#代碼 using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Net;using System.IO;using Xfrog.Net;using System.Diagnostics;using System.Web; /-/ 黃金數(shù)據(jù)調(diào)用示例代碼 聚合數(shù)據(jù)/ 在線接口文檔：www/d

12、ocs/29/ 代碼中JsonObject類下載地址:/download/gcm3206021155665/7458439/- namespace ConsoleAPI class Program static void Main(string args) string appkey = *; /配置您申請(qǐng)的appkey /1.上海黃金交易所 string 1 = web:8080/finance/gold/shgold; var parameters1 = new Dictionary(); parameters1.Add(key, appkey);/你申請(qǐng)的key parameters1.

13、Add(v , ); /JSON格式版本(0或1)默認(rèn)為0 string result1 = sendPost(1, parameters1, get); JsonObject newObj1 = new JsonObject(result1); String errorCode1 = newObj1error_code.Value; if (errorCode1 = 0) Debug.WriteLine(成功); Debug.WriteLine(newObj1); else /Debug.WriteLine(失敗); Debug.WriteLine(newObj1error_code.Val

14、ue+:+newObj1reason.Value); /2.上海期貨交易所 string 2 = web:8080/finance/gold/shfuture; var parameters2 = new Dictionary(); parameters2.Add(key, appkey);/你申請(qǐng)的key parameters2.Add(v , ); /JSON格式版本(0或1)默認(rèn)為0 string result2 = sendPost(2, parameters2, get); JsonObject newObj2 = new JsonObject(result2); String er

15、rorCode2 = newObj2error_code.Value; if (errorCode2 = 0) Debug.WriteLine(成功); Debug.WriteLine(newObj2); else /Debug.WriteLine(失敗); Debug.WriteLine(newObj2error_code.Value+:+newObj2reason.Value); /3.銀行賬戶黃金 string 3 = web:8080/finance/gold/bankgold; var parameters3 = new Dictionary(); parameters3.Add(k

16、ey, appkey);/你申請(qǐng)的key string result3 = sendPost(3, parameters3, get); JsonObject newObj3 = new JsonObject(result3); String errorCode3 = newObj3error_code.Value; if (errorCode3 = 0) Debug.WriteLine(成功); Debug.WriteLine(newObj3); else /Debug.WriteLine(失敗); Debug.WriteLine(newObj3error_code.Value+:+newO

17、bj3reason.Value); / / Http (GET/POST) / / 請(qǐng)求 / 請(qǐng)求參數(shù) / 請(qǐng)求方法 / 響應(yīng)內(nèi)容 static string sendPost(string , IDictionary parameters, string method) if (method.ToLower() = post) HttpWebRequest req = null; HttpWebResponse rsp = null; System.IO.Stream reqStream = null; try req = (HttpWebRequest)WebRequest.Create(

18、); req.Method = method; req.KeepAlive = false; req.ProtocolVersion = HttpVersion.Version10; req.Timeout = 5000; req.ContentType = application/x-www-form-encoded;charset=utf-8; byte postData = Encoding.UTF8.GetBytes(BuildQuery(parameters, utf8); reqStream = req.GetRequestStream(); reqStream.Write(pos

19、tData, 0, postData.Length); rsp = (HttpWebResponse)req.GetResponse(); Encoding encoding = Encoding.GetEncoding(rsp.CharacterSet); return GetResponseAsString(rsp, encoding); catch (Exception ex) return ex.Message; finally if (reqStream != null) reqStream.Close(); if (rsp != null) rsp.Close(); else /創(chuàng)

20、建請(qǐng)求 HttpWebRequest request = (HttpWebRequest)WebRequest.Create( + ? + BuildQuery(parameters, utf8); /GET請(qǐng)求 request.Method = GET; request.ReadWriteTimeout = 5000; request.ContentType = text/html;charset=UTF-8; HttpWebResponse response = (HttpWebResponse)request.GetResponse(); Stream myResponseStream

21、= response.GetResponseStream(); StreamReader myStreamReader = new StreamReader(myResponseStream, Encoding.GetEncoding(utf-8); /返回內(nèi)容 string retString = myStreamReader.ReadToEnd(); return retString; / / 組裝普通文本請(qǐng)求參數(shù)。 / / Key-Value形式請(qǐng)求參數(shù)字典 / 編碼后的請(qǐng)求數(shù)據(jù) static string BuildQuery(IDictionary parameters, strin

22、g encode) StringBuilder postData = new StringBuilder(); bool hasParam = false; IEnumeratorKeyValuePair dem = parameters.GetEnumerator(); while (dem.MoveNext() string name = dem.Current.Key; string value = dem.Current.Value; / 忽略參數(shù)名或參數(shù)值為空的參數(shù) if (!string.IsNullOrEmpty(name)/& !string.IsNullOrEmpty(val

23、ue) if (hasParam) postData.Append(&); postData.Append(name); postData.Append(=); if (encode = gb2312) postData.Append(HttpUtility.Encode(value, Encoding.GetEncoding(gb2312); else if (encode = utf8) postData.Append(HttpUtility.Encode(value, Encoding.UTF8); else postData.Append(value); hasParam = true

24、; return postData.ToString(); / / 把響應(yīng)流轉(zhuǎn)換為文本。 / / 響應(yīng)流對(duì)象 / 編碼方式 / 響應(yīng)文本 static string GetResponseAsString(HttpWebResponse rsp, Encoding encoding) System.IO.Stream stream = null; StreamReader reader = null; try / 以字符流的方式讀取HTTP響應(yīng) stream = rsp.GetResponseStream(); reader = new StreamReader(stream, encodin

25、g); return reader.ReadToEnd(); finally / 釋放資源 if (reader != null) reader.Close(); if (stream != null) stream.Close(); if (rsp != null) rsp.Close(); 代碼 PHP代碼 /* * c遠(yuǎn)程傳輸工具 */public function post_c($,$body,$header,$type=POST) $ch = c_init(); c_setopt($ch,COPT_,$); c_setopt($ch,COPT_HEADER,0);/0只要正文 c_s

26、etopt($ch,COPT_TIMEOUT,5);/設(shè)置超時(shí)時(shí)間 c_setopt($ch,COPT_CONNECTTIMEOUT,5); /將c_exec()獲取的信息以文件流的形式返回，而不是直接輸出。 c_setopt($ch,COPT_RETURNTRANSFER,1); /增加header頭信息 / array_push($header,Accept:application/json); / array_push($header,Content-Type:application/json); / array_push($header,http:multipart/form-data

27、); if(count($body)0) c_setopt($ch,COPT_POSTFIELDS,$body); if(count($header)0) c_setopt($ch,COPT_HTTPHEADER,$header); /設(shè)置上傳文件相關(guān) c_setopt($ch,COPT_FOLLOWLOCATION,true); c_setopt($ch,COPT_MAXREDIRS,3);/遞歸 c_setopt($ch,COPT_SSL_VERIFYPEER,false);/ 對(duì)認(rèn)證證書來源的檢查 c_setopt($ch,COPT_SSL_VERIFYHOST,0);/ 從證書中檢查S

28、SL加密算法 switch ($type) case GET: c_setopt($ch,COPT_HTTPGET,1); break; case POST: c_setopt($ch,COPT_POST,1); break; case PUT: c_setopt($ch,COPT_CUSTOMREQUEST,PUT); break; case DELETE: c_setopt($ch,COPT_CUSTOMREQUEST,DELETE); break; /上傳文件相關(guān)設(shè)置 c_setopt($ch,COPT_ENCODING,gzip); c_setopt($ch,COPT_USERAGEN

29、T,SSTS Browser/1.0); c_setopt($ch,COPT_USERAGENT,Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0; Trident/4.0);/ 模擬用戶使用的瀏覽器 if(c_errno($ch) return c_error($ch); $content = c_exec($ch); c_close($ch);/關(guān)閉c資源，并且釋放系統(tǒng)資源 $result = json_decode($content,true); if(!empty($result) return $result; else return

30、 $content; 代碼 C/C+代碼 /*編譯指令$ /opt/sybase/OCS-16_0/bin/cpre64 -m teststu.cp$ cc -m64 -g -DSYB_LP64 -I. -I/opt/sybase/OCS-16_0/include teststu.c /opt/sybase/OCS-16_0/include/sybesql.c -L/opt/sybase/OCS-16_0/lib -lsybct64 -lsybtcl64 -lsybcs64 -lsybcomn64 -lsybintl64 -lsybunic64 -rdynamic -ldl -lnsl -lm

31、 -o teststu*/#include /*建立通訊區(qū)域*/EXEC SQL INCLUDE SQLCA;/* * These tokens must be declared in a declare section* because they are used in declare sections below.*/EXEC SQL BEGIN DECLARE SECTION;#define TYPESIZE 13#define TIDSIZE 6EXEC SQL END DECLARE SECTION; #define EOLN 0/* * Forward declarations o

32、f the error and message handlers and* other subroutines called from main().*/void error_handler();void warning_handler(); intmain(int argc, char *argv)/*聲明宿主變量*/ EXEC SQL BEGIN DECLARE SECTION; /* storage for login name and password. */ char username30; char sname30; char password30; char server30;

33、EXEC SQL END DECLARE SECTION;/*錯(cuò)誤處理*/ EXEC SQL WHENEVER SQLERROR CALL error_handler(); EXEC SQL WHENEVER SQLWARNING CALL warning_handler(); EXEC SQL WHENEVER NOT FOUND CONTINUE;/*連接到 SQL SERVER 服務(wù)器*/ /* * Copy the user name and password defined in sybsqlex.h to * the variables declared for them in the declare section. */ strcpy(username, mymotif); strcpy(password, wxwpxh); strcpy(server, MYMOTIFVOSTRO145480); E