OSCHINA代码分享代码语言代码分类.doc

开源从代码分享开始 分享代码所有标签热门标签jQuery(1163) PHP(473) Python(470) Android SDK(372) Spring(295) MySQL(236) AAuto Quicker(217) Ru(206) Android(205) Hibernate(124) Java(112) JFinal(92) Qt(87) Struts(85) Perl(84) Oracle(79) jsoup(79) ExtJS(75) 排序(74) Windows(74) HttpClient(72) 精华(69) jQuery XML(68) OSCHINA(65) Nginx(64) JDK(59) ThinkPHP(54) 正则表达式(53) Swing(52) JavaScript(52) HTTP(52) Scala(50) JSON(49) MyBatis(48) Excel(48) Bootstrap(47) Apache(45) 字符串(45) 算法(45) Boost(44)TOP40活跃贡献者代码片段文件 Form1.cs 77KB 文件 Form1.Designer.cs 79KB 文件 Program.cs 495B using System;using System.Collections.Generic;using System.Linq;using System.Windows.Forms;将excel表格中具有相同sheet页的模板进行对比计数OSCHINA代码分享代码语言代码分类JavaCC+C#JavaScriptPHPPerlPythonRuRailsHTMLXMLCSSASPBasicDelphiPascalScalaGroovyLuaSQLGoogle GoFlashActionScriptFlexWPFSliverLightShell批处理其他Objective-C排序浏览评论代码 配置文件 pertitsconnection.driverclass=com.mysql.jdbc.Driver#connection.=jdbc:mysql:/08:3306/InvFinAdmin?useUnicode=true&characterEncoding=UTF-8connection.=jdbc:mysql:/:3306/Mybatis?useUnicode=true&characterEncoding=UTF-8connection.username=root#connection.password=2a4c094bbb588e8169connection.password=123456connection.initialPoolSize=10connection.minPoolSize=20connection.maxPoolSize=50connection.maxIdleTime=1800connection.preferredTestQuery=SELECT 1 connection.idleConnectionTestPeriod=18000connection.testConnectionOnCheckout=true pertieslog4j.rootLogger=DEBUG, A1, D namespace ExcelToDB_Form static class Program 应用程序的主入口点。 STAThread static void Main() Application.EnableVisualStyles();Application.SetCompatibleTextRenderingDefault(false);Application.Run(new Form1(); #.apache=INFO,apache 文件 AssemblyInfo.cs 1KB using System.Reflection;using System.Runtime.CompilerServices;using System.Runtime.InteropServices;.springframework.jdbc=DEBUG,spring #.mchange=INFO,mchangelog4j.appender.A1=org.apache.log4j.ConsoleAppender log4j.appender.A1.layout=org.apache.log4j.PatternLayout log4j.appender.A1.layout.ConversionPattern=%-4r %-5p %t %37c %3x - %m%n log4j.appender.D = org.apache.log4j.DailyRollingFileAppender log4j.appender.D.File = logs/error.log log4j.appender.D.Append = true log4j.appender.D.Threshold = ERROR log4j.appender.D.layout = org.apache.log4j.PatternLayout log4j.appender.D.layout.ConversionPattern = %-dyyyy-MM-dd HH:mm:ss %t:%r - %p %m%n 代码 Google Go代码 package mainimport ( io/ioutil net/http net/ fmt encoding/json) /-/ 黄金数据调用示例代码 聚合数据/ 在线接口文档：www/docs/29/- const APPKEY = * /您申请的APPKEY func main() /1.上海黄金交易所 Request1() /2.上海期货交易所 Request2() /3.银行账户黄金 Request3() 有关程序集的常规信息通过以下 特性集控制。更改这些特性值可修改 与程序集关联的信息。/1.上海黄金交易所func Request1() /请求地址 juhe :=web:8080/finance/gold/shgold /初始化参数 param:=.Values /配置请求参数,方法内部已处理encode问题,中文参数可以直接传参 param.Set(key,APPKEY) /APP Key param.Set(v,) /JSON格式版本(0或1)默认为0 /发送请求 data,err:=Get(juhe,param) if err!=nil fmt.Errorf(请求失败,错误信息:rn%v,err) else var netReturn mapstringinterface json.Unmarshal(data,&netReturn) if netReturnerror_code.(float64)=0 fmt.Printf(接口返回result字段是:rn%v,netReturnresult) assembly: AssemblyTitle(ExcelToDB-Form)assembly: AssemblyDescription()assembly: AssemblyConfiguration()assembly: AssemblyCompany(微软中国)assembly: AssemblyProduct(ExcelToDB-Form)/2.上海期货交易所func Request2() /请求地址 juhe :=web:8080/finance/gold/shfuture /初始化参数 param:=.Values /配置请求参数,方法内部已处理encode问题,中文参数可以直接传参 param.Set(key,APPKEY) /APP Key param.Set(v,) /JSON格式版本(0或1)默认为0 assembly: AssemblyCopyright(Copyright 微软中国 2013)assembly: AssemblyTrademark()assembly: AssemblyCulture() /发送请求 data,err:=Get(juhe,param) if err!=nil fmt.Errorf(请求失败,错误信息:rn%v,err) else var netReturn mapstringinterface json.Unmarshal(data,&netReturn) if netReturnerror_code.(float64)=0 fmt.Printf(接口返回result字段是:rn%v,netReturnresult) /3.银行账户黄金func Request3() /请求地址 juhe :=web:8080/finance/gold/bankgold /初始化参数 param:=.Values /配置请求参数,方法内部已处理encode问题,中文参数可以直接传参 param.Set(key,APPKEY) /APP Key /发送请求 data,err:=Get(juhe,param) if err!=nil fmt.Errorf(请求失败,错误信息:rn%v,err) else var netReturn mapstringinterface json.Unmarshal(data,&netReturn) if netReturnerror_code.(float64)=0 fmt.Printf(接口返回result字段是:rn%v,netReturnresult) / get 网络请求func Get(api string,params .Values)(rsbyte ,err error) var *. ,err=.Parse(api) if err!=nil fmt.Printf(解析错误:rn%v,err) return nil,err /如果参数中有中文参数,这个方法会进行Encode .RawQuery=params.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 网络请求 ,params 是.Values类型func Post(api string, params .Values)(rsbyte,err error) resp,err:=http.PostForm(api, params) if err!=nil return nil ,err defer resp.Body.Close() return ioutil.ReadAll(resp.Body)代码描述：基于GO的黄金数据接口调用代码实例关联数据：黄金数据代码 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; /-/ 黄金数据调用示例代码 聚合数据/ 在线接口文档：www/docs/29/ 代码中JsonObject类下载地址:/download/gcm3206021155665/7458439/- namespace ConsoleAPI class Program static void Main(string args) string appkey = *; /配置您申请的appkey /1.上海黄金交易所 string 1 = web:8080/finance/gold/shgold; var parameters1 = new Dictionary(); parameters1.Add(key, appkey);/你申请的key parameters1.Add(v , ); /JSON格式版本(0或1)默认为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.Value+:+newObj1reason.Value); /2.上海期货交易所 string 2 = web:8080/finance/gold/shfuture; var parameters2 = new Dictionary(); 将 ComVisible 设置为 false 使此程序集中的类型 对 COM 组件不可见。如果需要从 COM 访问此程序集中的类型， 则将该类型上的 ComVisible 特性设置为 true。assembly: ComVisible(false) parameters2.Add(key, appkey);/你申请的key parameters2.Add(v , ); /JSON格式版本(0或1)默认为0 string result2 = sendPost(2, parameters2, get); JsonObject newObj2 = new JsonObject(result2); String errorCode2 = 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(key, appkey);/你申请的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+:+newObj3reason.Value); / / Http (GET/POST) / / 请求 / 请求参数 / 请求方法 / 响应内容 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(); 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(postData, 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 /创建请求 HttpWebRequest request = (HttpWebRequest)WebRequest.Create( + ? + BuildQuery(parameters, utf8); /GET请求 request.Method = GET; request.ReadWriteTimeout = 5000; request.ContentType = text/html;charset=UTF-8; HttpWebResponse response = (HttpWebResponse)request.GetResponse(); Stream myResponseStream = response.GetResponseStream(); StreamReader myStreamReader = new StreamReader(myResponseStream, Encoding.GetEncoding(utf-8); /返回内容 string retString = myStreamReader.ReadToEnd(); return retString; / / 组装普通文本请求参数。 / / Key-Value形式请求参数字典 / 编码后的请求数据 static string BuildQuery(IDictionary parameters, string 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; / 忽略参数名或参数值为空的参数 if (!string.IsNullOrEmpty(name)/& !string.IsNullOrEmpty(value) 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; return postData.ToString(); / / 把响应流转换为文本。 / / 响应流对象 / 编码方式 / 响应文本 static string GetResponseAsString(HttpWebResponse rsp, Encoding encoding) System.IO.Stream stream = null; StreamReader reader = null; try / 以字符流的方式读取HTTP响应 stream = rsp.GetResponseStream(); reader = new StreamReader(stream, encoding); return reader.ReadToEnd(); finally / 释放资源 if (reader != null) reader.Close(); if (stream != null) stream.Close(); if (rsp != null) rsp.Close(); 代码 PHP代码 /* * c远程传输工具 */public function post_c($,$body,$header,$type=POST) $ch = c_init(); c_setopt($ch,COPT_,$); c_setopt($ch,COPT_HEADER,0);/0只要正文 c_setopt($ch,COPT_TIMEOUT,5);/设置超时时间 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); if(count($body)0) c_setopt($ch,COPT_POSTFIELDS,$body); if(count($header)0) c_setopt($ch,COPT_HTTPHEADER,$header); /设置上传文件相关 c_setopt($ch,COPT_FOLLOWLOCATION,true); c_setopt($ch,COPT_MAXREDIRS,3);/递归 c_setopt($ch,COPT_SSL_VERIFYPEER,false);/ 对认证证书来源的检查 c_setopt($ch,COPT_SSL_VERIFYHOST,0);/ 从证书中检查SSL加密算法 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; /上传文件相关设置 c_setopt($ch,COPT_ENCODING,gzip); c_setopt($ch,COPT_USERAGENT,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);/关闭c资源，并且释放系统资源 $result = json_decode($content,true); if(!empty($result) return $result; else return $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 -o teststu*/#include /*建立通讯区域*/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 of 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; EXEC SQL END DECLARE SECTION;/*错误处理*/ EXEC SQL WHENEVER SQLERROR CALL error_handler(); EXEC SQL WHENEVER SQLWARNING CALL warning_handler(); EXEC SQL WHENEVER NOT FOUND CONTINUE;/*连接到 SQL SERVER 服务器*/ /* * 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); strc