曾俊的专栏

通过命令 brew install rabbitmq 安装时下载 rabbitmq-server-generic-unix-3.8.3.tar.xz 失败？当前文件可通过放入 ~/Library/Caches/Homebrew/downloads 目录下，再次运行命令即可安装成功！

node使用socket.io通过浏览器通信，类似于聊天工具，可以通过调用接口主动从服务器发送消息给到客户端浏览器，也可以从客户端浏览器发送消息给服务器

NodeJS本地上传文件至服务器

支付宝PC端网页支付，只需要配置PID、公钥和私钥即可实现支付功能。同步与异步通知功能也正常可以使用

使用Asp.Net代码编写，只需要替换商户ID、私钥、公钥即可实现支付宝移动网页支付。异步与同步通知都可以使用。

修复在IE10和IE11情况下使用_doPostBack无法提交的问题

一个简单实用类 using Aspose Cells; class AsposeExcel { private string outFileName ""; private string fullFilename ""; private Workbook book null; private Worksheet sheet null; public AsposeExcel string outfilename 导出构造数 { outFileName outfilename; book new Workbook ; sheet book Worksheets[0]; } private void AddTitle string title int rowIndex int columnIndex { Cell cell1 sheet Cells[rowIndex columnIndex]; cell1 PutValue title ; } private void AddHeader DataTable dt int rowIndex int columnIndex { Cell cell null; for int col 0; col < dt Columns Count; col++ { cell sheet Cells[rowIndex col + columnIndex]; cell PutValue dt Columns[col] ColumnName ; } } private void AddBody DataTable dt int rowIndex int columnIndex { for int r 0; r < dt Rows Count; r++ { for int c 0; c < dt Columns Count; c++ { sheet Cells[r + rowIndex c + columnIndex] PutValue dt Rows[r][c] ToString ; } } } 导出 public Boolean DatatableToExcel DataTable dt int rowIndex int columnIndex { Boolean yn false; try { sheet Name sheetName; AddHeader dt rowIndex columnIndex ; AddBody dt rowIndex+1 columnIndex+1 ; sheet AutoFitColumns ; sheet AutoFitRows ; book Save outFileName ; yn true; return yn; } catch Exception e { return yn; } } }">一个简单实用类 using Aspose Cells; class AsposeExcel {

一个简单示例 初始化当前Java线程STA ComThread InitSTA ; ActiveXComponent xl new ActiveXComponent "Excel Application" ; try{ 打开现有的Excel xl setProperty "Visible" new Variant false ; Dispatch workbooks xl getProperty "Workbooks" toDispatch ; Dispatch workbook Dispatch invoke workbooks "Open" Dispatch Method new Object[]{excelPath new Variant false 是否只读 new Variant false } 是否显示打开 new int[1] toDispatch ; 得到所有sheet Dispatch sheets Dispatch get workbook "sheets" toDispatch ; System out println "sheet数量："+Dispatch get sheets "count" toString ; 根据索引得到sheet Dispatch sheet Dispatch invoke sheets "Item" Dispatch Get new Object[]{i} new int[1] toDispatch ; 绘图 Dispatch chartobjects Dispatch call sheet "ChartObjects" toDispatch ; Dispatch achart Dispatch invoke chartobjects "Add" Dispatch Method new Object[] { new Double 12 yHeight 横坐标 纵坐标 new Double 943 new Double 293 宽度 高度 } new int[1] toDispatch ; Dispatch chart Dispatch get achart "chart" toDispatch ; Dispatch range Dispatch invoke sheet "Range" Dispatch Get new Object[] {rangeX rangeY} 列名位置 数据位置 new int[2] toDispatch ; Dispatch series Dispatch call chart "seriescollection" toDispatch ; Dispatch call series "add" range new Variant true ; 生成图形 Dispatch put chart "PlotBy" "2" ; 纵向读取数据绘制chart 设置线条气泡颜色 黄色 Dispatch seriesChartFillFormat Dispatch get series "Fill" toDispatch ; Dispatch seriesForeColor Dispatch get seriesChartFillFormat "ForeColor" toDispatch ; Dispatch put s

正确地SqlServer2008驱动jar包，经过测试可用 public static void main(String[] args) { DBUtil.testSqlServer(); } public static void testSqlServer(){ String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; String url = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=test"; String user = "sa"; String password = "123131"; try{ Class.forName(driver); DriverManager.getConnection(url,user,password); System.out.println("连接SqlServer数据库成功！"); }catch(Exception ex){ ex.printStackTrace(); } }