import java.sql.*;
import javax.naming.*; public class DBconn { java.sql.Connection Conn = null;
javax.sql.DataSource ds = null;
java.sql.ResultSet rs = null; public DBconn() {
try{
// javax.naming.Context ctx = new javax.naming.InitialContext();
// ds = (javax.sql.DataSource)ctx.lookup("oracle-jndi-name");
// Conn=ds.getConnection();
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@10.25.4.20:1521:dbname";
String user="test";
String password="test";
Conn= DriverManager.getConnection(url,user,password); }catch(Exception e) {
Conn = null;
System.out.print("Error To Create Connection");
}
}
public ResultSet executeQuery(String sql) {
rs=null;
try {
Statement stmt=Conn.createStatement();
rs=stmt.executeQuery(sql);
} catch (SQLException ex) {
Conn = null ;
rs = null;
System.err.println("aq.execute-Query: "+ex.getMessage());
}
return rs; } }
import javax.naming.*; public class DBconn { java.sql.Connection Conn = null;
javax.sql.DataSource ds = null;
java.sql.ResultSet rs = null; public DBconn() {
try{
// javax.naming.Context ctx = new javax.naming.InitialContext();
// ds = (javax.sql.DataSource)ctx.lookup("oracle-jndi-name");
// Conn=ds.getConnection();
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@10.25.4.20:1521:dbname";
String user="test";
String password="test";
Conn= DriverManager.getConnection(url,user,password); }catch(Exception e) {
Conn = null;
System.out.print("Error To Create Connection");
}
}
public ResultSet executeQuery(String sql) {
rs=null;
try {
Statement stmt=Conn.createStatement();
rs=stmt.executeQuery(sql);
} catch (SQLException ex) {
Conn = null ;
rs = null;
System.err.println("aq.execute-Query: "+ex.getMessage());
}
return rs; } }
解决方案 »
- (奉送100分请各位帮忙啊)JSF的viewstate问题
- struts1.2.x中怎么在Action里获取 html:checkbox的值
- SSH整合问题!!!
- 奇怪了,在包package some里面是不是不能引用没有package包名的类?下面的引用错误!
- easy ui 的datagrid demo怎么显示json数据
- 请教jsp+servlet+javabean如何实现将消息发送到指定号码的手机上?
- 求助!!!!一个难以启齿的问题
- 求一般新闻发布系统的实例代码
- JSP中,怎么把IMAGE(或其它流)显示在网页上?
- 这个问题是初学jsp得人问的,主要是关于jsp的主要用途
- 多几个参数就乱码?不知为何?
- 请问:配置多个servlet的问题
public Connection getConnection() throws SQLException {
javax.sql.DataSource ds = null;
java.sql.Connection con = null;
try {
javax.naming.InitialContext ctx = new javax.naming.InitialContext();
ds = (javax.sql.DataSource) ctx.lookup("jdbc/XXXDs");
} catch (NamingException e) {
e.printStackTrace();
}
return ds.getConnection();
}