注册 登录
编程论坛 → J2EE论坛

有一段代码有点毛病,谁指教下

大嘴先生2 发布于 2007-10-11 15:47， 1681 次点击
<%@ page import="javax.naming.Context,javax.naming.InitialContext,java.sql.Connection,javax.sql.DataSource" %>
<%
request.setCharacterEncoding("GBK");
String name=request.getParameter("user");
String title=request.getParameter("title");
String ip=request.getRemoteAddr();
Context context=new InitialContext();
DataSource ds=(DataSource)context.lookup("java:comp/env/jdbc/bookstore");
Connection conn=ds.getConnection();
PreparedStatement ps=conn.prepareStatement("insert into guestbook(user,title,posttime,ip)values(?,?,now(),?)");
ps.setString(1,name);
ps.setString(2,title);
ps.setString(3,ip);
ps.executeUpdate();
%>
<jsp:forward page="guestbook.jsp"/>


符号： 类 PreparedStatement
位置： 类 org.apache.jsp.post_jsp
PreparedStatement ps=conn.prepareStatement("insert into guestbook(user,title,posttime,ip)values(?,?,ds.now(),?)");
^
1 错误



org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
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)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:368)
12 回复
#2
千里冰封2007-10-11 16:58
import java.sql.*
#3
大嘴先生22007-10-11 20:37

我试下,谢谢老大,很久没看到你了
#4
大嘴先生22007-10-11 20:40
不行呀
#5
大嘴先生22007-10-11 20:46

行了
可是还有新错误

org.apache.jasper.JasperException: Exception in JSP: /post.jsp:13

10:    String ip=request.getRemoteAddr();
11:    Context context=new InitialContext();
12:    DataSource ds=(DataSource)context.lookup("java:comp/env/jdbc/bookstore");
13:    Connection conn=ds.getConnection();
14:    PreparedStatement ps=conn.prepareStatement("insert into guestbook(user,title,posttime,ip)values(?,?,now(),?)");
15:    ps.setString(1,name);
16:    ps.setString(2,title);


Stacktrace:
    org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:504)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
    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)
    org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:368)

root cause 

javax.servlet.ServletException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver'
    org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
    org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
    org.apache.jsp.post_jsp._jspService(post_jsp.java:72)
    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:332)
    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)
    org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:368)

root cause 

org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver'
    org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:766)
    org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
    org.apache.jsp.post_jsp._jspService(post_jsp.java:55)
    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:332)
    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)
    org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:368)
这异常弄不出来了
#6
Gramary2007-10-12 08:48
你是不是没引数据库驱动包啊
这里是不能加载数据库连接驱动~
#7
xrqsjj2007-10-12 09:18
你在页面里try{


}catch（Exception e）{


}
#8
suncf19852007-10-12 10:47
驱动没有引入进来！
#9
大嘴先生22007-10-12 13:33
没有啊 呵呵,我把驱动引入了啊,可是运行还是错误!
#10
风月_无边2007-10-12 14:22

首先確定驅動能不能正常用﹗﹗
#11
tiantiaqn2007-10-13 20:21
应该是驱动的问题
#12
netstriker2007-10-13 23:02
首先你要看一下你是用开发工具例如 Ecplise ,Jbuilder ...如果是的话请在"工程"里加入相应的驱动包 现在是mysql 所以应该相应的mysql connector 的驱动 加入到工程中.
其次,如果只是放到服务器上面 例如 tomcat 的话,就请把mysql的驱动包 应该是一个.jar包的绝对路径追加到classpath的后面.
再试一下吧,应该可以的
#13
大嘴先生22007-10-14 10:13
加了
怎么能不加呢!
1
©2025, BC-CN.NET
电脑版