Spring框架,如何返回数据给视图(jsp文件)

第一步 准备返回给视图的数据

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
package com.cwebs.samples; 
   
import java.util.LinkedHashMap; 
import java.util.List; 
import java.util.Map; 
   
import javax.portlet.ActionResponse; 
import javax.portlet.RenderRequest; 
import javax.portlet.RenderResponse; 
   
import org.springframework.stereotype.Controller; 
import org.springframework.web.bind.annotation.RequestMapping; 
import org.springframework.web.bind.annotation.RequestParam; 
import org.springframework.web.portlet.ModelAndView; 
   
import com.cwebs.common.CMySQL; 
import com.cwebs.common.ConnectionInfo; 
   
@Controller 
@RequestMapping("VIEW"
public class QueryBySQLViewController { 
    public ConnectionInfo ci = new ConnectionInfo( 
            "jdbc:mysql://localhost:3366/test", "root", "root");     
   
    @RequestMapping 
    public ModelAndView renderEditView(RenderRequest request,  
            RenderResponse response) throws Exception { 
        List<Map<String,String>> list=null
        try
            //step1:test open&close 
            CMySQL db = new CMySQL(ci.connStr, ci.usr, ci.pwd); 
               
            //step2:test query with return 
            list=db.executeQuery("select * from babywatch");             
            db.testResult(list);         
               
        }catch(Exception ex) 
        
            ex.printStackTrace();            
        
           
        final Map<String, Object> model = new LinkedHashMap<String, Object>(); 
        model.put("resultList", list); 
        model.put("title", "测试表格"); 
           
        return new ModelAndView("SQLQueryResult", model); 
    

  第二步 在视图中显示

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
<%@page contentType="text/html;charset=utf-8" pageEncoding="utf-8"%> 
<%@ include file="/WEB-INF/jsp/include.jsp" %> 
   
<!-- View Mode --> 
   
<h2>${title}</h2> 
   
<c:choose> 
    <c:when test="${empty resultList}"
        <p>没有记录</p> 
    </c:when> 
    <c:otherwise> 
        <table> 
         <tr> 
          <th>ID</th><th>名字</th><th>发布日期</th> 
         </tr>          
        <c:forEach var="result" items="${resultList}"
         <tr> 
          <td>${result.BABYWATCH_ID}</td> 
          <td>${result.BABYWATCH_NAME}</td> 
          <td>${result.BABYWATCH_PUBLISHDATE}</td> 
         </tr>             
        </c:forEach> 
        </table> 
    </c:otherwise> 
</c:choose> 
   
<h2>Portlet URLs</h2> 
<ul> 
    <li><a href="<portlet:renderURL portletMode="view" />">View Mode</a> 
    <li><a href="<portlet:renderURL portletMode="edit" />">Edit Mode</a> 
    <li><a href="<portlet:renderURL portletMode="help" />">Help Mode</a> 
    <li><a href="<portlet:renderURL windowState="normal" />">Normal State</a> 
    <li><a href="<portlet:renderURL windowState="maximized" />">Maximized State</a> 
    <li><a href="<portlet:renderURL windowState="minimized" />">Minimized State</a> 
</ul> 

  上例在视图中显示了一个简单的表格。

posted @   汪强胜  Views(361)  Comments(0Edit  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示