SQLs:
package com.zking.mapper;
import com.zking.pojo.province;
import org.apache.ibatis.jdbc.SQL;
public class SQLs {
public String Find() {
return new SQL().SELECT("*").FROM("province").toString();
}
public String Find1(final String pname, final String pid) {
return new SQL() {
{
SELECT("*");
FROM("province");
if (pname != null) {
WHERE("pname=#{param1}");
}
if (pid != null) {
WHERE("pid like #{param2}");
}
}}.toString();
}
public String Find2(final province province) {
return new SQL() {
{
SELECT("*");
FROM("province");
if (province.getPid()!= null) {
AND();
WHERE("pid=#{pid}");
}
if (province