bookdao.java

主题：用iText输出PDF报表 内容组织： 1. 自我介绍 2. 简要介绍报表是什么 3. 为什么要输出PDF

package com.aptech.demo.itext.web;

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

public class BookDAO {
	private String driverName;
	private String url;
	private String sql;
	private String username;
	private String password;
	private Connection conn;
	private ResultSet rs;
	private PreparedStatement ps;

	public BookDAO() throws ClassNotFoundException, SQLException {
		init();
		Class.forName(driverName);
		conn = DriverManager.getConnection(url, username, password);
	}

	private void init() {
		this.driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
		this.url = "jdbc:sqlserver://localhost:1433;databaseName=Test";
		this.username = "sa";
		this.password = "5811346";
	}

	public List<Book> findAll() throws SQLException {
		this.sql = "select * from book";
		ps = conn.prepareStatement(sql);
		rs = ps.executeQuery();
		List<Book> bookList = new ArrayList<Book>();
		while (rs.next()) {
			Book b = new Book();
			b.setId(rs.getInt("id"));
			b.setBookName(rs.getString("bookname"));
			b.setAuthor(rs.getString("author"));
			b.setPublisher(rs.getString("publisher"));
			b.setPrice(rs.getDouble("price"));
			bookList.add(b);
		}
		return bookList;
	}

	public List<Book> findByExample(BookEntity book) throws SQLException {
		SqlGenerator gen = new SqlGenerator(book);
		sql = gen.createSQL();
		ps = conn.prepareStatement(sql);
		rs = ps.executeQuery();
		List<Book> bookList = new ArrayList<Book>();
		while (rs.next()) {
			Book b = new Book();
			b.setId(rs.getInt("id"));
			b.setBookName(rs.getString("bookname"));
			b.setAuthor(rs.getString("author"));
			b.setPublisher(rs.getString("publisher"));
			b.setPrice(rs.getDouble("price"));
			bookList.add(b);
		}
		return bookList;
	}

	public List<Book> findBySQL(String sql) throws SQLException {
		ps = conn.prepareStatement(sql);
		rs = ps.executeQuery();
		List<Book> bookList = new ArrayList<Book>();
		while (rs.next()) {
			Book b = new Book();
			b.setId(rs.getInt("id"));
			b.setBookName(rs.getString("bookname"));
			b.setAuthor(rs.getString("author"));
			b.setPublisher(rs.getString("publisher"));
			b.setPrice(rs.getDouble("price"));
			bookList.add(b);
		}
		return bookList;
	}

	public String getQueryCondition() {
		return sql;
	}
}