For Java class name (e.g.: com.microsoft.sqlserver.jdbc.SQLServerDriver) click on the Lookup Java Class button and confirm that the Java class is being found in the lib directory where you have put the jar file. 

If the class is not found there please confirm that you restarted the app server after adding the jar file to the lib directory.

If the class is found in the lib directory like it should be please go back to the Database rule and try the test connection again and this time it should work.

zolly 2014-06-03 02:15 发表评论

zolly 2014-04-01 08:40 发表评论

exp name/password@orcl file=E:/exp.dump log=E:/exp.log table=(tb_emp) query="""where UserName='FN'"""

expdp name/password@orcl parfile=E:/expdp.par

DIRECTORY=dir_dump
DUMPFILE=backup.dump
LOGFILE=backup.log
TABLES=pr_data_admin
QUERY=pr_data_admin:"where UserName='FN'"

package com.zolly.blob;

import java.sql.Connection;
import java.sql.DriverManager;

public class DBConnection {

    public static Connection getDBConnectionFrom() throws Exception {
        Connection con = null;
        String driver = "oracle.jdbc.driver.OracleDriver";// database driver
        String url = "jdbc:oracle:thin:@192.168.1.2:1545:ORCL";// database URL
        String user = "user1"; // database name
        String password = "password1"; // database Password
        Class.forName(driver);
        con = DriverManager.getConnection(url, user, password);
        return con;
    }
    
    public static Connection getDBConnectionTo() throws Exception {
        Connection con = null;
        String driver = "oracle.jdbc.driver.OracleDriver";// database driver
        String url = "jdbc:oracle:thin:@192.168.1.3:1521:ORCL";// database URL
        String user = "user2"; // database name
        String password = "password2"; // database Password
        Class.forName(driver);
        con = DriverManager.getConnection(url, user, password);
        return con;
    }

}

package com.zolly.blob;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.OutputStream;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

import oracle.sql.BLOB;

public class BLOBUtil {
    @SuppressWarnings("deprecation")
    public static void writeBLOB() {
        Connection con = null;
        long start = System.currentTimeMillis(); // count runtime
        InputStream fin = null;
        OutputStream outStream = null;
        String path = "E:\\requestor.txt";
        File file = new File(path);
        try {
            con = DBConnection.getDBConnectionTo();
            con.setAutoCommit(false);

            Statement stmt = con.createStatement();
            ResultSet rs = stmt
                    .executeQuery("select pzPVStream from pr_data_admin where pxInsName='PEGA!BROWSER' for update");
            // get specially columns and rows for update
            while (rs.next()) {
                // System.out.print(rs.getInt(1)+rs.getString(2)+"\n");//print
                // select sql for debug
                BLOB blob = (BLOB) rs.getBlob("pzPVStream");
                outStream = blob.getBinaryOutputStream();
                fin = new FileInputStream(file); // put file into stream
                byte[] b = new byte[blob.getBufferSize()];
                int len = 0;
                while ((len = fin.read(b)) != -1) {
                    outStream.write(b, 0, len);
                }

                fin.close();
                outStream.flush();
                outStream.close();
            }
            System.out.print("\nupdate ok\n");

            con.commit();

            con.close();
        }

        catch (Exception e) {
            e.printStackTrace();
        }

        long end = System.currentTimeMillis();
        System.out.println(end - start);
    }

