package com.newer.food.util;
import java.sql.Connection;
import java.sql.SQLException;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;
public class DBUtil {
static DataSource ds = null;
//初始化数据源对象
static {
try {
// 实始化jndi上下文
Context context = new InitialContext();
// 查找DataSource
ds = (DataSource) context.lookup("java:comp/env/jdbc/food");
} catch (NamingException e) {
e.printStackTrace();
}
}
/**
* 通过数据源获取连接
*
* @return
*/
public static Connection getConnection() {
Connection conn = null;
try {
conn = ds.getConnection();
} catch (SQLException e) {
System.out.println("-----------------------------------------------------");
System.out.println("当你看到我时,请确认数据库的驱动.jar是否拷贝到tomcat目录下");
System.out.println("Tomcat5.5拷贝到commmon/lib目录下");
System.out.println("Tomcat6.0拷贝到lib目录下");
System.out.println("拷贝后记得重启Tomcat");
System.out.println("-----------------------------------------------------");
}
return conn;
}
}