How simple does it have to be???
I use these as Strings right now, but I was wondering, if you could help me that is, what date should I set as one of my MS Access database fields
Also, I want to be able to make my String representation of a date, get turned to a date obeject, used in the database, then turned back to the String again. can this be done?
How simple does it have to be???
OCUP UML fundamental and ITIL foundation
How simple does it have to be???
my database worked with column_1 set as varchar and I could store the date as a string, but i changed the database to a long date, which outputs on the database as 12 May 2007.
<td class="style3">:
<input name="date" type="text" id="date" value="<% org.joda.time.DateTime dt = new org.joda.time.DateTime();%>
<%= dt.toString("yyyy-MM-dd hh:mm:ss") %>" size="50" readonly="true"></td>
<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>
<%
String date = request.getParameter("PostDate");
String name = request.getParameter("Name");
String email = request.getParameter("Email");
String msg = request.getParameter("Message");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+application.getRealPath("/WEB-INF/data.mdb");
Connection con = DriverManager.getConnection(url);
Statement state = con.createStatement();
String query = "insert into GuestBook values ('" + date + "','"+ name + "','" + email + "','" + msg + "')";
state.executeUpdate(query);
response.sendRedirect("guestbook.jsp");
%>
root cause
javax.servlet.ServletException: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
org.apache.jsp.insertGuestBook_jsp._jspService(insertGuestBook_jsp.java:69)
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)
Evil is afoot. But this tiny ad is just an ad:
Smokeless wood heat with a rocket mass heater
https://woodheat.net
|