剑三哪个区人多2017:@@@@@@@@高分求教问题JSP、SQL函数count

来源:百度文库 编辑:查人人中国名人网 时间:2024/05/06 04:37:30
<% String sql="SELECT GETDATE() AS ctime";
ResultSet rs=db.executeQuery(sql);
if(rs.next())
out.println(rs.getString("ctime"));%>

我想把getdate()得到的日期值存储到一个变量之中,怎么实现??如果这样
<% String sql="SELECT GETDATE() AS ctime";
String d;
ResultSet rs=db.executeQuery(sql);
if(rs.next())
d=rs.getString("ctime");
out.println(d);%>
还是出错了,因为d并没有得到值,而系统还提示d需要初始化。

org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 148 in the jsp file: /AGAIA/rest.jsp

Generated servlet error:
[javac] Compiling 1 source file

F:\Tomcat\work\Catalina\localhost\_\org\apache\jsp\AGAIA\rest_jsp.java:208: variable d might not have been initialized
out.println(d);
^

<%
String sqll="SELECT GETDATE() AS ctime";
String d=""; ------"空格"
ResultSet rsl=db.executeQuery(sqll);
if(rsl.next())
d=rsl.getString("ctime");
out.println(d);
%>

用<%
.........
String d = "";
ResultSet rs=db.executeQuery(sql);
if(rs.next())
d=rs.getString("ctime");
out.println(d);%>