//大家看一下,这是在WebLogic中连数据库的例子,使用WebLogic配置了连接池import javax.rmi.PortableRemoteObject;
import javax.sql.DataSource;//在JBuilder中提示没有这个???????????????????????????
import javax.sql.*;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.naming.NamingException;public class Test { private DataSource ds = null;
public static void main(String[] args) {
System.out.println("-------");
try {
Context context = getInitialContext();
DataSource ds =(DataSource)context.lookup("DataSource");
Connection conn = ds.getConnection();
Statement st = conn.createStatement();
String sql = "SELECT * from guestbook";
ResultSet rs = st.executeQuery(sql);
System.out.println("------- name ------- + email");
while(rs.next()){
String name = rs.getString(1);
String email = rs.getString(2);
System.out.println("-------"+ name +"-------" + email);
}
} catch (Exception e) {
e.printStackTrace();
}
}
private static Context getInitialContext() throws Exception {
String url = "t3://localhost:7001";
String user = null;
String password = null;
Properties properties = null;
try {
properties = new Properties();
properties.put(Context.INITIAL_CONTEXT_FACTORY, "weblogic.jndi.WLInitialContextFactory");
properties.put(Context.PROVIDER_URL, url);
if (user != null) {
properties.put(Context.SECURITY_PRINCIPAL, user);
properties.put(Context.SECURITY_CREDENTIALS, password == null ? "" : password);
} return new InitialContext(properties);
}
catch(Exception e) {
System.out.println("Unable to connect to WebLogic server at " + url);
System.out.println("Please make sure that the server is running.");
throw e;
}
}
}
import javax.sql.DataSource;//在JBuilder中提示没有这个???????????????????????????
import javax.sql.*;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.naming.NamingException;public class Test { private DataSource ds = null;
public static void main(String[] args) {
System.out.println("-------");
try {
Context context = getInitialContext();
DataSource ds =(DataSource)context.lookup("DataSource");
Connection conn = ds.getConnection();
Statement st = conn.createStatement();
String sql = "SELECT * from guestbook";
ResultSet rs = st.executeQuery(sql);
System.out.println("------- name ------- + email");
while(rs.next()){
String name = rs.getString(1);
String email = rs.getString(2);
System.out.println("-------"+ name +"-------" + email);
}
} catch (Exception e) {
e.printStackTrace();
}
}
private static Context getInitialContext() throws Exception {
String url = "t3://localhost:7001";
String user = null;
String password = null;
Properties properties = null;
try {
properties = new Properties();
properties.put(Context.INITIAL_CONTEXT_FACTORY, "weblogic.jndi.WLInitialContextFactory");
properties.put(Context.PROVIDER_URL, url);
if (user != null) {
properties.put(Context.SECURITY_PRINCIPAL, user);
properties.put(Context.SECURITY_CREDENTIALS, password == null ? "" : password);
} return new InitialContext(properties);
}
catch(Exception e) {
System.out.println("Unable to connect to WebLogic server at " + url);
System.out.println("Please make sure that the server is running.");
throw e;
}
}
}
解决方案 »
- Java程序捆绑虚拟机
- 初学者在吐血,请有心人帮忙!
- 帮我看一下谢了
- 基礎的問題:請問 java 的缺省訪問修飾符是 private 還是 public ?
- JAVA如何用JDBC连接SQL2005
- JAVA编程一般用什么工具??
- 多维动态数组如何生成、传递?急急急急急急急!
- 请教关于byte的问题
- Server configuration denies access to data source?
- e:\java\tomcat是我的tomcat目录;e:\java\j2sdk是我的j2sdk1.4.0的目录,
- 这个程序为什么出错???
- 解析文件,为什么出现死循环?filePointer 的值总是小于 length
还有就是你有没有把jdbc驱动包括到你的项目的classpath中