sqlgenerator.java

来自「主题：用iText输出PDF报表 内容组织： 1. 自我介绍 2. 简要介」· Java 代码 · 共 55 行

package com.aptech.demo.itext.web;

public class SqlGenerator {
	private StringBuffer sql = new StringBuffer("select * from book");

	public SqlGenerator(BookEntity book) {
		boolean flag = false;
		if ((book.getBookName() != null && book.getBookName().length() > 0)
				|| (book.getAuthor() != null && book.getAuthor().length() > 0)
				|| (book.getPublisher() != null && book.getPublisher().length() > 0)
				|| book.getPriceLow() > 0 || book.getPriceHigh() > 0) {
			sql.append(" where ");
		}
		if (book.getBookName() != null && book.getBookName().length() > 0) {
			if (flag) {
				sql.append(" and ");
			}
			sql.append("bookname like '%" + book.getBookName() + "%'");
			flag = true;

		}
		if (book.getAuthor() != null && book.getAuthor().length() > 0) {
			if (flag) {
				sql.append(" and ");
			}
			sql.append("author like '%" + book.getAuthor() + "%'");
			flag = true;
		}
		if (book.getPublisher() != null && book.getPublisher().length() > 0) {
			if (flag) {
				sql.append(" and ");
			}
			sql.append("publisher like '%" + book.getPublisher() + "%'");
			flag = true;
		}
		if (book.getPriceLow() > 0) {
			if (flag) {
				sql.append(" and ");
			}
			sql.append("price>=" + book.getPriceLow());
			flag = true;
		}
		if (book.getPriceHigh() > 0) {
			if (flag) {
				sql.append(" and ");
			}
			sql.append("book.price<=" + book.getPriceHigh());
			flag = true;
		}
	}

	public String createSQL() {
		return sql.toString();
	}
}