添加DBUtil 类:
package com.xl.sql;
import java.sql.Connection;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
public class DBUtil {
public Connection getConnection() throws Exception {
Context context = new InitialContext();
// 获取数据源
DataSource ds = (DataSource) context.lookup("java:comp/env/jdbc/MySQLDS");
// 获取数据库连接
Connection conn = ds.getConnection();
if (conn != null && !conn.isClosed()) {
return conn;
} else {
return null;
}
}
}