我用的tomcat + JSP + mysql;
数据库驱动在tomcat的common\lib之下
Proxool-0.8.3 放在了 站台的WEB-INF/lib之下程序: <%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("org.logicalcobwebs.proxool.proxoolDriver");
Connection conn= DriverManager.getConnection("proxool.teach:org.gjt.mm.mysql.Driver:jdbc:mysql://localhost:3306/teach?user=root&password=121826&useUnicode=true&characterEncoding=8859_1");
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from gonggao";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%}%>
<%out.print("数据库操作成功,恭喜你");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
错误提示:
HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: org.logicalcobwebs.proxool.proxoolDriver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:867)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:800)
org.apache.jsp.connc_jsp._jspService(connc_jsp.java:70)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
root cause java.lang.ClassNotFoundException: org.logicalcobwebs.proxool.proxoolDriver
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1366)
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1213)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:184)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:110)
java.lang.ClassLoader.loadClassInternal(Unknown Source)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Unknown Source)
org.apache.jsp.connc_jsp._jspService(connc_jsp.java:42)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
note The full stack trace of the root cause is available in the Tomcat logs.
数据库驱动在tomcat的common\lib之下
Proxool-0.8.3 放在了 站台的WEB-INF/lib之下程序: <%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("org.logicalcobwebs.proxool.proxoolDriver");
Connection conn= DriverManager.getConnection("proxool.teach:org.gjt.mm.mysql.Driver:jdbc:mysql://localhost:3306/teach?user=root&password=121826&useUnicode=true&characterEncoding=8859_1");
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from gonggao";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%}%>
<%out.print("数据库操作成功,恭喜你");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
错误提示:
HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: org.logicalcobwebs.proxool.proxoolDriver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:867)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:800)
org.apache.jsp.connc_jsp._jspService(connc_jsp.java:70)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
root cause java.lang.ClassNotFoundException: org.logicalcobwebs.proxool.proxoolDriver
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1366)
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1213)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:184)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:110)
java.lang.ClassLoader.loadClassInternal(Unknown Source)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Unknown Source)
org.apache.jsp.connc_jsp._jspService(connc_jsp.java:42)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
note The full stack trace of the root cause is available in the Tomcat logs.
解决方案 »
- Hibernate使用原生SQL查询
- jstl <c:forEach/>能否输出指定的从1到10或10到20的数据。
- 不知道是不是难问题?java EE5.0(myEclipse)里面有没有类似于csdn左侧的导航菜单?
- 问大家一个非常简单的问题!!!!!!!
- 如何在jsp页面中使用https协议发出请求
- 【求助】 mysql 中文乱码
- 怎么样在weblogic7.0配置sql server2000呢?接着用什么方法(最好能简单点)来测试是成功的呢?
- 有谁知道?jsp与SqlServer2000的连接问题.(高手请进)
- Cookie 不能显示中文
- 请问struts的message resource是什么东东?怎么用?
- 也问out of memory错误!请高手指教!
- 新站开通,大家帮忙测试一下。如果觉得好的话,大家常来哦!
没有引用这个类啊,把含这个类的jar文件放到lib目录
<?xml version="1.0" encoding="UTF-8"?>
<proxool>
<alias>ms</alias>//连接池名称
<driver-url>jdbc:oracle:thin:@192.168.210.45:1521:ms</driver-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<driver-properties>
<property name="user" value="system"/>
<property name="password" value="manager"/>
</driver-properties>
<maximum-connection-count>50</maximum-connection-count>
<house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>
</proxool>
加载配置文件
import org.logicalcobwebs.proxool.configuration.JAXPConfigurator;public class DatasourceInitConfig
{ public void loadConfig(String fileName) throws Exception { JAXPConfigurator.configure(fileName, false); }
}调用方法 public boolean isExist(String userId) {
if (userId == null)
return false;
boolean result = false;
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
conn = DriverManager.getConnection("proxool.ms");
pstmt = conn.prepareStatement(IS_EXIST);
pstmt.setString(1, userId);
rs = pstmt.executeQuery();
if (rs.next())
result = true;
} catch (SQLException sqle) {
logger.error(sqle);
} catch (Exception e) {
logger.error(e);
}
try {
pstmt.close();
conn.close();
} catch (SQLException sqle) {
logger.error(sqle);
}
return result;
}