Date dt = sdf.parse("2003-12-28");中的2003-12-28是什么?
这样行吗?<%@ page contentType="text/html;charset=gb2312" %> <%@ page import="java.util.Date" %> <%@ page import="java.sql.*" %> <%@ page import="java.util.*"%> <%@ page import="java.text.SimpleDateFormat"%> <jsp:useBean id="db" scope="request" class="loginclass.db2" /> <% int count=0; String sD1 =request.getParameter("T1"); SimpleDateFormat sdf; Date d = null; sdf= new SimpleDateFormat("yyyy-MM-dd"); d = sdf.parse(sD1); String sql ="select * from members where time >='d'"; ResultSet rs =db.executeQuery(sql); while(rs.next()) { ++count; } %> <html> <body> <table border=1 cellpadding=0 cellspacing=0> <tr> <td>从<%=d%>到期间内共有<%=count%>个用户</td> </tr> </table> </body> </html>
String sql ="select * from members where time >='T1' and time <='T2'"; sql语句怎么能这样写呢?这样它会把T1,T2当成了一个字符串的! 转换字符串不用那么麻烦,你直接用String分割后拼成yyyy-mm-dd就可以啦! 或者根本就不用转换,用数据库的方法(如果是oracle)to_date()就可以啦!
<%@ page import="java.util.Date" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*"%>
<%@ page import="java.text.SimpleDateFormat"%>
<jsp:useBean id="db" scope="request" class="loginclass.db2" />
<%
int count=0;
String sD1 =request.getParameter("T1");
SimpleDateFormat sdf;
Date d = null;
sdf= new SimpleDateFormat("yyyy-MM-dd");
d = sdf.parse(sD1);
String sql ="select * from members where time >='d'";
ResultSet rs =db.executeQuery(sql);
while(rs.next())
{
++count;
}
%>
<html>
<body>
<table border=1 cellpadding=0 cellspacing=0>
<tr>
<td>从<%=d%>到期间内共有<%=count%>个用户</td>
</tr>
</table>
</body>
</html>
sql语句怎么能这样写呢?这样它会把T1,T2当成了一个字符串的!
转换字符串不用那么麻烦,你直接用String分割后拼成yyyy-mm-dd就可以啦!
或者根本就不用转换,用数据库的方法(如果是oracle)to_date()就可以啦!
库是mysql,公司里不让用别的库
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.text.SimpleDateFormat"%>
<%@ page import="java.util.Date" %>
<jsp:useBean id="db" scope="request" class="loginclass.db2" />
<%
String usertime=request.getParameter("T1");//(接收到的字符串为"2003-12-30")
System.out.println(usertime);
SimpleDateFormat sdf=new SimpleDateFormat(("yyyy-MM-dd"));
Date dt = sdf.parse(usertime);
System.out.println(dt);
%>