- 博客(56)
- 收藏
- 关注
原创 MySQL Date and Time Functions
[code="sql"]Name DescriptionADDDATE() Add datesADDTIME() Add timeCONVERT_TZ() Convert from one timezone to anotherCURDATE() Return the current dateCURRENT_DATE(), CURRENT_DATE Synonyms for...
2011-12-31 13:50:59 173
原创 MySQL CONCAT Function
[code="sql"]mysql> SELECT CONCAT('FIRST ', 'SECOND');+----------------------------+| CONCAT('FIRST ', 'SECOND') |+----------------------------+| FIRST SECOND |+--------------...
2011-12-31 13:50:50 548
原创 Jquery The $() factory function
[code="js"]jQuery DescriptionTag Name: Represents a tag name available in the DOM. For example $('p') selects all paragraphs in the document.Tag ID: Represents a tag available with the given ID ...
2011-12-31 13:50:37 291
原创 Jquery Useful Attribute Methods
Useful Attribute Methods:Following table lists down few useful methods which you can use to manipulate attributes and properties:MethodsDescriptionattr( properties )Set a key/value ob...
2011-12-31 13:50:27 102
原创 Jquery Find Elements by index
Find Elements by index:Consider a simple document with the following HTML content:<html><head><title>the title</title></head><body> <div>
2011-12-31 13:50:15 121
原创 Struts+Json实例 Example
[code="java"]1. Get dependency libraryGet the struts2-json-plugin.jar library. pom.xml org.apache.struts struts2-core 2.1.8 ...
2011-12-30 09:59:36 90
原创 Js计算时间差,天数,小时数,余数
[code="js"]var begintime_ms = Date.parse(new Date(begintime.replace(/-/g, "/"))); //begintime 为开始时间var endtime_ms = Date.parse(new Date(endtime.replace(/-/g, "/"))); // endtime 为结束时间得到的结果为...
2011-12-30 09:59:17 358
原创 Js文件中引用另一个js文件的3种方法
[code="js"]1.function js_include(fileName){ document.write('');}2.document.scripts[0].src="newjs.js"3.scriptvar S =' ' + 'alert("hi");'+ '';document.all.test.innerHT...
2011-12-30 09:59:03 860
原创 Js获取日期时间毫秒数
[code="jsp"] [/code][code="js"]$("#btn_value").click(function() { var begintime_ms = Date .parse(new Date(($("#txt_value").val() + " 00:00:00") .replace(/-/g, "/&q
2011-12-30 09:58:50 873
原创 jquery获取select的option个数
[code="js"]1、alert($("#selectType")[0].options.length);2、alert($("#selectType option").length);[/code]
2011-12-29 11:37:33 657
原创 batik.jar 免费下载中
[url]http://www.java2s.com/Code/JarDownload/batik.jar.zip[/url]
2011-12-29 11:37:22 407
原创 Oracle重置数据库命令
新建bat文件,复制以下内容,然后执行。[code="bat"]@echo offREMREM The script assumes that user can connect using "/ as sysdba"REMREM =================REM Restore procedureREM =================REMREM ...
2011-12-29 11:37:12 800
原创 Mysql load csdn password
[code="sql"]mysql> create table csdn(id int not null auto_increment primary key,username varchar(50) not null,password varchar(50) not null,email varchar(50) not null);Query OK, 0 rows affected (0...
2011-12-29 11:36:49 156
原创 CSDN 6428632条数据mysql 32.25s插入完毕
[code="sql"]mysql> create table csdn(id int not null auto_increment primary key,username varchar(50) not null,password varchar(50) not null,email varchar(50) not null);Query OK, 0 rows affected (0.2...
2011-12-29 11:36:34 119
原创 Mysqldump to a file
[code="sql"]Dump all databases for backup. Backup file is sql commands to recreate all db's.# [mysql dir]/bin/mysqldump -u root -ppassword --opt >/tmp/alldatabases.sqlDump one database for b...
2011-12-28 23:19:44 184
原创 Mysql all of the keyword
[code="sql"]MYSQL Statements and clausesALTER DATABASEALTER TABLEALTER VIEWANALYZE TABLEBACKUP TABLECACHE INDEXCHANGE MASTER TOCHECK TABLECHECKSUM TABLECOMM...
2011-12-28 23:08:21 124
原创 Mysql advantage command
[code="sql"]To login (from unix shell) use -h only if needed.# [mysql dir]/bin/mysql -h hostname -u root -pCreate a database on the sql server.mysql> create database [databasename];L...
2011-12-28 23:07:38 69
原创 struts tag iterator高级用法
[code="html"]Name Return Type Description index int zero-based index value. count int index + 1 first boolean returns true if it is the first element last boolean returns true ...
2011-12-28 11:34:40 153
原创 struts tag Iterator设置值
设置顺序的循环值:[code="jsp"] ${level} [/code]设置int[]的循环值:[code="jsp"] ${level} [/code]设置list or...
2011-12-28 11:28:21 125
原创 CSDN数据库密码分析
[table]|密码|数量|123456789| 235024|12345678| 212751|11111111| 76347|dearbook| 46054|00000000| 34952|123123123| 19986|1234567890| 17791|88888888| 15033|111111111| 6995|147258369| 596...
2011-12-25 22:08:27 300
原创 jsp跨月布局高亮
[code="jsp"] 0${day1.count} ${day1.count} 0${day1.count-list[0].name} ...
2011-12-25 19:59:40 76
原创 java判断相邻两个月份总天数
[code="java"]if (beigin == 1 || beigin == 2) { if ((year % 4 == 0 && year % 100 != 0) || year % 400 == 0) { renwu.setId(60); } else { renwu.setId(59); } } else if ...
2011-12-25 19:38:07 278
原创 sqlserver大容量导入数据时保留标识值
[code="sql"]可以将包含标识值的数据文件大容量导入到 MicrosoftSQL Server 实例中。默认情况下,将忽略导入的数据文件中标识列的值,SQL Server 自动分配唯一值。这些唯一值基于在表创建期间指定的种子和增量值。如果该数据文件表中的标识符列不包含值,则使用格式化文件来指定导入数据时应跳过表中的标识符列。SQL Server 自动为此列分配唯一值。若...
2011-12-24 14:38:18 348
原创 CSDN 6428632条数据sqlserver 38s插入完毕
[code="sql"]if exists(select * from sysobjects where name = 'csdn1') drop table csdn1create table csdn1( --id int identity(1,1) primary key, username varchar(50) not null, [password] varchar...
2011-12-24 14:32:28 103
原创 Java读取写入文件所以方法含大文件读取
[code="java"]I/O Performance By Glen McCluskey March 1999 This article discusses and illustrates a variety of techniques for improving Java I/O performance. Most of the techniques center around ...
2011-12-24 01:05:23 286
原创 Java读取大文件,超越内存限制
[code="java"]// 经典读取数据三(大文件) public static void readerFile3(String path) { int length = 0x8FFFFFF; // 128 Mb try { MappedByteBuffer out = new RandomAccessFile(path, "r").getChannel() ...
2011-12-24 00:19:45 647
原创 cmd启动Oracle数据库
新建一个bat文件,复制内容进去,双击启动.[code="cmd"]@echo offnet start OracleXETNSListener 2>nulnet start OracleServiceXE 2>nul@oradim -startup -sid XE -starttype inst > nul 2>&1[/code]...
2011-12-22 17:20:58 229
原创 Oracle IMPDP导入dmp数据帮助命令
[code="help"]D:\JAVA\DATABASE\ORACLEXE\APP\ORACLE\product\11.2.0\server\bin>impdp help=yImport: Release 11.2.0.2.0 - Production on 星期四 12月 22 17:10:30 2011Copyright (c) 1982, 2009, Oracle and/...
2011-12-22 17:12:41 747
原创 Oracle IMP导入文件帮助文档
[code="help"]D:\JAVA\DATABASE\ORACLEXE\APP\ORACLE\product\11.2.0\server\bin>imp help=yImport: Release 11.2.0.2.0 - Production on 星期四 12月 22 17:07:59 2011Copyright (c) 1982, 2009, Oracle and/...
2011-12-22 17:09:16 207
原创 js,jquery日期相加减,得到新日期
[code="js"]jQuery(function($) { // 保存按钮单击事件 $("#subForm").click(function() { $("form")// 选择form .first()// 选择第一个 第二个用eq(1) 最后一个 last() .submit();// 提交 }); ...
2011-12-22 17:06:19 1036
原创 JS关闭当前页面的几种方法
1、直接关闭[code="js"]window.close();[/code]2、关闭并提示[code="js"]window.opener = null;window.close();[/code]1、关闭不提示[code="js"]window.opener = null;window.open("", "_self");window.close...
2011-12-22 17:04:54 398
原创 sql developer连接oracle数据库
[img]http://dl.iteye.com/upload/attachment/608522/2b4eaa19-de0d-3601-873c-5fbe72de8185.jpg[/img]
2011-12-20 13:03:14 75
原创 Oracle导入dmp文件命令
进入[code="sql"]D:\Java\Database\oraclexe\app\oracle\product\11.2.0\server\bin[/code]文件夹执行cmd命令[code="java"]D:\Java\Database\oraclexe\app\oracle\product\11.2.0\server\bin>IMPDP hefa/hefa d u...
2011-12-20 12:57:14 281
原创 Oracle修改端口命令sql
[code="sql"]conn sys/password as sysdba[/code][code="sql"]call dbms_xdb.cfg_update(updateXML(dbms_xdb.cfg_get(),'/xdbconfig/sysconfig/protocolconfig/httpconfig/http-port/text()',8088));[/c...
2011-12-20 12:54:12 155
原创 Oracle sql developer配置JDK文件
[code="java"]"D:\Java\Database\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf"[/code][code="java"]SetJavaHome D:\Java\Java\jdk1.6.0_24[/code]
2011-12-20 11:51:14 3904
原创 sqlserver 2012 RC0 安装预览指导
[img]http://dl.iteye.com/upload/attachment/606945/915918e7-d835-3ecc-a24d-602895fa4f75.jpg[/img][img]http://dl.iteye.com/upload/attachment/606947/bcf24f25-a06a-3d87-81ea-4101379df1f9.jpg[/img]...
2011-12-16 16:04:05 128
原创 Java不能发邮件并且报Exception in thread "main" java.lang.NoClassDefFoundError: com/sun/m
[code="java"]public class MailClient { public void sendMail(String mailServer, String from, String to, String subject, String messageBody) throws Messagin...
2011-12-16 11:00:25 494
原创 中国农业银行关闭和禁止右键
[code="js"]function closeww() { if ( confirm("是否确定要退出中国农业银行网上银行系统?") ) { // top.location.href="LogonOut.aspx"; //form1.submit(); top.opener = null; top.closeOnLog...
2011-12-15 22:16:34 254
原创 jstl fn 复合使用
[code="jsp"]发布时间: 结束时间: [/code]主要:[color=red][size=large]${fn:trim(fn:split(feeds.datetime,',')[1])}[/size][/color]
2011-12-15 17:32:06 155
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人