<select id="getNumber" resultType="java.lang.Integer"> select count(*) from telephonecode where create_time>=#{starttime} and create_time<=#{endtime} and telephone=#{telephone} </select>
这个是映射xml里最有效果一条
public static Date yesterday(){ //获取当前时间24小时前的时间 Calendar c = Calendar.getInstance(); c.setTime(new Date()); c.set(Calendar.HOUR_OF_DAY,c.get(Calendar.HOUR_OF_DAY) - 24); Date time= c.getTime(); return time; } public static Date onehour(){ //获取当前时间1小时前的时间 Calendar c = Calendar.getInstance(); c.setTime(new Date()); c.set(Calendar.HOUR_OF_DAY,c.get(Calendar.HOUR_OF_DAY) - 1); Date time= c.getTime(); return time; } public static Date oneminute(){ return new Date(System.currentTimeMillis()-1000*60); }