您现在的位置是：主页 > news > ppt素材免费网站/谷歌关键词搜索排名
ppt素材免费网站/谷歌关键词搜索排名
admin2025/5/3 20:00:50【news】
简介ppt素材免费网站,谷歌关键词搜索排名,网站维护是什么样,太原网站 制作为解决网友的问题而写的实例，相关地址 http://bbs.csdn.net/topics/390383104?page1#post-393839610 在同一个JSP页面处理删除操作，主要是将要删除的记录id作为当前jsp页面的参数传入，若参数不为空则获取deleteIds参数信息执行删除操作 inde…
ppt素材免费网站,谷歌关键词搜索排名,网站维护是什么样,太原网站 制作为解决网友的问题而写的实例，相关地址 http://bbs.csdn.net/topics/390383104?page1#post-393839610 在同一个JSP页面处理删除操作，主要是将要删除的记录id作为当前jsp页面的参数传入，若参数不为空则获取deleteIds参数信息执行删除操作 inde…
为解决网友的问题而写的实例，相关地址 http://bbs.csdn.net/topics/390383104?page=1#post-393839610
在同一个JSP页面处理删除操作，主要是将要删除的记录id作为当前jsp页面的参数传入，若参数不为空则获取deleteIds参数信息执行删除操作
index.jsp文件内容：
<%@ page contentType="text/html; charset=UTF-8"%>
<%@ page import="java.sql.*"%>
<%
//驱动类名
String className = "org.gjt.mm.mysql.Driver";
// 数据库URL
String url = "jdbc:mysql://localhost/win";
// 用户名
String userName = "root";
// 密码
String password = "";String listSql = "select * from email_history order by id limit 1,100";
String deleteSql = "delete from email_history where id in (%s)";Class.forName(className);
Connection conn = DriverManager.getConnection(url, userName, password);
Statement stmt = conn.createStatement();String deleteIds = request.getParameter("deleteIds");
if(deleteIds!=null && !"".equals(deleteIds)) {stmt.execute(String.format(deleteSql, deleteIds));
}
%>
<html>
<head>
<title>会议信息</title>
</head><body><table border="1">
<%
ResultSet rs = stmt.executeQuery(listSql);
String ids = "";
while (rs.next()){ids += "," + rs.getInt("id");
%><tr><td><input type="checkbox" id='checkbox_<%=rs.getInt("id") %>' name='checkbox_<%=rs.getInt("id") %>' οnclick="doCheck()" /></td><td><%=rs.getInt("id") %></td><td><%=rs.getString("title") %></td><td><%=rs.getString("from_email").replaceAll("<","<").replaceAll(">",">") %></td><td><%=rs.getString("to_email") %></td></tr>
<%
}
if(!"".equals(ids)) {ids = ids.substring(1);
}
%><tr><td colspan="5"><input type="checkbox" id="checkall" name="checkall" οnclick="checkAll()" /> 全选<input type="button" value="删除" οnclick="doDelete()" /></td></tr></table><script type="text/javascript">
var ids = '<%=ids %>';
function doDelete() {if(ids=='') {return;}var deleteIds = "";var idList = ids.split(",");var len = idList.length;for(var i=0; i<len; i++) {if($("checkbox_" + idList[i]).checked) {deleteIds += "," + idList[i];}}if(deleteIds=="") {alert("请选择要删除的记录！");return;}deleteIds = deleteIds.substr(1);location.href = "./index.jsp?deleteIds=" + deleteIds;
}
function doCheck() {if(ids=='') {return;}var deleteIds = "";var idList = ids.split(",");var len = idList.length;var checkall = $("checkall");for(var i=0; i<len; i++) {if(!$("checkbox_" + idList[i]).checked) {checkall.checked = false;return;}}checkall.checked = true;
}
function checkAll() {if(ids=='') {return;}var idList = ids.split(",");var len = idList.length;var checkall = $("checkall");for(var i=0; i<len; i++) {$("checkbox_" + idList[i]).checked = checkall.checked;}
}
function $(id) {return document.getElementById(id);
}
</script>
</body>
</html>
