在DataSource ds = (DataSource)envContext.lookup("jdbc/ownHome");这一行
提示
Multiple ers at this line
- Watchpoint:DBConnection [access and modification] - ds
- Syntax error on token ";", , expected
package common;import java.sql.ResultSet;
import java.sql.Statement;import javax.activation.DataSource;
import javax.naming.Context;
import javax.naming.InitialContext;import com.sun.corba.se.pept.transport.Connection;public class DBConnection {
private Connection dbConn = null;
private String s_name=null,s_password=null;
private Statement stmt=null;
private ResultSet rs=null; Connection dbConnection = null; Context initContext = new InitialContext(); Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/ownHome"); dbConnection = ds.getConnection();}
提示
Multiple ers at this line
- Watchpoint:DBConnection [access and modification] - ds
- Syntax error on token ";", , expected
package common;import java.sql.ResultSet;
import java.sql.Statement;import javax.activation.DataSource;
import javax.naming.Context;
import javax.naming.InitialContext;import com.sun.corba.se.pept.transport.Connection;public class DBConnection {
private Connection dbConn = null;
private String s_name=null,s_password=null;
private Statement stmt=null;
private ResultSet rs=null; Connection dbConnection = null; Context initContext = new InitialContext(); Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/ownHome"); dbConnection = ds.getConnection();}
DataSource ds = (DataSource)envContext.lookup("jdbc/ownHome"); dbConnection = ds.getConnection();这些代码要在一个方法里。。你写个方法 返回Connection类型的数据库连接对象就行了.
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/ownHome"); dbConnection = ds.getConnection();你这一堆至少得写到一个方法里吧?
也当成员变量定义呀?
Context initContext = new InitialContext(); Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/ownHome");
dbConn = ds.getConnection();
}
写了个方法,但是提示错误,方法的最后一行
The method getConnection() is undefined for the type DataSource
public Connection getDataSource() throws Exception {
Connection dbConnection = null; Context initContext = new InitialContext(); Context envContext = (Context) initContext.lookup("java:/comp/env"); DataSource ds = (DataSource) envContext.lookup("jdbc/ownHome");
dbConn = (Connection) ds.getConnection();
return dbConn;
}
性能问题你自己解决吧,建议使用数据库连接池。
public class XXXX {
private Connection dbConn = null;
private String s_name = null, s_password = null;
private Statement stmt = null;
private ResultSet rs = null;
Connection dbConnection = null; public void a() {
try {
Context initContext = new InitialContext();
Context envContext = (Context) initContext.lookup("java:/comp/env"); DataSource ds = (DataSource) envContext.lookup("jdbc/ownHome"); dbConnection = ds.getConnection(); } catch (Exception e) { }
}
}
}