test.java

图书馆管理系统 能满足 查询

package com.jxyd;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.GregorianCalendar;
import java.util.List;

import com.jxyd.dao.AdminDAO;
import com.jxyd.dao.UserDAO;
import com.jxyd.vo.LendBean;

public class Test {
	public static void main(String[] args) throws ParseException, SQLException {
		UserDAO ud=new UserDAO();
		ArrayList<LendBean> list = ud.SelectAllLent(0, 15,null);
		List<LendBean> dlist = new ArrayList<LendBean>();
		for (LendBean ld : list)  {
			String shoureturndate = ld.getShouldReturnDate();

			GregorianCalendar now = new GregorianCalendar();
			SimpleDateFormat f = new SimpleDateFormat("yyyy-MM-dd");
			String nowdate = f.format(now.getTime());
			try {
				Date t1 = f.parse(shoureturndate);
				Date t2 = f.parse(nowdate);
				System.out.println(t1.getTime() 
						+ "*****" + t2.getTime() );
				Integer remaindate = Integer.valueOf( (int) ((t1.getTime() - t2.getTime())
						/ (1000 * 60 * 60 * 24)));// 查询将要超期的读者
                 if(remaindate<=3){
                	 System.out.println(ld.getBookCode());
                	 dlist.add(ld);             	
                 }
			} catch (ParseException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}

}