jsp 倒很容易配出来。conf/context.xml
加
<Resource
name="jdbc/person"
type="javax.sql.DataSource"
password="root"
driverClassName="com.mysql.jdbc.Driver"
maxIdle="2"
maxWait="5000"
username="root"
url="jdbc:mysql://localhost:3306/person"
maxActive="4"/>
然后直接用就可以了。
但封装到java 里我到现在没搞出来,不知道是什么原因。
错误提示。
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
java.lang.ClassCastException: org.apache.tomcat.dbcp.dbcp.BasicDataSource cannot be cast to sun.jdbc.odbc.ee.DataSource rubicon.ConnDB.getConn(ConnDB.java:23) rubicon.BeanCl.getResultByPage(BeanCl.java:23) rubicon.Wel.doPost(Wel.java:42) rubicon.Wel.doGet(Wel.java:18) javax.servlet.http.HttpServlet.service(HttpServlet.java:627) javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.28 logs.
public Connection getConn(){
try {
Context ctx=new InitialContext();
DataSource ds=(DataSource)ctx.lookup("java:comp/env/jdbc/person");
conn = ds.getConnection();
} catch (NamingException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
/* String url = "jdbc:mysql://localhost:3306/person";
try {
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection(url,"root","root");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
System.out.println("无法加载驱动程序");
}catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
System.out.println("无法连接驱动程序");
}
return conn;*/
}
我用绿色文字(注释)的就成功,用上面这段就不成功。苦恼啊。这个问题我先放着,留着以后解决。路过的朋友也帮忙看看。