public void getTournover(Date time)//思路 先讲date 类型转化为string类型 然后在放入数据库中进行比较
{
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");//设置格式
String time1=sdf.format(time);
String sql=" SELECT oid, covers, customer_id, table_id ";
sql+=" FROM Reservation where CONVERT(varchar(10) , date, 121)=?";//date 为数据库中特定的字段
try{
JDBConnect jdbc=new JDBConnect(sql);
jdbc.setString(1, time1);
ResultSet rs=jdbc.executeQuery();
while(rs.next())
{
System.out.println(rs.getInt(1)+" "+rs.getInt(2));
}
jdbc.close();
}catch(SQLException e)
{
e.printStackTrace();
}
}
{
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");//设置格式
String time1=sdf.format(time);
String sql=" SELECT oid, covers, customer_id, table_id ";
sql+=" FROM Reservation where CONVERT(varchar(10) , date, 121)=?";//date 为数据库中特定的字段
try{
JDBConnect jdbc=new JDBConnect(sql);
jdbc.setString(1, time1);
ResultSet rs=jdbc.executeQuery();
while(rs.next())
{
System.out.println(rs.getInt(1)+" "+rs.getInt(2));
}
jdbc.close();
}catch(SQLException e)
{
e.printStackTrace();
}
}