81,092
社区成员
发帖
与我相关
我的任务
分享
<form>
<div class="form-actions">
<button type="submit" class="btn btn-primary">确定</button>
</div>
<div class="widget widget-table">
<div class="widget-header">
<i class="icon-th-list"></i>
<h3>分销商信息</h3>
</div> <!-- /widget-header -->
<div class="widget-content">
<table class="table table-striped table-bordered" id="cusTable">
<thead>
<tr>
<th>分销商代码</th>
<th>分销商区域</th>
<th>分销商名称(SAP)</th>
<th>SAP代码</th>
<th>区域代码</th>
<th>所属物流中心</th>
<th>物流中心代码</th>
<th>省份</th>
<th>城市</th>
<th>分销商类别</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<% Distributor_dao dao =new Distributor_dao();
List<distributor> list=dao.findAllDistributors();
for (distributor distri:list)
{ %>
<tr>
<td><% distri.getIdDistributor();%></td>
<td><% System.out.println(distri.getName()); %></td>
<td>Chicago Bulls</td>
<td>Beijing</td>
<td>Beijing</td>
<td>Beijing</td>
<td>Beijing</td>
<td>Beijing</td>
<td>Beijing</td>
</tr>
<% } %>
</tbody>
</table>
</div> <!-- /widget-content -->
</div> <!-- /widget -->
</form>
public List< distributor > findAllDistributors() throws SQLException{
connectionBDD();
List <distributor> listDistributor=new ArrayList<distributor>();
rs = stmt.executeQuery("SELECT * FROM `basic info_distributors`;");
System.out.println("OK!");
while (rs.next()) {
distributor distriObjetTem=new distributor();
distriObjetTem.setCenter(rs.getString("所属物流中心"));
distriObjetTem.setCenterCity(rs.getString("所属物流中心2"));
distriObjetTem.setCity(rs.getString("所属城市"));
distriObjetTem.setCodeCenter(rs.getString("物流中心代码"));
distriObjetTem.setCodeRegion(rs.getInt("区域代码"));
distriObjetTem.setIdDistributor(rs.getString("分销商代码"));
distriObjetTem.setName(rs.getString("分销商名称(SAP)"));
distriObjetTem.setProvince(rs.getString("所属省份"));
distriObjetTem.setRegion(rs.getString("分销商区域"));
distriObjetTem.setRemark(rs.getString("备注"));
distriObjetTem.setSAP(rs.getInt("分销商SAP代码"));
distriObjetTem.setTypeDistributor(rs.getString("分销商类别"));
distriObjetTem.setValidation(rs.getString("是否有效"));
System.out.println(rs.getString("分销商代码"));
listDistributor.add(distriObjetTem);
}
System.out.println("Yeah!I've got a list of distributor from DB");
return listDistributor;
}
@Controller
@RequestMapping("/test")
public class myController {
@RequestMapping(value = "/mypage", method = RequestMethod.GET)
public ModelAndView allload(HttpServletRequest request,
HttpServletResponse response,
ModelMap modelMap) throws Exception {
ModelAndView mav = new ModelAndView();
mav.setViewName("/test/mypage" );
if (name.equals("user_list") ) {
List<Object> userlist = yourService
.findAllDistributors();
mav.addObject("userlist", userlist);
}
return mav;
}
}
比如以上代码,在你访问/test/mypage 的时候返回userlist 并跳转到mypage.jsp
然后在mypage.jsp页面用el表达式,写出来即可
<table class="table table-striped">
<thead>
<tr>
<th style="width:70%">标题</th>
<th style="width:15%;text-align:center">发布人</th>
<th style="align:right;text-align:center;">发布日期</th>
</tr>
</thead>
<tbody>
<c:forEach items="${userlist}" var="News">
<tr id="<c:out value="${News.id}"/>">
<td style="width:70%"><a href="<%=request.getContextPath()%>/news/news_info/${News.id}" target="" style="">${News.title}</a></td>
<td style="width:15%;text-align:center">${News.uname}</td>
<td style="align:right;text-align:center"><fmt:parseDate value="${News.fbdate}"
pattern="yyyy-MM-dd HH:mm:ss" var="myDate" /> <fmt:formatDate
value="${myDate}" pattern="yyyy-MM-dd" /></td>
</tr>
</c:forEach>
</tbody>
</table>