模型層：

public List<Goddness> query(List<Map<String,Object>>params) throws Exception{

//獲取數(shù)據(jù)庫連接

Connection conn=DBUtil.getConnection();

StringBuilder sb=new StringBuilder();

sb.append("select * from imooc_goddness 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")+" ");

}

}

PreparedStatement ptmt=conn.prepareStatement(sb.toString());

System.out.println(sb.toString());

ResultSet rs=ptmt.executeQuery();

? ? List<Goddness> result=new ArrayList<Goddness>();

? ? Goddness g=null;

? ? while(rs.next())

? ? ? ?{

? ? g=new Goddness();

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"));

? ? ? ? ?result.add(g);

? ? ? ? ?}

return result;

? ?}

}

視圖層：

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", "=");

System.out.println("請輸入要查詢女神姓名：");

map.put("value", scan.next());

params.add(map);

List<Goddness> result=action.query(params);

for(Goddness g:result){

System.out.println(g);

}

控制臺提示錯誤如下：