我的做法是先格式化成数据库里面的格式,然后把日期当字符串写如数据库java.util.Date time=new java.util.Date();//
SimpleDataFormat s=new SimpleDateFormat("yyyy-MM-dd");
String timeString=s.format(time);
statement.execute("update table set time ='"+timeString+"' where sn =15741);
SimpleDataFormat s=new SimpleDateFormat("yyyy-MM-dd");
String timeString=s.format(time);
statement.execute("update table set time ='"+timeString+"' where sn =15741);
symbol : class SimpleDataFormat
location: class _get__jsp
SimpleDataFormat s=new SimpleDateFormat("yyyy-MM-dd");
^
/getpassword.jsp:34: cannot resolve symbol
symbol : class SimpleDateFormat
location: class _get__jsp
SimpleDataFormat s=new SimpleDateFormat("yyyy-MM-dd");
^
2 errors
SimpleDateFormat s=new SimpleDateFormat("yyyy-MM-dd");
上面还要有import java.text.*;
不用
PreparedStatement prst = conn.prepareStatement(sql);
prst.setString(1, "\"");
prst.setString(2, "2005-01-08");
prst.executeUpdate(); Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from test"); while(rs.next()) {
System.out.println(rs.getString(1) + "\n" + rs.getDate(2));
}
结果:
"
2005-01-08
java.util.Date time1=new java.util.Date();//获得系统当前时间
String sqltime=new Timestamp(time1.getTime()).toString();//将当前时间转换成sql server可以识别的对象
//更新登录信息。
statement.execute("update user_info set userLogCount="+count+",userLastLogTime='"+sqltime+"' where userId='" + id +"'");
import java.sql.*;
public class DBConnect {
public static void main(String args[]) {
Connection conn = null; String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://192.168.18.202:3306/test";
String user = "root";
String pwd = ""; try {
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url, user, pwd); String del = "delete from test";
Statement st = conn.createStatement();
st.executeUpdate(del); String sql = "insert into test values(?,?)";
PreparedStatement prst = conn.prepareStatement(sql);
prst.setString(1, "\"");
prst.setString(2, "2005-01-09");
prst.executeUpdate(); Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from test"); while(rs.next()) {
System.out.println(rs.getString(1) + "\n" + rs.getDate(2));
}
} catch(Exception e) {
System.out.println("Error: " + e.toString());
} System.out.println("Finished!");
}
}
cast(@time as datetime)
<html><body><%
try
{
Class.forName("org.gjt.mm.mysql.Driver").newInstance(); Connection con=java.sql.DriverManager.getConnection("jdbc:mysql://127.0.0.1/gold?useUnicode=true&characterEncoding=GB2312","root","123456"); Statement stmt=con.createStatement();
java.util.Date time=new java.util.Date();
SimpleDataFormat s=new SimpleDateFormat("yyyy-MM-dd");
String timeString=s.format(time);
stmt.execute("update junior set firsttime ='"+timeString+"' where sn =15741");
stmt.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
%>
</body>
</html>
没编译过去。
这是出错信息:HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 6 in the jsp file: /jilushijian.jspGenerated servlet error:
[javac] Compiling 1 source fileD:\Tomcat 5.0\work\Catalina\localhost\li\org\apache\jsp\jilushijian_jsp.java:53: cannot resolve symbol
symbol : class SimpleDataFormat
location: class org.apache.jsp.jilushijian_jsp
SimpleDataFormat s=new SimpleDateFormat("yyyy-MM-dd");
^
1 error
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:127)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:351)
org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:415)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:458)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:552)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:291)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
note The full stack trace of the root cause is available in the Tomcat logs.