<%@page contentType="text/html" pageEncoding="UTF-8"%><meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
SQL> SELECT * FROM TXN FROM USERDATE != ''db2 => connect to yourdb
Database Connection Information
Database server = DB2/LINUX 9.7.6
SQL authorization ID = yourdb
Local database alias = yourdb
db2 =>
db2 => select * from SYSIBM.SYSVERSIONS
VERSIONNUMBER VERSION_TIMESTAMP AUTHID VERSIONBUILDLEVEL
------------- -------------------------- -------- ------------------------------
9070600 2013-02-21-16.21.51.489830 DB2INST1 s120516
1 record(s) selected.
db2 => select * from SYSIBM.SYSVERSIONS
SQL1024N A database connection does not exist. SQLSTATE=08003
db2 =>
db2 => select current date from sysibm.sysdummy1
1
----------
08/29/2013
1 record(s) selected.
db2 => select current time from sysibm.sysdummy1
1
--------
16:59:01
1 record(s) selected.
db2 => select current timestamp from sysibm.sysdummy1
1
--------------------------
2013-08-29-16.37.35.960388
1 record(s) selected.
db2 => select varchar_format(current timestamp, 'YYYYMMDD') from sysibm.sysdummy1
1
-----------------------------------
20130829
1 record(s) selected.
INSERT INTO XXX (UNIQUEID, TYPE, ID) VALUES(NEXT VALUE FOR UNIQUE_ID_SEQ,'M','004123456789001');
Exception in thread "main" java.lang.NoClassDefFoundError: org.apache.oro.text.perl.Perl5Util
at org.apache.commons.validator.GenericValidator.matchRegexp(GenericValidator.java:65)
at com.fesc.bot.batch.BatchJob.downloadFiles(Unknown Source)
at com.fesc.bot.batch.FD903C.exec(Unknown Source)
at com.fesc.bot.batch.FD903C.main(Unknown Source)
Caused by: java.lang.ClassNotFoundException: org.apache.oro.text.perl.Perl5Util
at java.net.URLClassLoader.findClass(URLClassLoader.java:434)
at java.lang.ClassLoader.loadClassHelper(ClassLoader.java:665)
at java.lang.ClassLoader.loadClass(ClassLoader.java:644)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:358)
at java.lang.ClassLoader.loadClass(ClassLoader.java:627)
... 4 more
解決：import java.lang.StringBuilder;
import java.lang.System;
import java.util.StringTokenizer;
import java.util.List;
import java.util.ArrayList;
import java.util.Arrays;
public class Test {
public static void main(String[] args) {
StringBuilder sb = new StringBuilder();
for (int i=1000; i<1100; i++) {
sb.append(i).append(" ");
}
String str = sb.toString();
int runs = 100000;
for (int i = 0; i < 5; i++) {
{
long start = System.nanoTime();
for (int r = 0; r < runs; r++) {
StringTokenizer st = new StringTokenizer(str);
List list = new ArrayList();
while (st.hasMoreTokens()) {
list.add(st.nextToken());
}
}
long time = System.nanoTime() - start;
System.out.printf("StringTokenizer took an average of %.1f us%n", time / runs / 1000.0);
}
{
long start = System.nanoTime();
for (int r = 0; r < runs; r++) {
List list = Arrays.asList(str.split(" "));
}
long time = System.nanoTime() - start;
System.out.printf("String.split took an average of %.1f us%n", time / runs / 1000.0);
}
}
}
} StringTokenizer took an average of 12.7 us
String.split took an average of 9.8 us
StringTokenizer took an average of 12.6 us
String.split took an average of 9.4 us
StringTokenizer took an average of 12.6 us
String.split took an average of 9.4 us
StringTokenizer took an average of 13.2 us
String.split took an average of 9.4 us
StringTokenizer took an average of 12.5 us
String.split took an average of 9.5 us
String str = "aaa:bbb:ccc:ddd";
String[] tokens = str.split(":");
for (String token:tokens) {
System.out.println(token);
}
aaa
bbb
ccc
ddd
String str = "aaa:bbb-ccc_ddd";
String[] tokens = str.split(":|-|_");
for (String token:tokens) {
System.out.println(token);
}
aaa
bbb
ccc
ddd
String str = "aaa-bbb-ccc.ddd";
String[] tokens = str.split("-|\\.");
for (String token:tokens) {
System.out.println(token);
}
aaa
bbb
ccc
ddd
db2
db2 => connect to your_database
db2 => create table xxx(cardno varchar(33) for bit data)
db2 => set encryption password = 'test1234';
db2 => insert into xxx values(encrypt('1234567890123456'))
db2 => select decrypt_char(cardno) from xxx
db2 => quit
import java.util.Date;
public class StringFormatT {
public static void main(String[] args) {
System.out.println("===== test argument index ======================================================");
System.out.println("original\t10\t20");
System.out.println("format\t\t%1$s\t%1$d\t%2$s\t%2$d");
System.out.println(String.format("result\t\t\"%1$s\"\t%1$d\t\"%2$s\"\t%2$d", 10, 20));
System.out.println("original\t10\t20\t30\t40");
System.out.println("format\t\t%1$s\t%3$d\t%4$s\t%2$d");
System.out.println(String.format("result\t\t\"%1$s\"\t%3$d\t\"%4$s\"\t%2$d", 10, 20, 30, 40));
System.out.println("================================================================================");
System.out.println("===== formatted as string ======================================================");
System.out.println("original\t\"abc\"\tnull\t(byte)1\t3.14");
System.out.println("format\t\t%s\t%S\t%s\t%S");
System.out.println(String.format("result\t\t%s\t%S\t%s\t%S", "abc", null, (byte)1, 3.14));
System.out.println("================================================================================");
System.out.println("===== formatted as boolean =====================================================");
System.out.println("original\t\"abc\"\tnull\t(byte)1\t3.14");
System.out.println("format\t\t%b\t%B\t%b\t%B");
System.out.println(String.format("result\t\t%b\t%B\t%b\t%B", "abc", null, (byte)1, 3.14));
System.out.println("================================================================================");
System.out.println("===== formatted as hex =========================================================");
System.out.println("original\t\"100\"\tnull\t100\tnew Integer(100)\t3.14");
System.out.println("format\t\t%h\t%H\t%h\t%H\t\t\t%h");
System.out.println(String.format("result\t\t%h\t%H\t%h\t%H\t\t\t%h", "100", null, 100, new Integer(100), 3.14));
System.out.println("================================================================================");
System.out.println("===== formatted as character ===================================================");
System.out.println("original\t'A'\t97\t97");
System.out.println("format\t\t%s\t%C\t%c");
System.out.println(String.format("result\t\t%s\t%C\t%c", 'A', 97, 97));
System.out.println("================================================================================");
System.out.println("===== formatted as integer =====================================================");
System.out.println("original\t100\t100\t100");
System.out.println("format\t\t%d\t%o\t%h");
System.out.println(String.format("result\t\t%d\t%o\t%h", 100, 100, 100));
System.out.println("================================================================================");
System.out.println("===== formatted as big number ==================================================");
System.out.println("original\t123456789L");
System.out.println("format\t\t%1$d\t\t%1$,d");
System.out.println(String.format("result\t\t%1$d\t%1$,d", 123456789L));
System.out.println("================================================================================");
System.out.println("===== formatted as float =======================================================");
System.out.println("original\t123456789.98765");
System.out.println("format\t\t%1$.2a\t\t%1$.2e\t\t%1$.2f\t\t%1$.2g");
System.out.println(String.format("result\t\t%1$.2a\t%1$.2e\t%1$.2f\t%1$.2g", 123456789.98765));
System.out.println("================================================================================");
System.out.println("===== formatted as date ========================================================");
long currentTime = System.currentTimeMillis();
Date date = new Date();
System.out.println("original\tCurrent datetime use System.currentTimeMillis()");
System.out.println("format\t\t%1$tY-%1$tm-%1$td %1$tH:%1$tM:%1$tS");
System.out.println(String.format("result\t\t%1$tY-%1$tm-%1$td %1$tH:%1$tM:%1$tS", currentTime));
System.out.println("format\t\t%1$tF %1$tT");
System.out.println(String.format("result\t\t%1$tF %1$tT", currentTime));
System.out.println("original\tCurrent datetime use java.util.Date");
System.out.println("format\t\t%1$tY-%1$tm-%1$td %1$tH:%1$tM:%1$tS");
System.out.println(String.format("result\t\t%1$tY-%1$tm-%1$td %1$tH:%1$tM:%1$tS", date));
System.out.println("================================================================================");
System.out.println("===== What's the effect of width.precision on String? ==========================");
System.out.println("original\tabcdefg");
System.out.println("format\t\t[%1$s]\t\t[%1$10s]\t[%1$10.4s]\t[%1$-10s]");
System.out.println(String.format("result\t\t[%1$s]\t[%1$10s]\t[%1$10.4s]\t[%1$-10s]", "abcdefg"));
System.out.println("================================================================================");
System.out.println("===== padding easy ==========================");
System.out.println("original\tadd leading zero");
System.out.println("format\t\t%012d");
System.out.println(String.format("result\t\t%012d", 123));
System.out.println("================================================================================");
System.out.println("===== test new line ============================================================");
System.out.println("original\t[%n]");
System.out.println("format\t\t%n");
System.out.println(String.format("result\t\t[%n]"));
System.out.println("================================================================================");
}
}===== test argument index ======================================================
original 10 20
format %1$s %1$d %2$s %2$d
result "10" 10 "20" 20
original 10 20 30 40
format %1$s %3$d %4$s %2$d
result "10" 30 "40" 20
================================================================================
===== formatted as string ======================================================
original "abc" null (byte)1 3.14
format %s %S %s %S
result abc NULL 1 3.14
================================================================================
===== formatted as boolean =====================================================
original "abc" null (byte)1 3.14
format %b %B %b %B
result true FALSE true TRUE
================================================================================
===== formatted as hex =========================================================
original "100" null 100 new Integer(100) 3.14
format %h %H %h %H %h
result bdf1 NULL 64 64 11e29ba7
================================================================================
===== formatted as character ===================================================
original 'A' 97 97
format %s %C %c
result A A a
================================================================================
===== formatted as integer =====================================================
original 100 100 100
format %d %o %h
result 100 144 64
================================================================================
===== formatted as big number ==================================================
original 123456789L
format %1$d %1$,d
result 123456789 123,456,789
================================================================================
===== formatted as float =======================================================
original 123456789.98765
format %1$.2a %1$.2e %1$.2f %1$.2g
result 0x1.d7p26 1.23e+08 123456789.99 1.2e+08
================================================================================
===== formatted as date ========================================================
original Current datetime use System.currentTimeMillis()
format %1$tY-%1$tm-%1$td %1$tH:%1$tM:%1$tS
result 2013-05-13 16:08:57
format %1$tF %1$tT
result 2013-05-13 16:08:57
original Current datetime use java.util.Date
format %1$tY-%1$tm-%1$td %1$tH:%1$tM:%1$tS
result 2013-05-13 16:08:57
================================================================================
===== What's the effect of width.precision on String? ==========================
original abcdefg
format [%1$s] [%1$10s] [%1$10.4s] [%1$-10s]
result [abcdefg] [ abcdefg] [ abcd] [abcdefg ]
================================================================================
===== padding easy ==========================
original add leading zero
format %012d
result 000000000123
================================================================================
===== test new line ============================================================
original [%n]
format %n
result [
]
================================================================================
CREATE SEQUENCE XX_SEQ START 1 INCREMENT BY 1 MAXVALUE 999999 CYCLE NO CACHEALTER SEQUENCE XX_SEQ RESTART WITH 10SELECT NEXT VALUE FOR XX_SEQ FROM sysibm.sysdummy1DROP SEQUENCE XX_SEQ RESTRICT
${filecomment}
${package_declaration}
${typecomment}
${type_declaration}
${filecomment}
/*
* @(#)${file_name} ${date}
*
* Copyright (C) 2004 Your Company.
* All right reserved.
*/
${package_declaration}
import org.apache.log4j.Logger;
${typecomment}
/**
* 類別說明請新增
* @author ${user}
* @version 1.0 ${date}
*/
${type_declaration}
/** for log4j */
static Logger log = Logger.getLogger(${type_name}.class.getName());
/** Constructor */
public ${type_name}() {}
