lendinfooperate.java

一个完整的办公资源管理系统

package org.qiming.tianke.operate;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.qiming.tianke.bean.Document;
import org.qiming.tianke.bean.Lend;
import org.qiming.tianke.common.DisplayPage;

public class LendinfoOperate {

	public LendinfoOperate() {
	
	}
	//分页
	public static List getDocumentOnePage(String target,String cond){
		List resultlist=new ArrayList();
		//String filetitle,  String zihao,String draftDept,String keyWord,String formDate
		//DataBaseConnection conn=new DataBaseConnection();
		String columns="A.fileid,A.filetitle,A.zihao,A.draftDept,A.keyWord,A.formDate ";
		String tables="document A";
		cond="";
		//String sql="select inoroutid,department,name,phone,zihao,lendDate,returnDate from lend where inoroutid=2 "+cond;
		List list=DisplayPage.displayOnPage(columns, tables, "A.fileid", cond, target);
		ResultSet rs=(ResultSet)list.get(4);
		try {
			while(rs.next()){
				
				Document document=new Document(rs.getInt(1),rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getString(6));	
			    resultlist.add(document);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				rs.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			list.add(4,resultlist);
		}
		return list;
	}
   
	
	
	
}