📄 list6.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@page import="java.util.*,java.text.*"%>
<jsp:useBean id='db' scope='request' class='Base.DataBean.DefaultDataBean' />
<jsp:useBean id='dealstring' scope='request' class='com.util.DealString' />
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%
com.util.DealString ds = new com.util.DealString();
com.db.CommonBean myBean = new com.db.CommonBean();
%>
<html>
<head>
<link rel=stylesheet href="../index.css" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>管理学术报告会</title>
<script>
function del(t,id){
//t.href="../kjc2_manage/list1.jsp?action=del&projectid=<%//=str_id%>"
if(confirm("你确实要删除此记录吗？")){
t.href="../kjc2_manage/list6.jsp?action=del&projectid="+id
}
}
</script>
</head>
<body>
<%
String sql = "";
//删除操作
String strAction = ds.toString((String)request.getParameter("action"));
if(strAction.equals("del")){
String strProjectId = ds.toString((String)request.getParameter("projectid"));
String sqltemp1 = "delete from kjc2_report where id="+strProjectId;
myBean.executeUpdate(sqltemp1);
}
//取得学术报告会
String curpage = ds.toString((String)request.getParameter("curpage"));
if(curpage.equals("")) curpage = "1";
int cur = Integer.parseInt(curpage);
int t=-1;
int s=-1;
int pagerow = 20;
sql = "select * from kjc2_report";
Vector vectreport = (Vector)myBean.getOnePageByMSSQL(sql,cur,pagerow);
int sumrows = Integer.parseInt((String)vectreport.get(0));//行数
int sumpages = Integer.parseInt((String)vectreport.get(1));//页数
%>
<table width="100%" height="20" border="0" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
</tr>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="790">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10"> </td>
<td width="*"><table width="100%" height="20" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="20" class="title_s"><img src="../pics/login.gif" width=50> 欢迎您>><%=(String)session.getAttribute("NAME")%> </td>
</tr>
<tr>
<td height="5" bgcolor="#C8F8BA" colspan=2></td>
</tr>
<tr>
<td height="1" bgcolor="#2E990F" colspan=2></td>
</tr>
</table></td>
</tr>
</table>
</td>
</tr>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10"> </td>
<td width="910">
<br>
<table class="main_w" width="100%" border="1" cellpadding="4" cellspacing="0" bordercolor="FFFFFF" bgcolor="E8FCE2">
<tr bgcolor="#FFFFFF" class="title_s">
<td colspan="7"><div align="center">管理学术报告会</div></td>
</tr>
<tr align="center">
<td width="5%" height="20" class="title_s">序号</td>
<td height="20" class="title_s" width="200">报告名称</td>
<td height="20" class="title_s">报告人</td>
<td height="20" class="title_s">报告人单位</td>
<td height="20" class="title_s">听众对象</td>
<td height="20" class="title_s">人数</td>
<td height="20" class="title_s" width="11%">操作</td>
</tr>
<%
int sizereport = vectreport.size();
for(int i=2;i<sizereport;i++){
Hashtable hashreport = (Hashtable)vectreport.get(i);
String str_id = ds.toString((String)hashreport.get("id"));
String str_Bh = ds.toString((String)hashreport.get("bh"));
String str_Xy = ds.toString((String)hashreport.get("xy"));
String str_Bgr = ds.toString((String)hashreport.get("bgr"));
String str_Zw = ds.toString((String)hashreport.get("zw"));
String str_Bgrdw = ds.toString((String)hashreport.get("bgrdw"));
String str_Bgmc = ds.toString((String)hashreport.get("bgmc"));
String str_Tzdx = ds.toString((String)hashreport.get("tzdx"));
String str_Rs = ds.toString((String)hashreport.get("rs"));
String str_bz = ds.toString((String)hashreport.get("bz"));
%>
<tr>
<td align=center><%=i-1%></td>
<td><a href="../kjc2_manage/view6.jsp?projectid=<%=str_id%>"><%=str_Bgmc%></a></td>
<td><%=str_Bgr%></td>
<td><%=str_Bgrdw%></td>
<td><%=str_Tzdx%></td>
<td><%=str_Rs%></td>
<td >
[<a href="../kjc2_edit/add6.jsp?actionflg=mod6&id=<%=str_id%>">修改</a>|<a href="#" onclick="del(this,<%=str_id%>)">删除</a>]
</td>
</tr>
<%
}
%>
</table>
<!-- 分页 -->
<%if(sumrows>0){%>
<table class="main_w" width="100%" border="1" cellpadding="4" cellspacing="0" bordercolor="FFFFFF" bgcolor="E8FCE2">
<tr bgcolor="#FFFFFF" class="title_s">
<td align=middle nowrap
width="72%" class=main> <b>分页</b>:
<%if(cur!=1){%>
<a href="../kjc2_manage/list6.jsp?curpage=1" style="cursor:hand">首页</a>
<%}%>
<%if(cur>1){ t=cur-1;%>
<a href="../kjc2_manage/list6.jsp?curpage=<%=t%>" style="cursor:hand">上一页</a>
<%}%>
<%if(cur<sumpages){ s=cur+1;%>
<a href="../kjc2_manage/list6.jsp?curpage=<%=s%>" style="cursor:hand">下一页</a>
<%}%>
<%if(cur<sumpages){%>
<a href="../kjc2_manage/list6.jsp?curpage=<%=sumpages%>" style="cursor:hand">尾页</a>
<%}%>
页次:<b><font color=red><%=cur%></font></b>/<b><%=sumpages%></b>页
<b><%=pagerow%></b>条/页 共<b><%=sumrows%></b>条记录
</td>
</tr>
</table>
<%}else{%>
<table border=0 cellpadding=0 cellspacing=0 class=main width="100%">
<tr>
<td align=middle nowrap width="72%" class=main>
没有学术报告会！
</td>
</tr>
</table>
<%}%>
</td>
<td width="50"> </td>
</tr>
</table>
</body>
</html>
<%
myBean.closeConn ( ) ;
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -