<%@ 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)

import java.sql.*

我试下,谢谢老大,很久没看到你了

不行呀

行了
可是还有新错误

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)
这异常弄不出来了

你是不是没引数据库驱动包啊
这里是不能加载数据库连接驱动~

你在页面里try{


}catch（Exception e）{


}

驱动没有引入进来！

没有啊 呵呵,我把驱动引入了啊,可是运行还是错误!

首先確定驅動能不能正常用﹗﹗