rabbitmq-server-generic-unix-3.8.3.tar.xz 离线包
通过命令 brew install rabbitmq 安装时下载 rabbitmq-server-generic-unix-3.8.3.tar.xz 失败?当前文件可通过放入 ~/Library/Caches/Homebrew/downloads 目录下,再次运行命令即可安装成功!
通过命令 brew install rabbitmq 安装时下载 rabbitmq-server-generic-unix-3.8.3.tar.xz 失败?当前文件可通过放入 ~/Library/Caches/Homebrew/downloads 目录下,再次运行命令即可安装成功!
node使用socket.io通过浏览器通信,类似于聊天工具,可以通过调用接口主动从服务器发送消息给到客户端浏览器,也可以从客户端浏览器发送消息给服务器
一个简单实用类 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 { private string outFileName ""; private string fullFilename ""; private Workbook book null; private Worksheet sheet null; public AsposeExcel string outfilename 导 [更多]
一个简单示例 初始化当前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 seriesForeColor "SchemeColor" "18" ; 设置绘图区背景色为透明 Dispatch plotArea Dispatch get chart "PlotArea" toDispatch ; Dispatch plotAreaInterior Dispatch get plotArea "Interior" toDispatch ; Dispatch put plotAreaInterior "ColorIndex" " 4142" ; 设置标题 Dispatch chartTitle Dispatch get chart "ChartTitle" toDispatch ; Dispatch put chartTitle "Text" params[paramIndex][0] ; 设置图例位置 Dispatch legend Dispatch get chart "Legend" toDispatch ; Dispatch put legend "Position" " 4160" ; 设置图表背景色 Dispatch chartArea Dispatch get chart "ChartArea" toDispatch ; Dispatch chartFillFormat Dispatch get chartArea "Fill" toDispatch ; Dispatch fc Dispatch get chartFillFormat "ForeColor" toDispatch ; Dispatch put fc "SchemeColor" "35" ; 保存 Dispatch call workbook "Save" ; Dispatch call workbook "Close" new Variant false ; xl invoke "Quit" new Variant[] {} ; }catch Exception ex { ex printStackTrace ; } finally { 释放 com 资源 xl invoke "Quit" new Variant[] {} ; ComThread Release ; System out println " 处理完成 " ; }">一个简单示例 初始化当前Java线程STA ComThread InitSTA ; ActiveXComponent xl new ActiveXComponent "Excel Application" ; try{ 打开现有的Excel xl setProperty "Visible" new Variant false ; Dispatch workbooks xl getProperty "Workbooks" toDis [更多]
正确地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(); } }