String sql2="update user_info set u_last_time=(select sysdate from dual) where u_user='"+v_user+"'";
其中u_last_time 是oracle date类型的字段
尝试用一下方法获取,但是不行 请赐教~
String sql3="select u_last_time from user_info where u_user='"+v_user+"'";
ResultSet rs3=stmt.executeQuery(sql3);
String ss=(String)rs3.getString(u_last_time);
session.setAttribute("aa",ss);
提示:
org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 13 in the jsp file: /login.jsp
Generated servlet error:
u_last_time cannot be resolved
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
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)
其中u_last_time 是oracle date类型的字段
尝试用一下方法获取,但是不行 请赐教~
String sql3="select u_last_time from user_info where u_user='"+v_user+"'";
ResultSet rs3=stmt.executeQuery(sql3);
String ss=(String)rs3.getString(u_last_time);
session.setAttribute("aa",ss);
提示:
org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 13 in the jsp file: /login.jsp
Generated servlet error:
u_last_time cannot be resolved
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
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)
String sql3="select u_last_time from user_info where u_user='"+v_user+"'";
ResultSet rs3=stmt.executeQuery(sql3);
out.print("2");
String ss=rs3.getString("u_last_time");
out.print("3");
session.setAttribute("aa",ss);
out.print("4");输出结果是12
证明String ss=rs3.getString("u_last_time");有问题 请指教~
out.print(" 1");
String sql3="select u_last_time from user_info where u_user='"+v_user+"'";
ResultSet rs3=stmt.executeQuery(sql3);
out.print(" 2");
String ss=rs3.getString("u_last_time");
out.print(" 3");
session.setAttribute("aa",ss);
out.print(" 4"); 输出结果是1 2
证明String ss=rs3.getString("u_last_time");有问题 请指教~
将时间转换为字符型to_char(u_last_time, 'YYYY-MM-DD hh-mm-ss') as uctime