    public static void readBLOB() {
        Connection con = null;
        long start = System.currentTimeMillis(); // count runtime
        String path = "E:\\requestor.txt";
        File file = new File(path);
        try {
            con = DBConnection.getDBConnectionFrom();
            con.setAutoCommit(false);
            Statement stmt = con.createStatement();
            ResultSet rs = stmt
                    .executeQuery("select pzPVStream from pr_data_admin where pxInsName='PEGA!BROWSER'");
            // get blob form your table
            if (rs.next()) {
                BLOB blob = (BLOB) rs.getBlob("pzPVStream");
                // get word column
                FileOutputStream output = new FileOutputStream(file);
                // define a file output stream
                InputStream input = blob.getBinaryStream();// put blob into
                                                            // input
                byte[] buffer = new byte[blob.getBufferSize()];
                // if use 1024 it will lose some bytes
                int len = 0;
                while ((len = input.read(buffer)) != -1) {
                    // get all input stream into output file stream
                    output.write(buffer, 0, len);
                    input.close();
                    output.flush();
                    output.close();
                }
                System.out.print("\ndownload ok\n");
            }
            con.close();
        } catch (Exception e) {
            e.printStackTrace();
        }

        long end = System.currentTimeMillis();
        System.out.println(end - start);

    }

    public static void main(String[] args) {
        BLOBUtil.readBLOB();
        BLOBUtil.writeBLOB();
    }

}

zolly 2013-05-28 13:33 发表评论

DESedeCoder.java

package com.zolly.bouncycastle;

import java.io.BufferedOutputStream;
import java.io.FileOutputStream;
import java.security.Key;
import javax.crypto.Cipher;
import javax.crypto.KeyGenerator;
import javax.crypto.SecretKey;
import javax.crypto.SecretKeyFactory;
import javax.crypto.spec.DESedeKeySpec;

import com.sun.org.apache.xml.internal.security.utils.Base64;

/**
 * DESede对称加密算法演示
 * 
 * @author zolly
 * */
public class DESedeCoder {
    /**
     * 密钥算法
     * */
    public static final String KEY_ALGORITHM = "DESede";

    /**
     * 加密/解密算法/工作模式/填充方式
     * */
    public static final String CIPHER_ALGORITHM = "DESede/ECB/PKCS5Padding";

    /**
     * 
     * 生成密钥
     * 
     * @return byte[] 二进制密钥
     * */
    public static byte[] initkey() throws Exception {

        // 实例化密钥生成器
        KeyGenerator kg = KeyGenerator.getInstance(KEY_ALGORITHM);
        // 初始化密钥生成器
        kg.init(168);
        // 生成密钥
        SecretKey secretKey = kg.generateKey();
        // 获取二进制密钥编码形式
        
        byte[] key = secretKey.getEncoded();
        BufferedOutputStream keystream = 
                new BufferedOutputStream(new FileOutputStream("DESedeKey.dat"));
        keystream.write(key, 0, key.length);
        keystream.flush();
        keystream.close();
        
        return key;
    }

    /**
     * 转换密钥
     * 
     * @param key
     *            二进制密钥
     * @return Key 密钥
     * */
    public static Key toKey(byte[] key) throws Exception {
        // 实例化Des密钥
        DESedeKeySpec dks = new DESedeKeySpec(key);
        // 实例化密钥工厂
        SecretKeyFactory keyFactory = SecretKeyFactory
                .getInstance(KEY_ALGORITHM);
        // 生成密钥
        SecretKey secretKey = keyFactory.generateSecret(dks);
        return secretKey;
    }

    /**
     * 加密数据
     * 
     * @param data
     *            待加密数据
     * @param key
     *            密钥
     * @return byte[] 加密后的数据
     * */
    public static byte[] encrypt(byte[] data, byte[] key) throws Exception {
        // 还原密钥
        Key k = toKey(key);
        // 实例化
        Cipher cipher = Cipher.getInstance(CIPHER_ALGORITHM);
        // 初始化，设置为加密模式
        cipher.init(Cipher.ENCRYPT_MODE, k);
        // 执行操作
        return cipher.doFinal(data);
    }

    /**
     * 解密数据
     * 
     * @param data
     *            待解密数据
     * @param key
     *            密钥
     * @return byte[] 解密后的数据
     * */
    public static byte[] decrypt(byte[] data, byte[] key) throws Exception {
        // 欢迎密钥
        Key k = toKey(key);
        // 实例化
        Cipher cipher = Cipher.getInstance(CIPHER_ALGORITHM);
        // 初始化，设置为解密模式
        cipher.init(Cipher.DECRYPT_MODE, k);
        // 执行操作
        return cipher.doFinal(data);
    }

