booklendcountdao.java

一个简单的图书馆的管理系统,该系统主要是针对学校的图书馆而做的

package librarymanagement.dao.booklendcountDao;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;

import librarymanagement.dao.common.DBConnectionManager;
import librarymanagement.dao.common.DbSql;
import librarymanagement.vo.BookLendCountVo;

public class BookLendCountDao {

	DBConnectionManager manager = DBConnectionManager.getInstance();
	public Vector getBookLendCountInfo(){
		Vector v = new Vector();
		ResultSet set = null;
		Statement state = null;
		Connection con = manager.getConnection("oracle");
		try{
			state = con.createStatement();
			set = state.executeQuery(DbSql.SELECT_BOOKLEND_COUNT_DETAILS);
			
			while(set.next()){
				
			int readerId = set.getInt("reader_id");
			int bookId = set.getInt("book_id");
			String bookName = set.getString("book_name");
			String readerName =set.getString("reader_name");
			String borrowDate = set.getString("borrow_date");
			String returnDate = set.getString("should_return_date");
			v.add(new BookLendCountVo(bookId,bookName,readerId,readerName,borrowDate,returnDate));
			
			}
		}catch (SQLException e){
			System.out.println(e.getMessage());
		}
		try {
			con.close();
		} catch (SQLException e) {
	         System.out.println(e.getMessage());
			e.printStackTrace();
		}
		return v;
	}
}