JDBC 模糊查询 传参

写dao的时候碰到模糊查询的传参，无法识别引号下的问号

1）可以利用拼接变量的方式

String sql = "select domin_id , domin_name from dmn_domin where domin_code like '"+domin_code +"%'"+" and state=? order by domin_id";

2)利用传参函数

String sql = "select domin_id , domin_name from dmn_domin where domin_code like ? and state=? order by domin_id";

PreparedStatment stat = con.prepareStatement(sql);

stat.setString(1,"?%");