    /**
     * 进行加解密的测试
     * 
     * @throws Exception
     */
    public static void main(String[] args) throws Exception {
        String str = "DESede";
        System.out.println("原文：" + str);
        // 初始化密钥
        byte[] key = DESedeCoder.initkey();
        System.out.println("密钥：" + Base64.encode(key));
        // 加密数据
        byte[] data = DESedeCoder.encrypt(str.getBytes(), key);
        System.out.println("加密后：" + Base64.encode(data));
        // 解密数据
        data = DESedeCoder.decrypt(data, key);
        System.out.println("解密后：" + new String(data));
    }
}

DESedeTest.java

package com.zolly.bouncycastle;

import java.security.InvalidKeyException;
import java.security.NoSuchAlgorithmException;
import java.security.spec.InvalidKeySpecException;

import javax.crypto.BadPaddingException;
import javax.crypto.Cipher;
import javax.crypto.IllegalBlockSizeException;
import javax.crypto.NoSuchPaddingException;
import javax.crypto.SecretKey;
import javax.crypto.SecretKeyFactory;
import javax.crypto.spec.DESedeKeySpec;

import com.sun.org.apache.xml.internal.security.exceptions.Base64DecodingException;
import com.sun.org.apache.xml.internal.security.utils.Base64;

public class DESedeTest {

    /**
     * @param args
     */
    public static void main(String[] args) {

        String strText = "This is a testing";

        String text1 = DESedeTest.encryptProperty(strText);

        String text2 = DESedeTest.decryptProperty(text1);

        System.out.println(text1);

        System.out.println(text2);
    }

