该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Properties;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
public class DatabaseConnectPool {
private static final String INITIAL_CONTEXT_FACTORY = "weblogic.jndi.WLInitialContextFactory";
public static void main(String[] args) {
DataSource ds = null;
Context ctx = null;
Connection myConn = null;
try {
ctx = getInitialContext();
ds = (javax.sql.DataSource)ctx.lookup("ChannelDS");//The datasource you configure in weblogic.
} catch (Exception E) {
System.out.println("Init Error:" + E);
}
Statement myStatement = null;
ResultSet myResultSet = null;
try {
myConn = ds.getConnection();
myStatement = myConn.createStatement();
myResultSet = myStatement.executeQuery("SELECT sysdate today from dual");
while (myResultSet.next()) {
System.out.println("Today is:" + myResultSet.getString("today"));
}
myResultSet.close();
} catch (Exception e) {
System.out.println(e);
} finally {
try {
if (myStatement != null) {
myStatement.close();
}
if (myConn != null) {
myConn.close();
}
} catch (Exception e) {
System.out.println(e);
}
}
}
private static Context getInitialContext() throws Exception {
String url = "t3://localhost:7001";
String user = "";//Username in weblogic,allowed null.
String password = "";//Password in weblogic,allowed null.
Properties properties = null;
try {
properties = new Properties();
properties.put(Context.INITIAL_CONTEXT_FACTORY,INITIAL_CONTEXT_FACTORY);
properties.put(Context.PROVIDER_URL,url);
properties.put(Context.SECURITY_PRINCIPAL, user == null ? "" : user);
properties.put(Context.SECURITY_CREDENTIALS,password == null ? "" : password);
return new InitialContext(properties);
} catch (Exception e) {
throw e;
}
}
}