bookclassdao.java

fahirjgjkdfjkl 丰卡时间阿科技安分 发 啊啊啊啊啊

package com.bookshop.dao;

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


import com.bookshop.dto.BookClass;
import com.bookshop.util.DBManager;
public class BookClassDAO{

public List getBookClass(){
	List list=new ArrayList();
	BookClass bookClass=null;
	ResultSet rs=null;
	try{
		PreparedStatement pstmt=DBManager.getConnection().prepareStatement("SELECT * FROM BOOKCLASS_TAB");
		rs=pstmt.executeQuery();
		while(rs.next()){
			bookClass=new BookClass();
			bookClass.setId(rs.getInt("id"));
			bookClass.setName(rs.getString("name"));
			list.add(bookClass);
			
		}
	}catch(SQLException e){e.printStackTrace();}
	return list;
}
}