tomcat6的是
在conf下的content.xml里加入了
<Resource
name="jdbc/bzydb"
type="javax.sql.DataSource"
password="abc123"
driverClassName="oracle.jdbc.driver.OracleDriver"
maxIdle="5"
maxWait="5000"
username="bzy"
url="jdbc:oracle:thin:@localhost:1521:db3cn"
maxActive="20"/>现在想建立一个类:
package dataoper;
import java.sql.Connection;
import java.sql.*;
import java.util.Enumeration;
import java.util.Vector;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
public class Conn {
public static Connection conn=null;
public static Connection f_conn()
{
Context initCtx=new InitialContext(); // 错误处1
DataSource ds = (DataSource)initCtx.lookup("java:comp/env/jdbc/bzydb"); //错误处2
Connection conn=ds.getConnection(); //错误处3
return conn;
}
}错误处123 有错
而这三行代码写在jsp的页面中时,就没有错误
刚开始做java。
以后还多关照!
在conf下的content.xml里加入了
<Resource
name="jdbc/bzydb"
type="javax.sql.DataSource"
password="abc123"
driverClassName="oracle.jdbc.driver.OracleDriver"
maxIdle="5"
maxWait="5000"
username="bzy"
url="jdbc:oracle:thin:@localhost:1521:db3cn"
maxActive="20"/>现在想建立一个类:
package dataoper;
import java.sql.Connection;
import java.sql.*;
import java.util.Enumeration;
import java.util.Vector;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
public class Conn {
public static Connection conn=null;
public static Connection f_conn()
{
Context initCtx=new InitialContext(); // 错误处1
DataSource ds = (DataSource)initCtx.lookup("java:comp/env/jdbc/bzydb"); //错误处2
Connection conn=ds.getConnection(); //错误处3
return conn;
}
}错误处123 有错
而这三行代码写在jsp的页面中时,就没有错误
刚开始做java。
以后还多关照!
private Connection con = null;
private String myDriver="oracle.jdbc.driver.OracleDriver";
public DBConnection() { }
public boolean openConnect(){
try {
Class.forName(myDriver).newInstance(); //加载驱动
con = DriverManager.getConnection("jdbc:oracle:thin:@192.168.5.3:1521:数据库名","用户名","密码");
return true;
} catch (Exception e) {
e.printStackTrace();
return false;
}
}
public Connection getConnection(){
return con;
} public boolean closeConnection(){
try{
con.close();
return true;
}catch(Exception e){return false;}
}
//===================测试连接
public static void main(String[] args) throws Exception{
DBConnection op = new DBConnection();
if(op.openConnect()){
System.out.print("成功"+"\n");}else{System.out.println("111111111");}
}}