lendmanageroperate.java

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

package org.qiming.tianke.operate;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.*;



import org.qiming.tianke.bean.Inside;
import org.qiming.tianke.bean.Lend;
import org.qiming.tianke.bean.Outside;
import org.qiming.tianke.common.DataBaseConnection;
import org.qiming.tianke.common.DisplayPage;

public class LendManagerOperate {

	public LendManagerOperate() {
		
	}
	//内借分页
	public static List getInsideOnePage(String target,String cond){
		List resultlist=new ArrayList();
		//DataBaseConnection conn=new DataBaseConnection();
		String columns="A.lendid,A.inoroutid,A.department,A.name,A.phone,A.zihao,A.lendDate,A.returnDate ";
		String tables="lend A";
		cond=" and inoroutid=2 ";
		//String sql="select inoroutid,department,name,phone,zihao,lendDate,returnDate from lend where inoroutid=2 "+cond;
		List list=DisplayPage.displayOnPage(columns, tables, "A.lendid", cond, target);
		ResultSet rs=(ResultSet)list.get(4);
		try {
			while(rs.next()){
				
				Lend inside=new Lend(rs.getInt(1),rs.getInt(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getString(6),rs.getString(7),rs.getString(8));	
			    resultlist.add(inside);
			}
		} 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;
	}
	//外借分页
	public static List getOutsideOnePage(String target,String cond){
		List resultlist=new ArrayList();
		//DataBaseConnection conn=new DataBaseConnection();
		String columns="A.lendid,A.inoroutid,A.department,A.intruductNo,A.name,A.phone,A.zihao,A.agreePerson,A.lendDate,A.returnDate";
		String tables="lend A";
		cond=" and inoroutid=1";
		//String sql="select inoroutid,department,intruductNo,name,phone,zihao,agreePerson,lendDate,returnDate from lend where inoroutid=1 "+cond;
		List list=DisplayPage.displayOnPage(columns, tables, "A.lendid", cond, target);
		ResultSet rs=(ResultSet)list.get(4);
		try {
			while(rs.next()){
				
				Lend outside=new Lend(rs.getInt(1),rs.getInt(2),rs.getString(3),rs.getInt(4),rs.getString(5),rs.getString(6),rs.getString(7),rs.getString(8),rs.getString(9),rs.getString(10));	
			    resultlist.add(outside);
			}
		} 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;
	}
	//Lend分页
	public static List getLendOnePage(String target,String cond){
		List resultlist=new ArrayList();
		//DataBaseConnection conn=new DataBaseConnection();
		String tables="lend A";
		String columns="A.lendid,A.inoroutid,A.department,A.name,A.zihao,A.lendDate,A.returnDate,A.statusid";
		
		//String sql="select inoroutid,department,name,zihao,lendDate,returnDate,statusid from lend  "+cond;
		List list=DisplayPage.displayOnPage(columns, tables, "A.lendid", cond, target);
		ResultSet rs=(ResultSet)list.get(4);
		try {
			while(rs.next()){
				
				Lend lend=new Lend(rs.getInt(1),rs.getInt(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getString(6),rs.getString(7),rs.getInt(8));	
			    resultlist.add(lend);
			}
		} catch (SQLException e) {
			
			e.printStackTrace();
		}finally{
			try {
				rs.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			list.add(4,resultlist);
		}
		
		return list;
	}
//	public static List insideQuery(String cond){
//		List list=new ArrayList();
//		DataBaseConnection conn=new DataBaseConnection();
//		String sql="select inoroutid,department,name,phone,zihao,lendDate,returnDate from lend where inoroutid=2 "+cond;
//		ResultSet rs=conn.doQuery(sql);
//		try {
//			while(rs.next()){
//				
//				Lend inside=new Lend(rs.getInt(1),rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getString(6),rs.getString(7));	
//			    list.add(inside);
//			}
//		} catch (SQLException e) {
//			// TODO Auto-generated catch block
//			e.printStackTrace();
//		}finally{
//			conn.doClose();
//		}
//		return list;
//	}
//	public static List outsideQuery(String cond){
//		List list=new ArrayList();
//		DataBaseConnection conn=new DataBaseConnection();
//		String sql="select inoroutid,department,intruductNo,name,phone,zihao,agreePerson,lendDate,returnDate from lend where inoroutid=1 "+cond;
//		ResultSet rs=conn.doQuery(sql);
//		try {
//			while(rs.next()){
//				
//				Lend inside=new Lend(rs.getInt(1),rs.getString(2),rs.getInt(3),rs.getString(4),rs.getString(5),rs.getString(6),rs.getString(7),rs.getString(8),rs.getString(9));	
//			    list.add(inside);
//			}
//		} catch (SQLException e) {
//			// TODO Auto-generated catch block
//			e.printStackTrace();
//		}finally{
//			conn.doClose();
//		}
//		return list;
//	}
//	public static List lendQuery(String cond){
//		List list=new ArrayList();
//		DataBaseConnection conn=new DataBaseConnection();
//		String sql="select inoroutid,department,name,zihao,lendDate,returnDate,statusid from lend  "+cond;
//		ResultSet rs=conn.doQuery(sql);
//		try {
//			while(rs.next()){
//				
//				Lend lend=new Lend(rs.getInt(1),rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getString(6),rs.getInt(7));	
//			    list.add(lend);
//			}
//		} catch (SQLException e) {
//			// TODO Auto-generated catch block
//			e.printStackTrace();
//		}finally{
//			conn.doClose();
//		}
//		return list;
//	}
}