求jsp做的留言板 - 编程论坛

#2

ncki2007-09-23 05:53

要什么框架做的？
还是纯jsp+jdbc的？
我只有后面的，自己写的。

#3

unbelievable2007-09-23 10:50

哪一种都行，只要能用就ok，因为我只了解一点点，所以嘛，越简单越好。。。。
但我的mySQL一直连接不上，不知道是怎么回事啊？？

#4

luoxian_20032007-09-23 11:08

先打开cmd窗口输入命令
net start mysql
再连接看看

#5

unbelievable2007-09-23 12:08

代码如下:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>mysql连接数据库</title>
</head>

<body>

<%
Connection con = null;
Statement st = null;
ResultSet rs = null;
String dbuser="root";
String dbpswd="12345";
try {
try{Class.forName("com.mysql.jdbc.Driver").newInstance();}
catch (Exception e) {
out.println("Error1 :"+e.toString());
}
String url ="jdbc:mysql://localhost:3306/jnestore";
Connection conn= DriverManager.getConnection(url,dbuser,dbpswd);
st=conn.createStatement();
String sql="select * from catalog_items";
rs=st.executeQuery(sql);

while(rs.next())
{out.print("ok");}
}catch (Exception e) {
out.println("Error :"+e.toString());
}
finally {
try {
rs.close();
st.close();
con.close();
} catch (Exception ex) {
out.println("Error closing database");
} }%>

</body>
</html>

错误信息为:
type Exception report

message

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

exception

org.apache.jasper.JasperException: An exception occurred processing JSP page /rcyjc/mysql.jsp at line 19

16: String dbuser="root";
17: String dbpswd="12345";
18: try {
19: try{Class.forName("com.mysql.jdbc.Driver").newInstance();}
20: catch (Exception e) {
21: out.println("Error1 :"+e.toString());
22: }

Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:524)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:417)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

root cause

javax.servlet.ServletException: java.lang.NoClassDefFoundError: org/aspectj/lang/Signature
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:850)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp.rcyjc.mysql_jsp._jspService(mysql_jsp.java:104)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

root cause

java.lang.NoClassDefFoundError: org/aspectj/lang/Signature
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Unknown Source)
org.apache.jsp.rcyjc.mysql_jsp._jspService(mysql_jsp.java:72)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

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

#6

unbelievable2007-09-23 12:09

各位大虾指点一下啊!郁闷的不幸了啊!!!

#7

无缘今生2007-09-23 20:32

怎么发了一次又一次哦?

#8

unbelievable2007-09-23 21:17

不好意思啊哈哈

#9

风月_无边2007-09-24 18:20

估計是驅動的問題。

#10

zplove2007-09-30 13:34

try{Class.forName("com.mysql.jdbc.Driver").newInstance();}
你为什么要这样写

#11

无缘今生2007-09-30 13:50

与九楼意思相同,很可能是驱动没有配置正确.