public static void main(String[] args) throws Exception {
List<Map<String, Object>> params=new ArrayList<Map<String, Object>>();
Map<String,Object> param=new HashMap<String,Object>();
param.put("name", "user_name");
param.put("rela", "=");
param.put("value", "'小达'");
params.add(param);
Map<String,Object> param2=new HashMap<String,Object>();
param2.put("name", "age");
param2.put("rela", "=");
param2.put("value", "24");
params.add(param2);
List<Goddess> l=g.query(params);
for (Goddess goddess : l) {
System.out.println(goddess.toString());
}
}
public List<Goddess> query(List<Map<String, Object>> params) throws Exception{
List<Goddess> result=new ArrayList<Goddess>();
Connection conn=CONN.Conn();
StringBuilder sb=new StringBuilder();
sb.append("select * from imooc_goddess where 1=1");
if(params!=null && params.size()>0){
for (int i = 0; i < params.size(); i++) {
Map<String, Object> map=params.get(i);
sb.append(" and "+map.get("name")+" "+map.get("rela")+" "+map.get("value")+" ");
}
}
System.out.println(sb.toString());
PreparedStatement ptmt=conn.prepareStatement(sb.toString());
ResultSet rs=ptmt.executeQuery();
Goddess g=null;
while(rs.next()){
}
}
MySQL数据库传参(JAVA)
最新推荐文章于 2021-03-13 12:13:16 发布