`
pepple
  • 浏览: 39717 次
  • 性别: Icon_minigender_1
  • 来自: 亳州
社区版块
存档分类
最新评论
文章列表
-----------------第一.解析json数组----------------- data为发送ajax请求从后台取到的数据,形如: [     {         "id": "49",         "title": "修改后的插入和更新..."     },     {         "id": "19",         "title": "限制文件大小"     } ] var str = eval(&quo ...

mysql循环

DROP PROCEDURE test_insert ; DELIMITER ;; CREATE PROCEDURE test_insert () begin declare nid int; set nid=1; while nid<23 DO set nid=nid+1; end while; end;; -- 调用和创建存储过程,分两步执行 call test_insert ();
grant all on *.* to root@'%' identified by 'password'; -- 此处的password为实际密码,可替换
OutputFormat format = new OutputFormat(); format.setEncoding("UTF-8"); format.setIndent(true); // 设置是否缩进 format.setIndent(" "); // 以空格方式实现缩进 format.setNewlines(true); format.setTrimText(true); [b][size=large][color=blue]format.setExpandEmptyElements(true);[/ ...
1.生成aar文件 jar cvf xxxx.aar -C D:\WorkSpace\myaxis2\bin . 说明:最后的点不能少 2.准备services.xml文件 <!--service标签的name属性值自定义,parameter标签的值为提供webservice服务的类的全名 --> <service name="tran" > <description> Please Type your service description here </description> < ...
declare @count int declare @total int set @total=0 declare @tablename varchar(100) declare @sql nvarchar(4000) declare mycursor cursor for select name from sysobjects where name like 'table____' open mycursor fetch next from mycursor into @tablename while(@@FETCH_STATUS=0) begin set @s ...

杂谈1

1.有肚量容忍不能改变的事,有勇气改变可能改变的事,有智慧区别这两类事.
keytool -import -file ../server/server.cer -keystore client.truststore -alias server
SELECT sysobjects.name AS 表名, syscolumns.name AS 列名, systypes.name AS 数据类型, syscolumns.length AS 数据长度 FROM sysobjects INNER JOIN syscolumns ON sysobjects.id = syscolumns.id INNER JOIN systypes ON syscolumns.xtype = systypes.xtype WHERE (sysobjects.xtype = 'u' OR sysobjects.xty ...
select cast(cast(字段 as decimal(18,0)) as varchar)
import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.codehaus.xfire.client.XFireProxyFactory; import or ...
declare @count int declare @tablename varchar(100) declare @sql nvarchar(4000) declare mycursor cursor for select name from sysobjects where name like 'test____' open mycursor fetch next from mycursor into @tablename while(@@FETCH_STATUS=0) begin set @sql='select @count=COUNT(*) from ' + @tablename ...
1. Help-->install new software: 2. Work with选择:Indigo - http://download.eclipse.org/releases/Indigo 根据你的版本不同,Indigo可能是Helios,Juno等... 3. 过滤框输入 dali,然后过滤出来的几个勾上,下一步、确定之类的一路下去就行了
SELECT  SUSER_SID ('test')  --查询sid用户 sp_addlogin 'roiland','test','master' go EXEC sp_grantdbaccess 'test', 'test' go sp_addrolemember 'db_owner','test' go 2005重新安装数据库服务器上,备份还原的用户不可用的处理方案 sp_change_users_login 'report' sp_addlogin 'test','test','master' go exec sp_change_users_login 'AUTO_FIX','t ...
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <link rel="stylesheet" href="<%=basePath%>404page/c ...
Global site tag (gtag.js) - Google Analytics