使用 Calendar.add() 来获取 date = now - T. 一下是示意代码,未测试过:
Date now = new Date();
Calendar c = Calendar.getInstance();
c.setTime(now);
c.add(Calendar.DATE,0-T);
Date time = c.getTime();String sql = "select * from tablex where d >= ?";
PreparedStatement ps = con.prepare(sql);
ps.setTimestamp(1,time);
Resultset rs = ps.exec();
Date now = new Date();
Calendar c = Calendar.getInstance();
c.setTime(now);
c.add(Calendar.DATE,0-T);
Date time = c.getTime();String sql = "select * from tablex where d >= ?";
PreparedStatement ps = con.prepare(sql);
ps.setTimestamp(1,time);
Resultset rs = ps.exec();
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货