2016年03月_zhangweibin123

12月 11月 10月 09月 07月 06月 05月 04月 03月

原创在sqlserver中查询注释的函数

create function [dbo].[fun_getNotes](@tableName VARCHAR(50),@fieldName VARCHAR(50))returns varchar(100)as BEGINDECLARE @note VARCHAR(100)select @note=(SELECT TOP 1 cast((SELECT VALUE FROMs

2016-03-31 16:39:15 392

原创 sqlserver跨实例查询方法

--1.exec sp_addlinkedserver 'srv_lnk','','SQLOLEDB','10.1.50.240'--2.exec sp_addlinkedsrvlogin 'srv_lnk','false',null,'sa','sa123'--3.select * from srv_lnk.FlexiCaptureResult.dbo.Accessory

2016-03-30 17:58:28 1701

原创数据库中如何将多条集合拼接成一条返回

create function [dbo].[fun_getUpdateInfo](@ImageCode VARCHAR(100)) --传入参数returns varchar(8000) --返回值as BEGINDECLARE @helpInfo VARCHAR(8000)select

2016-03-29 14:33:13 941

原创在服务器上启动kettle定时任务命令

D:cd D:\data-integrationkitchen /rep xxKettle /dir taby /user admin /pass admin /job tabyToXX_Job /level basic /logfile D:\KettleLog\kettlelog.logpause

2016-03-28 11:13:37 1732

原创 MongoDB数据库命令总结

1.创建数据库命令：use myDB; ----需要注意的是MongoDB中创建数据库是没用的！只有想其中插入数据！此库才可以生效！2.创建集合命令：db.createCollection('dbTset');3.查询所有数据库：show dbs;4.删除当前使用数据库：db.dropDatabase();5.查看当前使用的数据库：db.getName();6.显示当前db状

2016-03-23 18:24:19 276

原创 ketlle中调用User Defined Java Class插件链接数据库并操作

public boolean processRow(StepMetaInterface smi, StepDataInterface sdi) throws KettleException { // First, get a row from the default input hop // Object[] r =

2016-03-22 16:51:51 756

原创 kettle 中Modified Java Script Value插件调用java代码

//传入5个参数的java方法var result=new Packages.org.hy.common.xml.plugins.UnitConvert.convert(v_SourceUnit.getString(),v_TargetUnit.getString(),v_Value.getNumber(),xishu.getNumber(),v_Digit01.get

2016-03-22 16:49:31 1237

<!DOCTYPE html> <HTML> <HEAD> <TITLE> ZTREE DEMO - checkbox</TITLE> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link rel="stylesheet" href="zTreeStyle.css" type="text/css"> <script type="text/javascript" src="jquery-1.4.4.min.js"></script> <script type="text/javascript" src="jquery.ztree.core.js"></script> <script type="text/javascript" src="jquery.ztree.excheck.js"></script> <SCRIPT type="text/javascript"> var setting = {check: {enable: true},data: {simpleData: {enable: true}}}; var zNodes =[ { id:1, pId:0, name:"全选", open:true}, { id:11, pId:1, name:"报表", open:true}, { id:111, pId:11, name:"报表管理",open:true}, { id:112, pId:11, name:"报表概况",open:true}, { id:12, pId:1, name:"我的", open:true}, { id:121, pId:12, name:"修改密码",open:true}, { id:122, pId:12, name:"意见反馈",open:true} ]; $(document).ready(function(){ $.fn.zTree.init($("#treeDemo"), setting, zNodes); var zTree = $.fn.zTree.getZTreeObj("treeDemo"), type = { "Y":'ps', "N":'ps'}; zTree.setting.check.chkboxType = type; }); function aa(){ var treeObj=$.fn.zTree.getZTreeObj("treeDemo"); nodes=treeObj.getCheckedNodes(true); var nodes1 = treeObj.getNodes(); var aa1= treeObj.transformToArray(nodes1); for(var i=0; i < aa1.length;i++){ var node = treeObj.getNodeByParam("id",aa1[i].id ); treeObj.checkNode(node,true,true); treeObj.updateNode(node); } } </SCRIPT> </HEAD> <BODY> <div class="content_wrap"> <div class="zTreeDemoBackground left"> <ul id="treeDemo" class="ztree"></ul> </div> <button value="dianji" onclick="aa()" /> </div> </BODY> </HTML>

2017-09-27

webservice调用天气预报已打包成jar文件

package webser1; import cn.com.WebXml.WeatherUtil; public class _main { public static void main(String[] args) { WeatherUtil w=new WeatherUtil(); for(String temp:w.getWeather("西安")){ System.out.println(temp); } } }

2016-05-11

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人

zhangweibin123的博客