○複数検索キーによるＳＱＬ文

select * from deptmaster where deptcd like '%%' and deptname like '%%';

--------------------------
public class SQLtest{
	public static void main(String[] args){
		String str1 = "鈴木";
		String str2 = "";

		String sql = "select * from deptmaster where deptcd like '%" + str1 + "%' and deptname like '%"+ str2 +"%';";
						
		System.out.println(sql);
	}
}