You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

67 lines
2.8 KiB

<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@page import="util.Info"%>
<%@page import="dao.CommDAO"%>
<%@page import="util.PageManager"%>
<html>
<head>
<title>课程信息</title>
<link rel="stylesheet" href="images/hsgcommon/common.css" type="text/css">
<link rel="stylesheet" href="images/hsgcommon/div.css" type="text/css">
<script type="text/javascript" src="js/My97DatePicker/WdatePicker.js" charset="gb2312"></script>
</head>
<body >
<p>已有课程信息列表:</p>
<form name="form1" id="form1" method="post" action="">
搜索:
<input type="submit" name="Submit" value="查找" class="btn btn-info btn-small" /> <input type="button" name="Submit2" value="导出EXCEL" class="btn btn-info btn-small" onClick="javascript:location.href='kechengxinxi_listxls.jsp';" />
</form>
<table width="100%" border="1" align="center" cellpadding="3" cellspacing="1" bordercolor="cccccc">
<tr>
<td width="30" align="center" bgcolor="cccccc">序号</td>
<td bgcolor='#cccccc'>教练</td>
<td bgcolor='#cccccc'>课程名称</td>
<td bgcolor='#cccccc'>锻炼部位</td>
<td bgcolor='#cccccc' width='65' align='center'>课程日期</td>
<td bgcolor='#cccccc'>学费</td>
<td bgcolor='#cccccc' width='90' align='center'>封面</td>
<td bgcolor='#cccccc' width='80' align='center'>是否审核</td>
<td width="138" align="center" bgcolor="cccccc">添加时间</td>
<td width="60" align="center" bgcolor="cccccc">操作</td>
</tr>
<%
new CommDAO().delete(request,"kechengxinxi");
String url = "kechengxinxi_list.jsp?1=1";
String sql = "select * from kechengxinxi where 1=1";
sql+=" order by id desc";
ArrayList<HashMap> list = PageManager.getPages(url,15,sql, request);
int i=0;
for(HashMap map:list){
i++;
%>
<tr>
<td width="30" align="center"><%=i %></td>
<td><%=map.get("jiaolian") %></td>
<td><%=map.get("kechengmingcheng") %></td>
<td><%=map.get("duanlianbuwei") %></td>
<td><%=map.get("kechengriqi") %></td>
<td><%=map.get("xuefei") %></td>
<td width='90' align='center'><a class="btn btn-info btn-small" href='<%=map.get("fengmian") %>' target='_blank'><img src='<%=map.get("fengmian") %>' width=88 height=99 border=0 /></a></td>
<td align='center'><a class="btn btn-info btn-small" href="sh.jsp?id=<%=map.get("id")%>&yuan=<%=map.get("issh")%>&tablename=kechengxinxi" onclick="return confirm('您确定要执行此操作?')"><%=map.get("issh")%></a></td>
<td width="138" align="center"><%=map.get("addtime") %></td>
<td width="60" align="center"><!--lianjie1--> <a class="btn btn-info btn-small" href="kechengxinxidetail.jsp?id=<%=map.get("id")%>" target="_blank">详细</a> </td>
</tr>
<%
}
%>
</table>
<br>
<p class="fy">${page.info }</p>
</body>
</html>