JSP连接Mysqld的问题——连不上收藏

: DazzlingBeing; DazzlingBeing; 等级：; 结帖率：100%

楼主发表于： 2007-03-28 10:45:44

环境变量的设置：（应该没问题，测试的Java，JSP,Severlet,JavaBean均通过，Java和Connector都是5.0以上的版本，Tomcat也是最新的）
.;
%JAVA_HOME%\lib\dt.jar;
%JAVA_HOME%\lib\tools.jar;
%JAVA_HOME%\lib\mysql-connector-java-5.0.5-bin-g.jar;
%JAVA_HOME%\mysql-connector-java-5.0.5\mysql-connector-java-5.0.5-bin.jar;
%TOMCAT_HOME%\common\lib\servlet.jar
不连接数据库，只将
html><body><center>
Now time is: <%=new java.util.Date()%>
</center></body></html>
存放到Tomcat下的相应位置，运行正常。当需要连接Mysql时，Tomcat报错：
type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: Unable to compile class for JSP

Generated servlet error:
Only a type can be imported. com.mysql.jdbc.Driver resolves to a package

org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:512)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

org.apache.jasper.JasperException: Unable to compile class for JSP

Generated servlet error:
Only a type can be imported. com.mysql.jdbc.Driver resolves to a package

org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:328)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:414)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:297)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:276)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:264)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:563)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:305)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

note The full stack trace of the root cause is available in the Apache Tomcat/5.5.20 logs.

这是怎么回事啊。

另付程序代码：
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page language="java" %>
<%@ page import="com.mysql.jdbc.Driver" %>
<%@ page import="java.sql.*" %>
<%
  //驱动程序名
  String driverName="com.mysql.jdbc.Driver";
  //数据库用户名
  String userName="root";
  //密码
  String userPasswd="";
  //数据库名
  String dbName="test";
  //表名
  String tableName="t_gbk";
  //联结字符串
  String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd;
  Class.forName("com.mysql.jdbc.Driver").newInstance();
  Connection connection=DriverManager.getConnection(url);
  Statement statement = connection.createStatement();
  String sql="SELECT * FROM "+tableName;
  ResultSet rs = statement.executeQuery(sql);
  //获得数据结果集合
   ResultSetMetaData rmeta = rs.getMetaData();
  //确定数据集的列数，亦字段数
   int numColumns=rmeta.getColumnCount();
  // 输出每一个数据值
out.print("id");
out.print("|");
out.print("num");
out.print("<br>");
while(rs.next()) {
out.print(rs.getString(1)+" ");
out.print("|");
out.print(rs.getString(2));
out.print("<br>");
}
out.print("<br>");
out.print("数据库操作成功，恭喜你");
rs.close();
statement.close();
connection.close();
%>

对我有用[0] 丢个板砖[0] 引用 | 举报 | 管理

回复次数：4

: zjntche_cn; zjntche_cn; 等级：

#1 得分：0回复于： 2007-03-28 10:59:29

mysql-connector-java-5.0.5-bin-g.jar这个文件应该拷贝到tomcat的lib目录下

posted on 2013-09-11 22:58 HPU---张振强阅读(207) 评论(0) 编辑收藏举报

JSP连接Mysqld的问题——连不上 不显示删除回复 显示所有回复 显示星级回复 显示得分回复 只显示楼主 收藏

JSP连接Mysqld的问题——连不上收藏