作者:KTone | 来源:互联网 | 2023-07-25 15:09
环境:eclipseMarsRelease(4.5.0)java代码:protectedvoiddoPost(HttpServletRequestrequest,HttpServ
环境:eclipse Mars Release (4.5.0)
java代码:
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html");
List listProjectName = new ArrayList();
String toJSP="";
String userid=request.getParameter("userid");
String sql="select * from project where createid="+userid;
JdbcBean jdbc=new JdbcBean();
try{
ResultSet rs=jdbc.query(sql);
ResultSetMetaData md = rs.getMetaData();
while(rs.next())
{
Map rowData = new HashMap();
for (int i = 1; i rowData.put(md.getColumnName(i), rs.getObject(i));
}
listProjectName.add(rowData);
}
rs.close();
request.setAttribute("listProjectName", listProjectName);
toJSP = "myproject.jsp";
}
catch(Exception e){
System.out.println("发生查询异常");
}
RequestDispatcher rd=request.getRequestDispatcher(toJSP);
rd.forward(request, response);
}
jsp代码:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
${row['ID']}------${row['PROJECTNAME']}
jsp里面查询hashmap字段时居然是大小写敏感的,平时写hml/xml写多了,在这里卡了半天
参考:
http://www.cnblogs.com/frostbelt/archive/2010/06/24/1764140.html
http://q.cnblogs.com/q/54918/
http://bbs.csdn.net/topics/390373573