81,092
社区成员
发帖
与我相关
我的任务
分享
public boolean isWorkDay()
{
Connection connection = null;
Statement st = null;
ResultSet rs = null;
try
{
connection = JDBCHelperV2.getConnection();
String sql_workDay = sql_getHoliday;
sql_workDay = sql_workDay.replace("@type", "2");
rs = JDBCHelperV2.executeQuery(connection, sql_workDay);
while (rs.next())
{
return true;
}
String sql_holiday = sql_getHoliday;
sql_holiday = sql_holiday.replace("@type", "1");
rs = JDBCHelperV2.executeQuery(connection, sql_holiday);
while (rs.next())
{
return false;
}
rs = JDBCHelperV2.executeQuery(connection, sql_getDayOfWeek);
while (rs.next())
{
String temp = rs.getString("weekday");
if (temp.equals("7") || temp.equals("1"))
{
return false;
}
return true;
}
}
catch(SQLException sqle)
{
throw new RuntimeException(sqle);
}
catch(Exception e)
{
}
finally
{
try {if (null != rs) {st = rs.getStatement();rs.close();}} catch(SQLException e1) {logger.error("isWorkDay:e1" + e1);}
try {if (null != st) {st.close();}} catch(SQLException e3) {logger.error("isWorkDay:e1" + e3);}
try {if (null != connection) {connection.close();}} catch(SQLException e2) {logger.error("isWorkDay:e1" + e2);}
}
return false;
}