dbbookclass.java

本系统实现了网上书店功能

package com.util;

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

import javax.sql.DataSource;

import com.bean.BookClass;

public class DBBookClass {
	private DataSource ds;
	public DBBookClass(DataSource dataSource){
		this.ds= dataSource;
	}
	public Vector getAllBookClass() throws SQLException{
		Connection con = ds.getConnection();
		String presql="select * from bookclass";
		PreparedStatement pstmt = con.prepareStatement(presql);
		ResultSet rs = pstmt.executeQuery();
		Vector bookclassVector = new Vector();
		while(rs.next()){
			BookClass bookClass = new BookClass();
			bookClass.setBookClassID(rs.getInt("id"));
			bookClass.setBookcatName(rs.getString("catname"));
			bookclassVector.add(bookClass);
		}
		return bookclassVector;
	}

}