请教大家帮我看看这个代码怎么修改？

joy19 2004-02-26 04:38:26

我现在可能有一点心乱了，老是出错，大家就行行好，我把页面个你附加过去，我已经写了，你在帮我看看！我的EnterDate是在数据库中以文本形存储的，dateDay1和dateDay2是上个页面添加的，条件是要EnterDate在dateDay1和dateDay2两个时间段之间。我现在就想让大家帮我把EnterDate和dateDay1与dateDay2之间怎么才能进行比较写一下！谢谢！

<%@ page contentType="text/html;charset=gb2312" %>
<%//@ page language="java" errorPage="../Styles/ErrorPage.jsp" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.text.SimpleDateFormat" %>

<jsp:useBean id="javaQueryResult" scope="session" class="InfoDatabase.data"/>
<jsp:useBean id="javaQueryResult1" scope="session" class="InfoDatabase.OpenDatabase"/>
<BODY>
<% String strUserName = (String) session.getValue("strUserName");
//System.out.println(strUserName);
String strPriorityOfUser = (String) session.getValue("strPriorityOfUser");
//System.out.println(strPriorityOfUser);
%>
<FORM id=FORM_QueryResult name=FORM_QueryResult action="ManageTable.jsp" method=post style="POSITION: absolute; TOP: 20px">
<%
byte[] b = new byte[128];
//取得页面信息
//员工名称
String strName = request.getParameter("strName");
b = strName.getBytes("8859_1");
strName = new String(b,"gb2312");
//System.out.println("strName");
//部门
String strDepartment = request.getParameter("strDepartment");
b = strDepartment.getBytes("8859_1");
strDepartment = new String(b,"gb2312");
//System.out.println("strDepartment");

//查询时间段
String dateDay1 = request.getParameter("dateDay1");
b = dateDay1.getBytes("8859_1");
dateDay1 = new String(b,"gb2312");

String dateDay2 = request.getParameter("dateDay2");
b = dateDay2.getBytes("8859_1");
dateDay2 = new String(b,"gb2312");
//System.out.println(dateDay2);
%>
<table name=TaskQueryTable1 width="800" border="1" bordercolor="#FF6600" align="center" cellPadding=1 cellSpacing=1>
<tr valign=middle align=center>
<td width="25%">部门</td>
<td width="25%">姓名</td>
<td width="25%">日期</td>
<td width="25%">打卡时间</td>
<%//<td width="9%">报到否</td>%>
<%//<td width="9%">未报到原因</td>%>
<%//<td width="9%">迟到时间（分）</td>%>
<%//<td width="10%">迟到原因</td>%>
<%//<td width="9%">早退否</td>%>
<%//<td width="9%">早退原因</td>%>
<%//<td width="9%">事假时间（小时）</td>%>
<%//<td width="9%">加班时间（小时）</td>%>
</tr>
<%
SimpleDateFormat sdf= new SimpleDateFormat("yyyy-MM-dd");

String sql = "select Branch,Name,EnterDate,EnterTime from 2004－2 where Name like '" +strName+ "' and Branch like '"+strDepartment+"' " ;
String sql2 ="and Format ('EnterDate','yyyy-mm-dd') >= '"+dateDay1+"' ";
String sql3 ="and Format ('EnterDate','yyyy-mm-dd') <= '"+dateDay2+"' ";

if (dateDay1.length() > 0)
{
sql +=sql2 ;
System.err.println("\n" + sql);
}
if (dateDay2.length() > 0)
{
sql +=sql3 ;
System.err.println("\n" + sql);
}
//System.err.println("\n" + sql);

ResultSet res = javaQueryResult.executeQuery( sql );
while (res.next())
{
String Branch = res.getString(1);
//System.out.println(Branch);
String Name =res.getString(2);
//System.out.println(Name);
String EnterDate = res.getString(3);
//System.out.println(EnterDate);
String EnterTime = res.getString(4);
//System.out.println(EnterTime);
//String sql4 = "insert into infodb_ManageTable (Branch,EnterDate,strName,EnterTime) values ( '"+Branch+"','"+EnterDate+"','"+Name+"','"+EnterTime+"' )";
//if (javaQueryResult1.executeUpdate(sql4))
//{
//String sql5 = "select
//System.err.println("\n" + sql4);
//}
%>
<tr valign=middle align=center>
<td width="25%" height="36"><%out.println(Branch);%></td>
<td width="25%" height="36"><%out.println(Name);%></td>
<td width="25%" height="36"><%out.println(EnterDate);%></td>
<td width="25%" height="36"><%out.println(EnterTime);%></td>
</tr>

<%
}
res.close();
%>
</table>

<%

%>
</form>

</body>

</html>

...全文