代码内格式化日期输出

 

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 + "',to_date('"+dateTime+"','yyyy-MM-dd HH:mi:ss'),'" + lastip + "','登陆系统')";
  				

 

int n = sql1.executeUpdate(update1);
int f = sql1.executeUpdate(update);