import java.sql.Connection;
import java.sql.SQLException;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;
import org.apache.log4j.Logger;
public class DataBase
{
static Logger log = Logger.getLogger("blogjavabean");
private static final DataBase db = new DataBase();
private DataSource ds;
private DataBase()
{
try
{
Context ctx = new InitialContext();
ds = (DataSource) ctx.lookup("java:comp/env/jdbc/myblog");
}
catch(NamingException ne)
{
log.error("DataBase() current position >> ");
ne.printStackTrace();
}
}
/**
* 得到数据库连接。
* @throws SQLException
*/
public Connection getConnection()
{
try
{
return ds.getConnection();
}
catch(SQLException se)
{
log.error("DataBase() current position >> ds.getConnection() excute error!");
se.printStackTrace();
}
return null;
}
import java.sql.SQLException;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;
import org.apache.log4j.Logger;
public class DataBase
{
static Logger log = Logger.getLogger("blogjavabean");
private static final DataBase db = new DataBase();
private DataSource ds;
private DataBase()
{
try
{
Context ctx = new InitialContext();
ds = (DataSource) ctx.lookup("java:comp/env/jdbc/myblog");
}
catch(NamingException ne)
{
log.error("DataBase() current position >> ");
ne.printStackTrace();
}
}
/**
* 得到数据库连接。
* @throws SQLException
*/
public Connection getConnection()
{
try
{
return ds.getConnection();
}
catch(SQLException se)
{
log.error("DataBase() current position >> ds.getConnection() excute error!");
se.printStackTrace();
}
return null;
}