WebRoot/jiajiaokecheng_listxls.jsp

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<jsp:useBean id="sn" scope="page" class="com.bean.SystemBean" />
<jsp:useBean id="jiajiaokechenghsgb" scope="page" class="com.bean.JiajiaokechengBean" /> 

<%
response.setContentType("application/vnd.ms-excel");
response.addHeader("Content-Disposition", "attachment;filename=jiajiaokecheng.xls");
%>
<html>
  <head>
    <title>家教课程</title>
  </head>

  <body >
 <%
			String sql="select * from jiajiaokecheng  order by id desc";

			
			%>
<table width="100%" border="1" align="center" cellpadding="3" cellspacing="1" bordercolor="00FFFF" style="border-collapse:collapse">  
  <tr>
    <td width="30" align="center" bgcolor="CCFFFF">序号</td>
    <td align='center'>课程编号</td>
    <td align='center'>课程名称</td>
    <td align='center'>类别名称</td>
    <td  width='90' align='center'>封面</td>
    
    <td align='center'>课时</td>
    <td align='center'>价格</td>
    <td  width='90' align='center'>视频</td>
    <td  width='90' align='center'>文件</td>
    
    <td align='center'>发布人</td>
    <td  width='80' align='center'>是否审核</td>
	
    <td width="120" align="center" bgcolor="CCFFFF">添加时间</td>
    
  </tr>
   <%		
				List pagelist3=jiajiaokechenghsgb.getAllJiajiaokecheng(14);
			if(!pagelist3.isEmpty()){
				for(int i=0;i<pagelist3.size();i++){
					List pagelist2 =(ArrayList)pagelist3.get(i);
			%>
  <tr>
    <td  align="center"><%=i+1 %></td>
    <td>${u.kechengbianhao}</td>
    <td>${u.kechengmingcheng}</td>
    <td>${u.leibiemingcheng}</td>
    <td width='90' align='center'><a href='${u.fengmian}' target='_blank'><img src='${u.fengmian}' width=88 height=99 border=0 /></a></td>
    
    <td>${u.keshi}</td>
    <td>${u.jiage}</td>
    <td width='90' align='center'><a href='play.jsp?spwj=${u.shipin}' target='_blank'>点此播放</a></td>
    <td width='90' align='center'><a href='${u.wenjian}' target='_blank'>下载</a></td>
    
    <td>${u.faburen}</td>
    <td align='center'>${u.issh} <input type="button" value="审核" onclick="javascript:location.href='sh.jsp?id=${u.id}&yuan=${u.issh}&tablename=jiajiaokecheng'"/></td>