dbconnect.java

db连接测试用

package com.hollyinfo;

import com.hollyinfo.eus.persistence.framework.transaction.PersistenceHelper;
import com.hollyinfo.eus.persistence.framework.transaction.PersistenceManager;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

/**
 * 
DOCUMENT ME!
 *
 * @author luyang
 */
public class DBConnect {
    //private static Connection conn = null;
    public DBConnect() {
    }

    public static PersistenceManager getConn() {
        PersistenceManager manager = null;
        try {
            manager = PersistenceHelper.getPersistenceManager();
        } catch (Exception ex) {
            System.err.println("**************************");
            System.err.println("DBConnect.getConn(): ");
            ex.printStackTrace();
            System.err.println("**************************");
        }

        return manager;
    }

    public static ResultSet getRs(final PersistenceManager manager,
        final String whereStr) {
        Statement stmt = null;
        ResultSet rs = null;
        try {
            Connection conn = manager.getConnection();
            stmt = conn.createStatement();
            rs = stmt.executeQuery("SELECT * FROM esm_meta_code " + whereStr);
        } catch (Exception ex) {
            System.err.println("**************************");
            System.err.println("DBConnect.getRs(): ");
            ex.printStackTrace();
            System.err.println("**************************");
        }

        return rs;
    }

    public static void closeConnection(final PersistenceManager manager) {
        //		try {
        //			if (_conn != null) {
        //				_conn.close();
        //			}
        //		} catch (Exception e) {
        //			System.err.println("**************************");
        //			System.err.println("DBConnect.DBClose(): ");
        //			e.printStackTrace();
        //			System.err.println("**************************");
        //		}
        manager.close();
    }

    public static void main(final String[] agrs) {
        //		PersistenceManager manager = PersistenceHelper.getPersistenceManager();
        //		try {
        //			conn = manager.getConnection();
        //			if (conn == null) {
        //				System.out.println("------------>");
        //			}
        //		} catch (PersistenceException e) {
        //			e.printStackTrace();
        //		}
    }
}