    public static String encryptProperty(String clearText) {

        String KEY_STRING = "RRYa6li5NGFodgKUtvS1I6fZwY8xpJjI";

        byte[] key = null;

        try {
            key = Base64.decode(KEY_STRING);
        } catch (Base64DecodingException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

        return DESedeTest.performDESedeCoder(clearText, key, true);
    }

    public static String decryptProperty(String cipherText) {

        String KEY_STRING = "RRYa6li5NGFodgKUtvS1I6fZwY8xpJjI";

        byte[] key = null;

        try {
            key = Base64.decode(KEY_STRING);
        } catch (Base64DecodingException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

        return DESedeTest.performDESedeCoder(cipherText, key, false);
    }

    public static String performDESedeCoder(String inputValue, byte[] key,
            boolean encrypt) {
        String rtnValue = "";

        String KEY_ALGORITHM = "DESede";
        String CIPHER_ALGORITHM = "DESede/ECB/PKCS5Padding";

        byte[] data = null;
        try {
            DESedeKeySpec dks = new DESedeKeySpec(key);

            SecretKeyFactory keyFactory = SecretKeyFactory
                    .getInstance(KEY_ALGORITHM);

            SecretKey secretKey = keyFactory.generateSecret(dks);

            Cipher cipher = Cipher.getInstance(CIPHER_ALGORITHM);

            byte[] input = null;
            if (encrypt) {
                cipher.init(Cipher.ENCRYPT_MODE, secretKey);
                input = inputValue.getBytes();
            } else {
                cipher.init(Cipher.DECRYPT_MODE, secretKey);
                input = Base64.decode(inputValue);
            }

            data = cipher.doFinal(input);
        } catch (InvalidKeyException e) {
            System.out.println(e.getMessage());
        } catch (NoSuchAlgorithmException e) {
            System.out.println(e.getMessage());
        } catch (InvalidKeySpecException e) {
            System.out.println(e.getMessage());
        } catch (NoSuchPaddingException e) {
            System.out.println(e.getMessage());
        } catch (IllegalBlockSizeException e) {
            System.out.println(e.getMessage());
        } catch (BadPaddingException e) {
            System.out.println(e.getMessage());
        } catch (Base64DecodingException e) {
            System.out.println(e.getMessage());
        }

        if (data == null) {
            rtnValue = inputValue;
        } else {
            if (encrypt) {
                rtnValue = com.sun.org.apache.xml.internal.security.utils.Base64
                        .encode(data);
            } else {
                rtnValue = new String(data);
            }
        }

        return rtnValue;
    }
}

zolly 2013-05-25 01:50 发表评论

bcprov-jdk15on-148.jar和bcpg-jdk15on-148.jar
Bouncy Castle支持大量的密码术算法，其中包括OpenPGP，引用很广泛，Pega就是使用Bouncy Castle对邮件和客户重要数据进行加密解密的。
它既可以安装成JDK扩展也可以放到特定java项目中使用。

3. 在Oracle官网下载UnlimitedJCEPolicy

4. 编写代码

PGPExampleUtil.java

package com.zolly.bouncycastle;

import java.io.BufferedInputStream;
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.security.NoSuchProviderException;
import java.util.Iterator;

import org.bouncycastle.openpgp.PGPCompressedDataGenerator;
import org.bouncycastle.openpgp.PGPException;
import org.bouncycastle.openpgp.PGPLiteralData;
import org.bouncycastle.openpgp.PGPPrivateKey;
import org.bouncycastle.openpgp.PGPPublicKey;
import org.bouncycastle.openpgp.PGPPublicKeyRing;
import org.bouncycastle.openpgp.PGPPublicKeyRingCollection;
import org.bouncycastle.openpgp.PGPSecretKey;
import org.bouncycastle.openpgp.PGPSecretKeyRing;
import org.bouncycastle.openpgp.PGPSecretKeyRingCollection;
import org.bouncycastle.openpgp.PGPUtil;

class PGPExampleUtil
{
    static byte[] compressFile(String fileName, int algorithm) throws IOException
    {
        ByteArrayOutputStream bOut = new ByteArrayOutputStream();
        PGPCompressedDataGenerator comData = new PGPCompressedDataGenerator(algorithm);
        PGPUtil.writeFileToLiteralData(comData.open(bOut), PGPLiteralData.BINARY,
            new File(fileName));
        comData.close();
        return bOut.toByteArray();
    }

    /**
     * Search a secret key ring collection for a secret key corresponding to keyID if it
     * exists.
     * 
     * @param pgpSec a secret key ring collection.
     * @param keyID keyID we want.
     * @param pass passphrase to decrypt secret key with.
     * @return
     * @throws PGPException
     * @throws NoSuchProviderException
     */
    static PGPPrivateKey findSecretKey(PGPSecretKeyRingCollection pgpSec, long keyID, char[] pass)
        throws PGPException, NoSuchProviderException
    {
        PGPSecretKey pgpSecKey = pgpSec.getSecretKey(keyID);

        if (pgpSecKey == null)
        {
            return null;
        }

        return pgpSecKey.extractPrivateKey(pass, "BC");
    }

    static PGPPublicKey readPublicKey(String fileName) throws IOException, PGPException
    {
        InputStream keyIn = new BufferedInputStream(new FileInputStream(fileName));
        PGPPublicKey pubKey = readPublicKey(keyIn);
        keyIn.close();
        return pubKey;
    }

    /**
     * A simple routine that opens a key ring file and loads the first available key
     * suitable for encryption.
     * 
     * @param input
     * @return
     * @throws IOException
     * @throws PGPException
     */
    static PGPPublicKey readPublicKey(InputStream input) throws IOException, PGPException
    {
        PGPPublicKeyRingCollection pgpPub = new PGPPublicKeyRingCollection(
            PGPUtil.getDecoderStream(input));

        //
        // we just loop through the collection till we find a key suitable for encryption, in the real
        // world you would probably want to be a bit smarter about this.
        //

        Iterator keyRingIter = pgpPub.getKeyRings();
        while (keyRingIter.hasNext())
        {
            PGPPublicKeyRing keyRing = (PGPPublicKeyRing)keyRingIter.next();

            Iterator keyIter = keyRing.getPublicKeys();
            while (keyIter.hasNext())
            {
                PGPPublicKey key = (PGPPublicKey)keyIter.next();

                if (key.isEncryptionKey())
                {
                    return key;
                }
            }
        }

        throw new IllegalArgumentException("Can't find encryption key in key ring.");
    }

    static PGPSecretKey readSecretKey(String fileName) throws IOException, PGPException
    {
        InputStream keyIn = new BufferedInputStream(new FileInputStream(fileName));
        PGPSecretKey secKey = readSecretKey(keyIn);
        keyIn.close();
        return secKey;
    }

    /**
     * A simple routine that opens a key ring file and loads the first available key
     * suitable for signature generation.
     * 
     * @param input stream to read the secret key ring collection from.
     * @return a secret key.
     * @throws IOException on a problem with using the input stream.
     * @throws PGPException if there is an issue parsing the input stream.
     */
    static PGPSecretKey readSecretKey(InputStream input) throws IOException, PGPException
    {
        PGPSecretKeyRingCollection pgpSec = new PGPSecretKeyRingCollection(
            PGPUtil.getDecoderStream(input));

        //
        // we just loop through the collection till we find a key suitable for encryption, in the real
        // world you would probably want to be a bit smarter about this.
        //

        Iterator keyRingIter = pgpSec.getKeyRings();
        while (keyRingIter.hasNext())
        {
            PGPSecretKeyRing keyRing = (PGPSecretKeyRing)keyRingIter.next();

            Iterator keyIter = keyRing.getSecretKeys();
            while (keyIter.hasNext())
            {
                PGPSecretKey key = (PGPSecretKey)keyIter.next();

                if (key.isSigningKey())
                {
                    return key;
                }
            }
        }

        throw new IllegalArgumentException("Can't find signing key in key ring.");
    }
}

KeyBasedLargeFileProcessor.java

package com.zolly.bouncycastle;

import java.io.BufferedInputStream;
import java.io.BufferedOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.security.NoSuchProviderException;
import java.security.SecureRandom;
import java.security.Security;
import java.util.Iterator;

import org.bouncycastle.bcpg.ArmoredOutputStream;
import org.bouncycastle.jce.provider.BouncyCastleProvider;
import org.bouncycastle.openpgp.PGPCompressedData;
import org.bouncycastle.openpgp.PGPCompressedDataGenerator;
import org.bouncycastle.openpgp.PGPEncryptedData;
import org.bouncycastle.openpgp.PGPEncryptedDataGenerator;
import org.bouncycastle.openpgp.PGPEncryptedDataList;
import org.bouncycastle.openpgp.PGPException;
import org.bouncycastle.openpgp.PGPLiteralData;
import org.bouncycastle.openpgp.PGPObjectFactory;
import org.bouncycastle.openpgp.PGPOnePassSignatureList;
import org.bouncycastle.openpgp.PGPPrivateKey;
import org.bouncycastle.openpgp.PGPPublicKey;
import org.bouncycastle.openpgp.PGPPublicKeyEncryptedData;
import org.bouncycastle.openpgp.PGPSecretKeyRingCollection;
import org.bouncycastle.openpgp.PGPUtil;
import org.bouncycastle.openpgp.operator.jcajce.JcePGPDataEncryptorBuilder;
import org.bouncycastle.openpgp.operator.jcajce.JcePublicKeyDataDecryptorFactoryBuilder;
import org.bouncycastle.openpgp.operator.jcajce.JcePublicKeyKeyEncryptionMethodGenerator;
import org.bouncycastle.util.io.Streams;

/**
 * A simple utility class that encrypts/decrypts public key based
 * encryption large files.
 */
public class KeyBasedLargeFileProcessor
{
    public static void decryptFile(
        String inputFileName,
        String keyFileName,
        char[] passwd,
        String defaultFileName)
        throws IOException, NoSuchProviderException
    {
        InputStream in = new BufferedInputStream(new FileInputStream(inputFileName));
        InputStream keyIn = new BufferedInputStream(new FileInputStream(keyFileName));
        decryptFile(in, keyIn, passwd, defaultFileName);
        keyIn.close();
        in.close();
    }
    
    /**
     * decrypt the passed in message stream
     */
    public static void decryptFile(
        InputStream in,
        InputStream keyIn,
        char[]      passwd,
        String      defaultFileName)
        throws IOException, NoSuchProviderException
    {    
        in = PGPUtil.getDecoderStream(in);
        
        try
        {
            PGPObjectFactory        pgpF = new PGPObjectFactory(in);
            PGPEncryptedDataList    enc;

            Object                  o = pgpF.nextObject();
            //
            // the first object might be a PGP marker packet.
            //
            if (o instanceof PGPEncryptedDataList)
            {
                enc = (PGPEncryptedDataList)o;
            }
            else
            {
                enc = (PGPEncryptedDataList)pgpF.nextObject();
            }
            
            //
            // find the secret key
            //
            Iterator                    it = enc.getEncryptedDataObjects();
            PGPPrivateKey               sKey = null;
            PGPPublicKeyEncryptedData   pbe = null;
            PGPSecretKeyRingCollection  pgpSec = new PGPSecretKeyRingCollection(
                PGPUtil.getDecoderStream(keyIn));                                                                 
            
            while (sKey == null && it.hasNext())
            {
                pbe = (PGPPublicKeyEncryptedData)it.next();
                
                sKey = PGPExampleUtil.findSecretKey(pgpSec, pbe.getKeyID(), passwd);
            }
            
            if (sKey == null)
            {
                throw new IllegalArgumentException("secret key for message not found.");
            }
            
            InputStream         clear = pbe.getDataStream(new JcePublicKeyDataDecryptorFactoryBuilder().setProvider("BC").build(sKey));
            
            PGPObjectFactory    plainFact = new PGPObjectFactory(clear);
            
            PGPCompressedData   cData = (PGPCompressedData)plainFact.nextObject();
    
            InputStream         compressedStream = new BufferedInputStream(cData.getDataStream());
            PGPObjectFactory    pgpFact = new PGPObjectFactory(compressedStream);
            
            Object              message = pgpFact.nextObject();
            
            if (message instanceof PGPLiteralData)
            {
                PGPLiteralData ld = (PGPLiteralData)message;

                String outFileName = ld.getFileName();
                if (outFileName.length() == 0)
                {
                    outFileName = defaultFileName;
                }

                InputStream unc = ld.getInputStream();
                OutputStream fOut =  new BufferedOutputStream(new FileOutputStream(outFileName));

                Streams.pipeAll(unc, fOut);

                fOut.close();
            }
            else if (message instanceof PGPOnePassSignatureList)
            {
                throw new PGPException("encrypted message contains a signed message - not literal data.");
            }
            else
            {
                throw new PGPException("message is not a simple encrypted file - type unknown.");
            }

            if (pbe.isIntegrityProtected())
            {
                if (!pbe.verify())
                {
                    System.err.println("message failed integrity check");
                }
                else
                {
                    System.err.println("message integrity check passed");
                }
            }
            else
            {
                System.err.println("no message integrity check");
            }
        }
        catch (PGPException e)
        {
            System.err.println(e);
            if (e.getUnderlyingException() != null)
            {
                e.getUnderlyingException().printStackTrace();
            }
        }
    }

    public static void encryptFile(
        String          outputFileName,
        String          inputFileName,
        String          encKeyFileName,
        boolean         armor,
        boolean         withIntegrityCheck)
        throws IOException, NoSuchProviderException, PGPException
    {
        OutputStream out = new BufferedOutputStream(new FileOutputStream(outputFileName));
        PGPPublicKey encKey = PGPExampleUtil.readPublicKey(encKeyFileName);
        encryptFile(out, inputFileName, encKey, armor, withIntegrityCheck);
        out.close();
    }

    public static void encryptFile(
        OutputStream    out,
        String          fileName,
        PGPPublicKey    encKey,
        boolean         armor,
        boolean         withIntegrityCheck)
        throws IOException, NoSuchProviderException
    {    
        if (armor)
        {
            out = new ArmoredOutputStream(out);
        }
        
        try
        {    
            PGPEncryptedDataGenerator   cPk = new PGPEncryptedDataGenerator(new JcePGPDataEncryptorBuilder(PGPEncryptedData.CAST5).setWithIntegrityPacket(withIntegrityCheck).setSecureRandom(new SecureRandom()).setProvider("BC"));
                
            cPk.addMethod(new JcePublicKeyKeyEncryptionMethodGenerator(encKey).setProvider("BC"));
            
            OutputStream                cOut = cPk.open(out, new byte[1 << 16]);
            
            PGPCompressedDataGenerator  comData = new PGPCompressedDataGenerator(
                                                                    PGPCompressedData.ZIP);
                                                                    
            PGPUtil.writeFileToLiteralData(comData.open(cOut), PGPLiteralData.BINARY, new File(fileName), new byte[1 << 16]);
            
            comData.close();
            
            cOut.close();

            if (armor)
            {
                out.close();
            }
        }
        catch (PGPException e)
        {
            System.err.println(e);
            if (e.getUnderlyingException() != null)
            {
                e.getUnderlyingException().printStackTrace();
            }
        }
    }

    public static void main(
        String[] args)
        throws Exception
    {
        Security.addProvider(new BouncyCastleProvider());
        
        decryptFile("Encypted File.txt.pgp", "Key.asc", "123456789".toCharArray(), "Encypted File.txt");
    }
}

zolly 2013-05-24 08:37 发表评论

delete MemberInfo where ID not in (
select max(ID) from MemberInfo group by MemberName, MemberAddress)

SELECT COUNT(MemberName) AS TheCount, MemberName, MemberAddress
FROM MemberInfo
GROUP BY MemberName, MemberAddress
HAVING (COUNT(*) > 1)

zolly 2013-05-03 00:30 发表评论

在社会安全局网站上(https://secure.ssa.gov/apps6z/FOLO/fo001.jsp)根据所在地区的邮政编码查询到服务该地区的Social Security Office。office的一般工作时间是周一到周五，早上9点到下午5点，国定假日不开放。

在Metro网站上查询路线(http://socaltransport.org/tm2_text.php)。坐Metro公交车到那里后已经9：30了，大概100平米的大厅中坐满了人，5、60人的样子，总共才8个窗口，心想要等一上午了。首先在门口的排号机上取了一个号码Q79，然后走到大厅后面的桌子上取了一份申请表开始填，这时听到广播报Q73到8号窗口，我一下子兴奋起来，这么快阿，2分钟填好表格后已经Q76了。后来发现大厅里做的大部分人都是申请退休阿，修改地址等的，可能对新申请的有专门的窗口。

轮到我了，我在1号窗口，一个阿三摸样的小姑娘问我需要什么服务，我说申请新卡，然后她要求我出示了护照，Visa，I-94，准备出示I-797的，她说不用了，然后问我是否是第一次来美国，我说是，然后她录入、扫描等，2分钟后就递给一张确认单，说1到2周，卡就会寄给我。

从头到尾不到半个小时，一分钱没花，效率还算比较高。

zolly 2012-12-14 07:15 发表评论

try {
    PRFile file =new PRFile("Excel File Name.xls");

    java.io.BufferedInputStream in = new java.io.BufferedInputStream(
            new PRInputStream(file));

    // open HSSFWorkbook
    org.apache.poi.poifs.filesystem.POIFSFileSystem fs = new org.apache.poi.poifs.filesystem.POIFSFileSystem(
            in);
    org.apache.poi.hssf.usermodel.HSSFWorkbook wb = new org.apache.poi.hssf.usermodel.HSSFWorkbook(
            fs);
    org.apache.poi.hssf.usermodel.HSSFCell cell = null;
    for (int sheetIndex = 0; sheetIndex < wb.getNumberOfSheets(); sheetIndex++) {
        org.apache.poi.hssf.usermodel.HSSFSheet st = wb
                .getSheetAt(sheetIndex);
        for (int rowIndex = 0; rowIndex <= st.getLastRowNum(); rowIndex++) {
            org.apache.poi.hssf.usermodel.HSSFRow row = st
                    .getRow(rowIndex);
            if (row == null) {
                continue;
            }

            String strJobName = "";
            cell = row.getCell(0);
            strJobName = cell.getStringCellValue().trim();
            ClipboardProperty propJobName = myStepPage.getProperty(".Jobs(<append>).JobName");
            propJobName.setValue(strJobName);
        }
    }
    in.close();
} catch (java.io.FileNotFoundException e) {
    oLog.error(e.getMessage());
} catch (java.io.IOException e) {
    oLog.error(e.getMessage());
}

try {
    PRFile file =new PRFile("Excel File Name.xlsx");

    java.io.BufferedInputStream in = new java.io.BufferedInputStream(
            new PRInputStream(file));
    // open XSSFWorkbook
    org.apache.poi.openxml4j.opc.OPCPackage docPackage = org.apache.poi.openxml4j.opc.OPCPackage
            .open(in);

    org.apache.poi.xssf.usermodel.XSSFWorkbook wb = new org.apache.poi.xssf.usermodel.XSSFWorkbook(
            docPackage);
    org.apache.poi.xssf.usermodel.XSSFCell cell = null;
    for (int sheetIndex = 0; sheetIndex < wb.getNumberOfSheets(); sheetIndex++) {
        org.apache.poi.xssf.usermodel.XSSFSheet st = wb
                .getSheetAt(sheetIndex);
        for (int rowIndex = 0; rowIndex <= st.getLastRowNum(); rowIndex++) {
            org.apache.poi.xssf.usermodel.XSSFRow row = st
                    .getRow(rowIndex);
            if (row == null) {
                continue;
            }

            String strJobName = "";
            cell = row.getCell(0);
            strJobName = cell.getStringCellValue().trim();
            ClipboardProperty propJobName = myStepPage.getProperty(".Jobs(<append>).JobName");
            propJobName.setValue(strJobName);
        }
    }
    in.close();
} catch (java.io.FileNotFoundException e) {
    oLog.error(e.getMessage());
} catch (java.io.IOException e) {
    oLog.error(e.getMessage());
} catch (org.apache.poi.openxml4j.exceptions.InvalidFormatException e) {
    oLog.error(e.getMessage());
}

zolly 2012-09-12 22:43 发表评论

zolly 2011-10-13 14:52 发表评论

zolly 2010-10-20 12:44 发表评论

zolly 2010-08-17 17:23 发表评论

zolly 2010-06-21 00:23 发表评论

zolly 2009-12-18 16:26 发表评论

zolly 2009-06-01 17:22 发表评论

zolly 2009-05-31 18:00 发表评论

zolly 2009-05-27 09:48 发表评论

zolly 2009-05-20 23:35 发表评论

zolly 2009-05-20 23:00 发表评论

zolly 2009-05-20 12:37 发表评论

zolly 2009-05-20 09:23 发表评论