bookmgr.book_name = "%" + txtbook_name.Text + "%";
bookmgr.book_author = "%" + txtbook_author.Text + "%";

bookmgr.book_pub = "%" + txtbook_pub.Text + "%";

strSQL.Append("SELECT a.book_id , a.book_name , a.book_author , a.book_pub, ");
strSQL.Append("a.book_flg , a.book_pst , b.bor_date ,b.rtn_date ");
strSQL.Append(" FROM book_master a , book_manager b ");
strSQL.Append(" where a.book_name like ? ");
strSQL.Append(" and a.book_author like ? ");
strSQL.Append(" and a.book_pub like ? ");
strSQL.Append(" and a.book_type like ? ");
strSQL.Append(" and a.book_id = b.book_id(+) ");

db.DbParametersClear();
db.DbPsetString("book_name", _book_name);
db.DbPsetString("book_author", _book_author);
db.DbPsetString("book_pub", _book_pub);
db.DbPsetString("book_type", _book_type);

[@more@]