81,092
社区成员
发帖
与我相关
我的任务
分享
<%@ page contentType="text/html;charset=GBK" %>
<%@ page language="java" import="java.sql.*" %>
<head>
<link rel="stylesheet" type="text/css" href="../css.css" />
</head>
<center>
<table width=100%><tr><td align=center valign=top>
<script language="javascript">
function chec(){
var i;
var f=0;
for(i=0;i<document.mysel.elements.length-1;i++){
if(document.mysel.selectcheck[i].checked==true){
f=f+1;
}
}
alert("请选择要删除的条目!");
alert(f);
document.mysel.submit();
}
function allselect(){
var i;
if(document.mysel.temp.checked){
for(i=0;i<document.mysel.elements.length-1;i++){
document.mysel.selectcheck[i].checked=true;
}
}else
{
for(i=0;i<document.mysel.elements.length-1;i++){
document.mysel.selectcheck[i].checked=false;
}
}
}
function newwin(url) {
var newwin=window.open(url,"newwin","toolbar=no,location=no,directories=no,status=no, menubar=no,scrollbars=yes,resizable=yes,width=600,height=450");
newwin.focus();
return false;
}
</script>
<script LANGUAGE="javascript">
function submit10()
{
self.location.replace("fenye1.jsp")
}
</script>
<%
java.sql.Connection sqlCon;
java.sql.Statement sqlStmt;
java.sql.ResultSet sqlRst;
java.lang.String strCon;
java.lang.String strSQL;
int intPageSize;
int intRowCount;
int intPageCount;
int intPage;
java.lang.String strPage;
int i;
intPageSize = 20;
strPage = request.getParameter("page");
if(strPage==null){
intPage = 1;
}
else{
intPage = java.lang.Integer.parseInt(strPage);
if(intPage<1) intPage = 1;
}
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
strCon ="jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ="+application.getRealPath("/database/winnetdata.mdb");
sqlCon = java.sql.DriverManager.getConnection(strCon);
sqlStmt = sqlCon.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);//准备SQL语句
strSQL = "select doc_id,doc_title,doc_kind,doc_origin,doc_releasedate from winet_technologydoc order by doc_id desc";
sqlRst = sqlStmt.executeQuery(strSQL);
sqlRst.last();
intRowCount = sqlRst.getRow();
intPageCount = (intRowCount+intPageSize-1) / intPageSize;
if(intPage>intPageCount) intPage = intPageCount;
%>
<table border=1" cellspacing="0" cellpadding="0" width=100%>
<form name="mysel" method="post" action="itdoc_alldelete.jsp">
<tr>
<td align="left" colspan="8" bgcolor="#A4B6D7"></td>
</tr>
<tr>
<td align="center" bgcolor="A4B6D7"><input type="checkbox" name="temp" onclick="allselect()">全选<br/><input type=submit value="删除"></td>
<td align="center" bgcolor="A4B6D7">内部编号</td>
<td align="center" bgcolor="A4B6D7">标题</td>
<td align="center" bgcolor="A4B6D7">类型</td>
<td align="center" bgcolor="A4B6D7">来源</td>
<td align="center" bgcolor="A4B6D7">日期</td>
<td align="center" bgcolor="A4B6D7">修改</td>
<td align="center" bgcolor="A4B6D7">删除</td>
</tr>
<%
if(intPageCount>0){
sqlRst.absolute((intPage-1) * intPageSize + 1);
i = 0;
int j=1;
String tcolor=null;
String id,pname,pkind,pprice,pimages,pdoc,pforwho;
while(i<intPageSize && !sqlRst.isAfterLast()){
j=j*-1;
if(j==1)
tcolor="#EBECF3";
else
tcolor="#ffffff";
id=sqlRst.getString(1);
pname=sqlRst.getString(2);
pkind=sqlRst.getString(3);
pforwho=sqlRst.getString(4);
pprice=sqlRst.getString(5);
%>
<tr>
<td bgcolor=<%=tcolor%>><input type="checkbox" name="selectcheck" value=<%=id%>></td>
<td bgcolor=<%=tcolor%>><%=id%></td>
<td bgcolor=<%=tcolor%>><%=pname%></td>
<td bgcolor=<%=tcolor%>><%=pkind%></td>
<td bgcolor=<%=tcolor%>><%=pforwho%></td>
<td bgcolor=<%=tcolor%>><%=pprice%></td>
<td bgcolor=<%=tcolor%>><a target=rbottom href="itdoc_modify_pro.jsp?docID=<%=id%>" align="center">修改</a></td>
<td bgcolor=<%=tcolor%>><a target=rbottom href="itdoc_do_delete.jsp?docID=<%=id%>" align="center">删除</a></td>
</tr>
<%
sqlRst.next();
i++;
}
}
%>
</form>
</table>
<form method="POST" action="itdoc_manage.jsp">
第<%=intPage%>页 共<%=intPageCount%>页
<%if(intPage>1){%><a href="itdoc_manage.jsp?page=<%=intPage-1%>">
上一页</a><%}%>
<%if(intPage<intPageCount){%><a
href="itdoc_manage.jsp?page=<%=intPage+1%>">下一页
</a><%}%>
转到第:
<select name="page">
<%for(int sm=1;sm<=intPageCount;sm++){%>
<option value=<%=sm%>><%=sm%></option>
<%}%>
</select> 页
<span><input class=buttonface type=submit value=GO name=cndok></span>
</form>
<%
sqlRst.close();
sqlStmt.close();
sqlCon.close();
%>
</td></tr></table>
</center>
//ITDOC_DO_DELETE.JSP
<%@ page import="java.sql.*"%>
<head>
<link rel="stylesheet" type="text/css" href="../css.css" />
</head>
<%! int all,i,m_count;
String odbcQuery;
%>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ="+application.getRealPath("./database/winnetdata.mdb");
Connection odbcconn=DriverManager.getConnection(url);
Statement odbcstmt=odbcconn.createStatement();
odbcQuery="delete From winet_technologydoc where doc_id="+request.getParameter("docID");
odbcstmt.executeUpdate(odbcQuery);
out.println("<table width=100% align=center><tr><td idth=100% align=center>已删除 <A href=itdoc_manage.jsp>返回</A></td></tr></table>");
odbcstmt.close();
odbcconn.close();
%>