SimpleDateFormat dateformat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
Date date=new Date();
String dateTime = dateformat.format(date);
String update = "UPDATE userinfo SET lastlogin=to_date("+dateTime+",'yyyy-MM-dd HH:mi:ss'),logins=logins+1 where userid=" + userid;
String update1 = "INSERT into Log(username,uptime,lastip,content) VALUES('" + username + "','" + dateTime + "','" + lastip + "','登陆系统')";
java.sql.SQLException: ORA-01861: 文字与格式字符串不匹配 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:796)
at org.gl.Login.service(Login.java:70)
70行为int n = sql1.executeUpdate(update1);
请问哪里错了,如何解决
Date date=new Date();
String dateTime = dateformat.format(date);
String update = "UPDATE userinfo SET lastlogin=to_date("+dateTime+",'yyyy-MM-dd HH:mi:ss'),logins=logins+1 where userid=" + userid;
String update1 = "INSERT into Log(username,uptime,lastip,content) VALUES('" + username + "','" + dateTime + "','" + lastip + "','登陆系统')";
java.sql.SQLException: ORA-01861: 文字与格式字符串不匹配 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:796)
at org.gl.Login.service(Login.java:70)
70行为int n = sql1.executeUpdate(update1);
请问哪里错了,如何解决
解决方案 »
- 迷上了游戏DOTA了,怎么办呀?各位大虾帮帮出出主意
- 请大家帮我看一下这个代码谢了~~!
- ajax异常问题
- java开发的网站与基于PHP的discuz论坛结合,如何实现单点登陆?
- 急!急!JSP连接MYSQL数据库怎样才能成功????
- 请问我使用iReport-0.5.3为什么在pdf中显示不出静态中文???
- 当前最活跃、问题解决实时性最高的技术组织-----Java圣地
- 关于struts+spring+hibernate
- 请问谁有JRUN的正式版?
- rs=stmt.executeQuery(sql);是不是如果select 不到数据,这句话就不返回。我在这句话后面加了一句System.out.println("fsa")
- jsp+ajax如何获得返回集合?
- 奇怪的错误
String update1 = "INSERT into Log(username,uptime,lastip,content) VALUES('" + username + "',to_date('"+dateTime+"','yyyy-MM-dd HH:mi:ss'),'" + lastip + "','登陆系统')";