jsp从数据库取数据到页面上

最新推荐文章于 2024-05-31 17:11:49 发布

dragoo1

最新推荐文章于 2024-05-31 17:11:49 发布

阅读量1.1w

点赞数 2

分类专栏： jsp 文章标签： jsp 数据库 List HashMap forEach

本文链接：https://blog.csdn.net/dragoo1/article/details/51544082

版权

jsp 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

环境：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 < md.getColumnCount(); 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"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
    <c:if test="${not empty listProjectName}">
        <c:forEach items="${listProjectName}" var="row">
            ${row['ID']}------${row['PROJECTNAME']}<br/>
        </c:forEach>
    </c:if>
</body>
</html>

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

dragoo1

关注

2
点赞
踩
12

收藏

觉得还不错? 一键收藏
0
评论
jsp从数据库取数据到页面上

环境：eclipse Mars Release (4.5.0)java代码： protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType
复制链接

扫一扫