控制层接收视图层的参数,然后调用模型层的方法
模型层会将结果再通知给视图层,并更新视图层,展示给用户
搭建控制层
搭建控制层
public List<Goddess> query(List<Map<String,Object>> params) throws Exception{//按名查询多个女神
//3.通过数据库的连接操作数据库,实现增删查改
Connection conn=DBUtil.getConnection();
StringBuilder sb=new StringBuilder();
sb.append("select * from imooc_goddess where 1=1 ");
if(params!=null&¶ms.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"));
}
}
PreparedStatement ptmt=conn.prepareStatement(sb.toString());
System.out.println(sb.toString());
ResultSet rs=ptmt.executeQuery();
List<Goddess> gs=new ArrayList<Goddess>();
Goddess g=null;
while(rs.next()){
g=new Goddess();
g.setId(rs.getInt("id"));
g.setUser_name(rs.getString("user_name"));
g.setAge(rs.getInt("age"));
g.setSex(rs.getInt("sex"));
g.setBirthday(rs.getDate("birthday"));
g.setEmail(rs.getString("email"));
g.setMobile(rs.getString("mobile"));
g.setCreate_date(rs.getDate("create_date"));
g.setCreate_user(rs.getString("create_user"));
g.setUpdate_date(rs.getDate("update_date"));
g.setUpdate_user(rs.getString("update_user"));
g.setIsdel(rs.getInt("isdel"));
gs.add(g);
}
return gs;
}
List<Map<String,Object>>params=new ArrayList<Map<String,Object>>();
Map<String,Object>map=new HashMap<String,Object>();
map.put("name", "user_name");
map.put("rela", "=");
map.put("value", "'小绿'");
params.add(map);
List<Goddess>result=ga.query(params);
for(Goddess result1:result){
System.out.println(result1.toString());
}
控制层:接受view层的行为(参数),对model层数据操作,model层数据反馈给c层,c再反馈给v层
public List<Goddess> query(List<Map<String,Object>> params) throws Exception{//按名查询多个女神
//3.通过数据库的连接操作数据库,实现增删查改
Connection conn=DBUtil.getConnection();
StringBuilder sb=new StringBuilder();
sb.append("select * from imooc_goddess where 1=1 ");
if(params!=null&¶ms.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"));
}
}
PreparedStatement ptmt=conn.prepareStatement(sb.toString());
System.out.println(sb.toString());
ResultSet rs=ptmt.executeQuery();
List<Goddess> gs=new ArrayList<Goddess>();
Goddess g=null;
while(rs.next()){
g=new Goddess();
g.setId(rs.getInt("id"));
g.setUser_name(rs.getString("user_name"));
g.setAge(rs.getInt("age"));
g.setSex(rs.getInt("sex"));
g.setBirthday(rs.getDate("birthday"));
g.setEmail(rs.getString("email"));
g.setMobile(rs.getString("mobile"));
g.setCreate_date(rs.getDate("create_date"));
g.setCreate_user(rs.getString("create_user"));
g.setUpdate_date(rs.getDate("update_date"));
g.setUpdate_user(rs.getString("update_user"));
g.setIsdel(rs.getInt("isdel"));
gs.add(g);
}
return gs;
}
List<Map<String,Object>>params=new ArrayList<Map<String,Object>>();
Map<String,Object>map=new HashMap<String,Object>();
map.put("name", "user_name");
map.put("rela", "=");
map.put("value", "'小绿'");
params.add(map);
List<Goddess>result=ga.query(params);
for(Goddess result1:result){
System.out.println(result1.toString());
}
条件查找,mark