jsp:关于jsp批量删除问题

最新推荐文章于 2022-03-07 20:49:30 发布

转载最新推荐文章于 2022-03-07 20:49:30 发布 · 7.1k 阅读

文章标签：

#jsp #input #javascript #string #sql #action

数据库同时被 2 个专栏收录

71 篇文章

订阅专栏

JSP

45 篇文章

订阅专栏

本文展示了一个使用JSP进行数据库操作的例子，包括显示数据库记录、全选/反选功能及删除选定记录的功能实现。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

提交页:
test.jsp
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%
request.setCharacterEncoding("gb2312");
%>
<jsp:useBean id="temp" scope="page" class="mh.database.Operation"/>
<%
//int totalRecord = 0;
String sql = "select * from news order by id ASC";
ResultSet rs = temp.query(sql);
//totalRecord = temp.totalRecord(rs);
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>showdb with table</title>
<style>
body{
margin-top:0px;
}
</style>

<script language="javascript" type="text/javascript">
var flag=1;
function selectAll(){
if(flag==1){
if(form1.chxSong.length!=undefined){
for (var i=0;i<form1.chxSong.length;i++)
form1.chxSong[i].checked=true;
}else{
form1.chxSong.checked=true;
}
flag=0;
}else{
if(form1.chxSong.length!=undefined){
for (var i=0;i<form1.chxSong.length;i++)
form1.chxSong[i].checked=false;
}else{
form1.chxSong.checked=false;
}
flag=1;
}
}
</script>
</head>
<body>
<form action="delete.jsp" method="post" name="form1">
<table width="95%" border="1" cellspacing="0" cellpadding="3" align="center" bordercolorlight="#ECEEE4" bordercolordark="#CCCABC">
<tr>
<td colspan="4" align="center" height="30" background="image/tablebg.gif"><b>管
理文章 </b> </td>
</tr>
<tr valign="middle">
<td width="13%" height="25" align="center">ID</td>
<td width="42%" height="25" align="center">标题</td>
<td width="21%" height="25" align="center">作者</td>
<td width="24%" height="25" align="center">
<input type="button" name="selall" value="全选/反选" onClick="selectAll();">
</td>
</tr>
<%
while(rs.next())
{
%>
<tr valign="middle">
<td height="25" align="center"><%=rs.getInt("id")%></td>
<td height="25" align="center"><%=rs.getString("title")%></td>
<td height="25" align="center"><%=rs.getString("author")%></td>
<td height="25" align="center">
<input type="checkbox" name="chxSong" value="<%=rs.getInt("id")%>">
</td>
</tr>
<%
}
temp.closestmt();
temp.closeconn();
%>
<tr>
<td colspan="3"> </td>
<td align="center">
<input type="submit" value="删除" name="sendmail" onclick="return confirm(' 你确定所选？')">
</td>
</tr>
<tr valign="middle">
<td height="25" colspan="4" align="center"></td>
</tr>
</table>
</form>
<form action="act_test.jsp" method="post" name="form2">
标题：
<input type="text" name="title" onMouseOver=this.focus()><br/>
作者：
<input type="text" name="author" onMouseOver=this.focus()><br/>
来源：
<input type="text" name="source" onMouseOver=this.focus()><br/>
内容：
<INPUT type="hidden" name="content1" value="">
<IFRAME ID="eWebEditor1" src="eWebEditor.jsp?id=content1&style=standard" frameborder="0" scrolling="no" width="650" height="350"></IFRAME><br/>
<div align="center">
<input type="submit" value="提交">
<input type="reset" value="重写">
</div>
</form>
</body>
</html>
删除页:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%
request.setCharacterEncoding("gb2312");
%>
<jsp:useBean id="del" scope="page" class="mh.database.Operation"/>
<%
String[] chxSong = request.getParameterValues("chxSong");
String ids = "";
for(int i=0;i<chxSong.length;i++){
ids += "'"+chxSong[i]+"'";
if(i!=chxSong.length-1) ids+=", ";
}
String sql = "delete from news where id in ("+ids+")";
del.update(sql);
out.println("<script language=javascript> alert('删除成功！'); location.href='test.jsp';</script>");
del.closestmt();
del.closeconn();
%>

【来源】