dbtool.java

电子商城

package com.lmh.dao.db;

import java.sql.Connection;
import java.sql.SQLException;

import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;

/**
 * @author Kenneth
 * 
 */
public class DBTool {
	public static Connection getConn() {
		Connection conn = null;
		try {
			conn = getDS().getConnection();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return conn;
	}

	public static DataSource getDS() {
		DataSource ds = null;
		try {
			InitialContext ic = new InitialContext();
			ds = (DataSource) ic.lookup("java:comp/env/lmhshopjndi");
		} catch (NamingException e) {
			e.printStackTrace();
		}

		return ds;
	}
}