`
文章列表
我的CSDN博客地址:http://blog.csdn.net/qidong7 function logout(){         if(confirm("确定要退出吗?")){                  var browserName=navigator.appName;                  if (browserName=="Netscape"){                        alert('chrome');                        window.open('', '_self', ' ...

删除.svn文件

请关注新浪微博 账号:大数据进行时(http://weibo.com/u/3272022684) 1、新建 .reg 文件(如deleteSVN.reg) Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Folder\shell\DeleteSVN] @="Delete SVN Folders" [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Folder\shell\DeleteSVN\command] @="cmd.exe /c ...

sql 基础 5 树查询

    博客分类:
  • sql
请关注新浪微博 账号:大数据进行时(http://weibo.com/u/3272022684) select * from (select t.postid, t.name, t.parentid from gaus_postinfo t start with t.parentid ='GAUS_POSTINFO_8e29081b-8cba-41be-a1da-fdba0ba94a86' connect by prior t.postid = t.parentid )treeTable --查看树 select * from ...

sql 基础 4 树查询

    博客分类:
  • sql
请关注新浪微博 账号:大数据进行时(http://weibo.com/u/3272022684) 1、 从叶子节点依据id=pid的关系向上递归到跟节点。 select t.*, t.rowid from indicators t start with (t.isleaf='1' and t.rid='26020') connect by prior t.pid = t.id order by t.inum 从跟节点依据id=pid的关系向下递归至叶子节点. select t.*, t.rowid from indicators t start with (t.pid='0' ...

sql 基础 3

    博客分类:
  • sql
请关注新浪微博 账号:大数据进行时(http://weibo.com/u/3272022684) 1、插入数据 insert into table_name(cloumn1,column2,...) values(value1,value2,...) insert into table_name values(value1,value2,...) 2、复制表结构 create table as select * from dept where 1=0; 3、复制行 insert into table_name(column1,column2,...) ...

sql 基础 2

    博客分类:
  • sql
请关注新浪微博 账号:大数据进行时(http://weibo.com/u/3272022684) 1、order by select name,sal,comm from emp order by 3; -- comm 2、空值排序、或者空值排在前面或后面 使用 case 来标记 select ename,sal,common from( select ename,sal,common, case when common is null then 0 else 1 end as is_null from emp ) x order by is_nu ...
请关注新浪微博 账号:大数据进行时(http://weibo.com/u/3272022684) 1、 and 的优先级 高于 or 2、as select sal as salary, comm as commission from emp 3、连接字符串 Oracle/DB2/PostgreSQL: select ename||' WORKS AS A '||job as msg from emp where deptno=10; mysql select concat(ename,'WORKS AS A',job ...
请关注新浪微博 账号:大数据进行时(http://weibo.com/u/3272022684) <?xml version="1.0" encoding="UTF-8"?> <project name="TestWar" default="run" basedir="."> <description> 通过拷贝的方式发布项目 </description> <property name="TOMCAT_HOM ...

ant 学习之 其他

    博客分类:
  • ant
请关注新浪微博 账号:大数据进行时(http://weibo.com/u/3272022684) <?xml version="1.0" encoding="UTF-8"?> <project name="TestOther" default="run" basedir="."> <description> 测试其他的ant功能 </description> <!-- 获取时间 --> <t ...

ant 学习之 file

    博客分类:
  • ant
<?xml version="1.0" encoding="UTF-8"?> <!-- basedir 是上一层目录 E:\myworkspace\AntSql\ant --> <project name="TestFileOperation" default="run" basedir=".."> <property name="src" value="./temp/src"/> <pr ...
<?xml version="1.0" encoding="UTF-8"?> <project name="TestWar" default="war" basedir="."> <description> 打WAR包 </description> <property name="TOMCAT_HOME" value="E:/work/my-project-apache-tomcat-6.0 ...
<?xml version="1.0" encoding="UTF-8"?> <project name="TestJavaDoc" default="run" basedir="."> <property name="TOMCAT_HOME" value="E:/work/my-project-apache-tomcat-6.0.18" /> <property name="JAVA_HOM ...
<?xml version="1.0" encoding="UTF-8"?> <project name="TestJar" default="run" basedir="."> <property name="TOMCAT_HOME" value="E:/work/my-project-apache-tomcat-6.0.18" /> <property name="JAVA_HOME ...
<?xml version="1.0" encoding="UTF-8"?> <project name="TestCompile" default="run" basedir="."> <description> 如何编译java文件 </description> <property name="TOMCAT_HOME" value="E:/work/my-project-apache-t ...
build.bat文件: :: 配置 ant 需要的环境变量 @echo off SET TOMCAT_HOME=E:\work\my-project-apache-tomcat-6.0.18 SET DEPENDS_HOME=E:\myworkspace\AntSql\depends SET OUTPUT_HOME=E:\myworkspace\AntSql\build\output SET PROJECT_HOME=E:\myworkspace\AntSql :: 当前目录下的build.xml ant @echo on build.xml 文件 <?xml versio ...
Global site tag (gtag.js) - Google Analytics