?? z_expert.jsp
字號:
<%@ page language="java" import="java.sql.*" contentType="text/html;charset=GB2312"%>
<%
String z_Loginmessage=(String)session.getValue("z_loginSign");
String adminID=(String)session.getValue("adminID");
if(z_Loginmessage!="OK")
{
response.sendRedirect("index4.jsp");
}
%>
<jsp:useBean id="z_expert" scope="page" class="firm.firm"/>
<%
String sql="select identityID,expert_name,domain,unit_name,pass from I_p_info";
ResultSet rs=z_expert.executeQuery(sql);
int pageLine=20;
int totalRec=0;
int intPage=1;
int i;
if (request.getParameter("page")!=null)
intPage=Integer.parseInt(request.getParameter("page"));
try{
String sql1="select count(*)as cnt from I_p_info";
ResultSet countrs=z_expert.executeQuery(sql1);
if(countrs.next())
totalRec=countrs.getInt("cnt");
countrs.close();
z_expert.closeStmt();
}
catch(Exception e){
e.printStackTrace();
}
int intPageCount=0;
intPageCount=(totalRec+pageLine-1)/pageLine;
%>
<html>
<head>
<title>項目總評</title>
<style>
<!--
:link {color:#000099}
:visited {color:#000099}
:active {color:#000099}
A:link,A:visited,A:active {text-decoration:none}
//-->
</style>
<script language=JavaScript>
<!--
function disConfirm(){
return confirm("確認要刪除這個專家嗎？刪除后所有關于該專家的信息將同時刪除!");
}
//-->
</script>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<table border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td bgcolor="#4f71b8">
<table width="600" border="0" cellspacing="0" cellpadding="0">
<tr bgcolor="#FFFFFF">
<td colspan="3"> </td>
</tr>
<tr>
<td colspan="3"></td>
</tr>
<tr bgcolor="#FFFFFF">
<td colspan="3"> </td>
</tr>
<tr>
<td width="33%"> </td>
<td bgcolor="#FFFFFF">
<div align="center"><img src="../images/z_zongping.gif" width="112" height="22"></div>
</td>
<td width="33%"> </td>
</tr>
</table>
<table width="600" border="0" cellspacing="1" cellpadding="0">
<tr>
<td height="77" bgcolor="#FFFFFF">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="5"> </td>
</tr>
</table>
<table width="95%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><font color="#000099">專家信息</font></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>
<table width="100%" border="1" bordercolor="#CCCCCC" cellpadding="0" cellspacing="0">
<tr>
<td width="15%" height="17"><font size="2" color="#000099">專家姓名</font></td>
<td width="22%" height="17"><font size="2" color="#000099">研究領域</font></td>
<td height="17" width="40%"><font size="2" color="#000099">所在單位</font></td>
<td height="17" width="15%" align="center"><font size="2" color="#000099">可評審</font></td>
<td height="17" align="center"> </td>
</tr>
<%
if (intPageCount>0)
{
for(i=1;i<=(intPage-1)*pageLine;i++)
rs.next();
for(i=1;i<=pageLine;i++){
if(rs.next()){
String identityID=rs.getString("identityID");
String expert_name=rs.getString("expert_name");
String domain=rs.getString("domain");
String unit_name=rs.getString("unit_name");
String passflag="";
int pass=rs.getInt("pass");
if(pass==0) passflag="未批準";
else if(pass==1) passflag="已批準";
%>
<tr>
<td><font color="#000099"><a href="z_showExpert.jsp?identityID=<%=identityID%>" target="right"><%=expert_name%></a> </font></td>
<td><font color="#000099"><%=domain%> </font></td>
<td><font color="#000099"><%=unit_name%> </font></td>
<td align="center"><a href="z_passOK.jsp?identityID=<%=identityID%>&&pass=<%=pass%>&&intPage=<%=intPage%>"><%=passflag%></a> </td>
<td align="center"><a href="z_deleteExpert.jsp?identityID=<%=identityID%>&&intPage=<%=intPage%>" onClick="return disConfirm()"><font color="#FF0000">刪除</font></a></td>
</tr>
<%
}
}
}
%>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2"> </td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<%
out.print("<tr>");
if(intPageCount*pageLine<totalRec)
intPageCount++;
if(intPage>intPageCount)
intPage=intPageCount;
if(intPage<1)
intPage=1;
out.print("<form method='post' name=fPageNum action='z_expert.jsp'>");
out.print("<p align='left'><font color='#000099'> 分頁</font> ");
if(intPage<2)
out.print("<font color='#000099'>首頁 上一頁 </font>");
else{
out.print("<a href='z_expert.jsp?page=1'><font color='#000099'>首頁</font></a> ");
out.print("<a href='z_expert.jsp?page="+(intPage-1)+"'><font color='#000099'>上一頁</font></a> ");
}
if(intPage-intPageCount>=0)
out.print("<font color='#000099'> 下一頁 尾頁</font>");
else{
out.print("<a href='z_expert.jsp?page="+(intPage+1)+"'><font color='#000099'>下一頁</font></a> <a href='z_expert.jsp?page="+intPageCount+"'><font color='#000099'>尾頁</font></a>");
}
out.print(" <font color='#000099'>頁次</font>：<strong><font color='#000099'>"+intPage+"/"+intPageCount+"</font></strong><font color='#000099'>頁</font>");
out.print(" <font color='#000099'>共</font><b><font color='#000099'>"+totalRec+"</font></b><font color='#000099'>個項目</font><b><font color='#000099'>"+pageLine+"</font></b><font color='#000099'>條/頁</font>");
out.print("<font color='#000099'>轉到第</font><input type='text' name='page' size=2 maxlength=10 class=smallInput value="+intPage+">");
out.print("<font color='#000099'>頁</font><input class=buttonface type='submit' value='GO' name='cndok'></span></p></form>");
out.print("</td>");
out.print("</tr>");
%>
<tr>
<td align="right" width="50%"><a href="z_addExpert.jsp"><img src="../images/addExpert.gif" width="80" height="22" border="0"></a> </td>
<td> <INPUT onclick=javascript:window.close(); type=image src="../images/shutdown.gif" width="80" height="22"></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -