[新人]jsp:mysql+tomcat5连接出错了,

cdmsan 2007-05-14 08:25:59

出错提示:
javax.servlet.ServletException: org/aspectj/lang/Signature
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:848)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
org.apache.jsp.admin.Admin_005fsys_005fclass_jsp._jspService(org.apache.jsp.admin.Admin_005fsys_005fclass_jsp:80)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

java.lang.NoClassDefFoundError: org/aspectj/lang/Signature
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Unknown Source)
com.cjy.DBMysqlConn.getConnection(DBMysqlConn.java:55)
com.cjy.DBMysqlManager.<init>(DBMysqlManager.java:15)
org.apache.jsp.admin.Admin_005fsys_005fclass_jsp._jspService(org.apache.jsp.admin.Admin_005fsys_005fclass_jsp:57)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
=====================================
jsp页面:
<%@ page language="java" contentType="text/html; charset=GB2312" pageEncoding="GB2312"%>
<%@ page import="java.sql.*" %>
<% String path = request.getContextPath();
String basePath = request.getScheme()+"://"+
request.getServerName()+":"
+request.getServerPort()+path+"/";
String title = "";
%>
<jsp:useBean id="dbsm" scope="request" class="com.cjy.DBMysqlManager" />
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title><%=title%></title>
<link href="skin/style.css" rel="stylesheet" type="text/css" />
</head>

<body>

</body>
</html>
=======================================
类页面:
//程序名称:DBMysqlConn
//程序目的:建立数据库的链接
package com.cjy;
import java.sql.*;

public class DBMysqlConn{

// driverName为驱动器类型的名称
// url为连接字符串

private String driverName = "com.mysql.jdbc.Driver";
private String url = "jdbc:mysql://localhost/cjy";

private String user = "sa";
private String password = "";
Connection conn = null;

public String getDriverName()
{
return driverName;
}
public void setDriverName(String driverName)
{
this.driverName=driverName;
}
public String getUrl()
{
return url;
}
public void setUrl(String url)
{
this.url=url;
}

public String getPassword()
{
return password;
}
public void setPassword(String password)
{
this.password=password;
}
public String getUser(){
return user;
}
public void setUser(String user)
{
this.user=user;
}

public Connection getConnection()
{
try
{
Class.forName(driverName).newInstance();// 加载驱动器
conn=DriverManager.getConnection(url, user, password);//连接到数据库.

} catch (Exception e)
{
e.printStackTrace();
conn=null;
}
return conn;
}
}
2:;;;;;;;;;;;;;;;;;;;;
//DBMysqlManager,java
//数据操作
package com.cjy;
import java.sql.*;

public class DBMysqlManager{
private Connection conn = null; // Connection对象
private Statement stmt = null; // Statement对象
private ResultSet rs = null; // 记录结果集
private String sqlstr; // sql语句
private boolean isConnect;//状态
public DBMysqlManager(){
try{
DBMysqlConn dcm = new DBMysqlConn();
conn = dcm.getConnection();//连接到数据库的
stmt = conn.createStatement();//创建一个sql语句。
}
catch (Exception e)
{
System.out.println("连接失败"+e);
isConnect=false;
}
}
public Connection getConn()
{
return conn;
}

public Statement getStmt()
{
return stmt; //用statement声明一个sql语句对象，
//然后通过创建的数据库对象conn调用createStatement()方法创建sql语句对象。
}

public ResultSet getRs()
{
return rs;
}
public ResultSet executeQuery(String sqlstr)//查询记录
{
try
{
rs = stmt.executeQuery(sqlstr);
return rs;
}
catch(SQLException e)
{
System.out.println("连接失败!"+e.toString());
return null;
}
catch(NullPointerException e)
{
System.out.println("数据库连接失败!"+e.toString());
return null;
}
}
public int executeUpdate(String sqlstr) throws Exception//修改、删除、插入记录
{
int i=stmt.executeUpdate(sqlstr);
close();
return i;

}

public void close() throws SQLException
{
if (rs != null)
{
rs.close();
rs = null;
}
if (stmt != null)
{
stmt.close();
stmt = null;
}
if (conn != null)
{
conn.close();
conn = null;
}
}
}

请问那个出错了

...全文

331 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

infon 2007-05-14

打赏
举报

上面的包名叫aspectjrt.jar,去mysql官方网站也可以下

infon 2007-05-14

打赏
举报

http://www.javaresearch.org/forum/thread.jsp?thread=35791
这网页也许对你有帮助

infon 2007-05-14

打赏
举报

1、private String url = "jdbc:mysql://localhost/cjy";
------------------
没加端口-->private String url = "jdbc:mysql://localhost:3306(或者自定义的端口)/cjy";

2、这个类没有 org.aspectj.lang.Signature

下载个jar包，去这个连接找到下载这个jar ,放到lib里面
http://www.eclipse.org/downloads/download.php?file=/technology/aspectj/aspectj-1.5.0.jar&url=http://anak.kambing.vlsm.org/eclipse/technology/aspectj/aspectj-1.5.0.jar&mirror_id=171
3、你驱动加到lib中了吗？