我创建了一时间类获:
import java.util.Date;
import java.text.DateFormat;public class CountTime {
public String currentlyTime() {
Date date = new Date();
DateFormat dateFormat = DateFormat.getDateInstance(DateFormat.FULL);
return dateFormat.format(date);
}
}
我想插入到数据库中去:
<% CountTime data=new CountTime();
String datatime =data.currentlyTime();Connection con=DBConnection.getConnction(); PreparedStatement pstmt=con.prepareStatement(
"insert into tb_guestbook(gst_time) values(?)");
pstmt.setString(1,datatime);
pstmt.executeUpdate();
pstmt.close();
con.close();
response.sendRedirect("fg_show.jsp");
%>
我的JAVABean中 public String getGst_time() {
return gst_time;
}
public void setGst_time(String gst_time) {
this.gst_time = gst_time;
}
错误:
org.apache.jasper.JasperException: An exception occurred processing JSP page /fg_process.jsp at line 42
39: pstmt.setString(4,datatime);
40: pstmt.setString(4,fromIP);
41:
42: pstmt.executeUpdate();
43: pstmt.close();
44: con.close();
45: response.sendRedirect("fg_show.jsp"); org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:555)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:414)
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)
linyu.com.servlet.SessionFilter.doFilter(SessionFilter.java:48)
linyu.com.servlet.EncodingFilter.doFilter(EncodingFilter.java:34)
root cause javax.servlet.ServletException: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid parameter binding(s).
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:855)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:784)
org.apache.jsp.fg_005fprocess_jsp._jspService(fg_005fprocess_jsp.java:165)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:390)
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)
linyu.com.servlet.SessionFilter.doFilter(SessionFilter.java:48)
linyu.com.servlet.EncodingFilter.doFilter(EncodingFilter.java:34)
import java.util.Date;
import java.text.DateFormat;public class CountTime {
public String currentlyTime() {
Date date = new Date();
DateFormat dateFormat = DateFormat.getDateInstance(DateFormat.FULL);
return dateFormat.format(date);
}
}
我想插入到数据库中去:
<% CountTime data=new CountTime();
String datatime =data.currentlyTime();Connection con=DBConnection.getConnction(); PreparedStatement pstmt=con.prepareStatement(
"insert into tb_guestbook(gst_time) values(?)");
pstmt.setString(1,datatime);
pstmt.executeUpdate();
pstmt.close();
con.close();
response.sendRedirect("fg_show.jsp");
%>
我的JAVABean中 public String getGst_time() {
return gst_time;
}
public void setGst_time(String gst_time) {
this.gst_time = gst_time;
}
错误:
org.apache.jasper.JasperException: An exception occurred processing JSP page /fg_process.jsp at line 42
39: pstmt.setString(4,datatime);
40: pstmt.setString(4,fromIP);
41:
42: pstmt.executeUpdate();
43: pstmt.close();
44: con.close();
45: response.sendRedirect("fg_show.jsp"); org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:555)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:414)
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)
linyu.com.servlet.SessionFilter.doFilter(SessionFilter.java:48)
linyu.com.servlet.EncodingFilter.doFilter(EncodingFilter.java:34)
root cause javax.servlet.ServletException: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid parameter binding(s).
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:855)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:784)
org.apache.jsp.fg_005fprocess_jsp._jspService(fg_005fprocess_jsp.java:165)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:390)
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)
linyu.com.servlet.SessionFilter.doFilter(SessionFilter.java:48)
linyu.com.servlet.EncodingFilter.doFilter(EncodingFilter.java:34)
解决方案 »
- Eclipse + Tomcat 配置 求救
- 如何制作漂浮广告?
- window.dialogarguments.document为空或不是对象
- 如何控制Blob字段的图片显示位置
- 页面刷新问题
- 急 mysql中datetime与java.util.Date的问题 求大家指点~
- 在线急等。如何用jsp或js实现像qq的--》聊天模式那样的按纽,不是下来菜单。
- "查询值的数目与目标字段中的数目不同"的错误, 原因是什么?
- 几个servlet共享一些数据 如我从数据库里读出一些重要的设置存入vector 让几个servlet共享 怎么做到?先谢
- 如何写一个jsp实现上传文件
- 谁有一工作之余接私活项目开发的经验!哪方面的,有哪些要注意的地方?请指教!
- 关于 window server 2003 下tomcat 的session问题
40: pstmt.setString(4,fromIP); //为啥要设置两次啊?
41:
42: pstmt.executeUpdate();
pstmt.setString(4,fromIP);
这个只能设置一次的,因此造成的原因
40: pstmt.setString(4,fromIP); //为啥要设置两次啊?
41:
42: pstmt.executeUpdate();
pstmt.setString(4,fromIP);