dbmanager.java

WAP PUSH后台源码,WAP PUSH后台源码

package com.sxit.wap.dacs;

/**
 * <p>Title: wap II</p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: sxit</p>
 * @author lihongchao
 * @version 1.0
 */

import java.sql.*;
import javax.naming.InitialContext;

public class DBManager {
	private static javax.sql.DataSource datasource = null;
	public static Connection getConnection () {
		Connection conn = null;
		try {
			//Class.forName ( "oracle.jdbc.driver.OracleDriver" );
			//conn = DriverManager.getConnection ( "jdbc:oracle:thin:@192.168.8.3:1521:ora8", "sxitwap", "sxitwap" );

			//if ( datasource == null )
				datasource = ( javax.sql.DataSource )new InitialContext ().lookup ( "DataSource" );
			conn = datasource.getConnection ();
		} catch ( Exception ex ) {
			System.out.println ( ex.getMessage () );
		}
		return conn;
	}

	public static void freeConnection ( Connection conn, Statement statement ) {
		try {
			statement.close ();
		} catch ( Exception e1 ) {
			e1.printStackTrace ();
		} finally {
			try {
				conn.close ();
			} catch ( Exception e2 ) {
				e2.printStackTrace ();
			}
		}
	}

	public static void main ( String[] argv ) {
		Connection conn = DBManager.getConnection ();
		try {
			Statement statement = conn.createStatement ();
			ResultSet res = statement.executeQuery ( "select * from tab" );
			while ( res.next () ) {
				System.out.println ( res.getString ( 1 ) );
			}
		} catch ( Exception e1 ) {
			e1.printStackTrace ();
		} finally {
			try {
				conn.close ();
				conn = null;
			} catch ( Exception e2 ) {

			}
		}
	}

}