【JSP开源代码栏目提醒】:网学会员JSP开源代码为您提供gbook_del.jsp参考,解决您在gbook_del.jsp学习中工作中的难题,参考学习。
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="../Connections/myeshop.jsp" %>
<%
// *** Edit Operations: declare variables
// set the form action variable
String MM_editAction = request.getRequestURI();
if (request.getQueryString() != null && request.getQueryString().length() > 0) {
String queryString = request.getQueryString();
String tempStr = "";
for (int i=0; i < queryString.length(); i++) {
if (queryString.charAt(i) == '<') tempStr = tempStr + "<";
else if (queryString.charAt(i) == '>') tempStr = tempStr + ">";
else if (queryString.charAt(i) == '"') tempStr = tempStr + """;
else tempStr = tempStr + queryString.charAt(i);
}
MM_editAction += "?" + tempStr;
}
// connection information
String MM_editDriver = null, MM_editConnection = null, MM_editUserName = null, MM_editPassword = null;
// redirect information
String MM_editRedirectUrl = null;
// query string to execute
StringBuffer MM_editQuery = null;
// boolean to abort record edit
boolean MM_abortEdit = false;
// table information
String MM_editTable = null, MM_editColumn = null, MM_recordId = null;
// form field information
String[] MM_fields = null, MM_columns = null;
%>
<%
// *** Delete Record: construct a sql delete statement and execute it
if (request.getParameter("MM_delete") != null &&
request.getParameter("MM_delete").toString().equals("form1") &&
request.getParameter("MM_recordId") != null) {
MM_editDriver = MM_myeshop_DRIVER;
MM_editConnection = MM_myeshop_STRING;
MM_editUserName = MM_myeshop_USERNAME;
MM_editPassword = MM_myeshop_PASSWORD;
MM_editTable = "gbooks";
MM_editColumn = "gbk_id";
MM_recordId = "" + request.getParameter("MM_recordId") + "";
MM_editRedirectUrl = "gbook_admin.jsp";
// append the query string to the redirect URL
if (MM_editRedirectUrl.length() != 0 && request.getQueryString() != null) {
MM_editRedirectUrl += ((MM_editRedirectUrl.indexOf('?') == -1)?"?":"&") + request.getQueryString();
}
}
%>
<%
// *** Delete Record: construct a sql delete statement and execute it
if (request.getParameter("MM_delete") != null &&
request.getParameter("MM_recordId") != null) {
// create the delete sql statement
MM_editQuery = new StringBuffer("delete from ").append(MM_editTable);
MM_editQuery.append(" where ").append(MM_editColumn).append(" = ").append(MM_recordId);
if (!MM_abortEdit) {
// finish the sql and execute it
Driver MM_driver = (Driver)Class.forName(MM_editDriver).newInstance();
Connection MM_connection = DriverManager.getConnection(MM_editConnection,MM_editUserName,MM_editPassword);
PreparedStatement MM_editStatement = MM_connection.prepareStatement(MM_editQuery.toString());
MM_editStatement.executeUpdate();
MM_connection.close();
// redirect with URL parameters
if (MM_editRedirectUrl.length() != 0) {
response.sendRedirect(response.encodeRedirectURL(MM_editRedirectUrl));
return;
}
}
}
%>
<%
String recgbkdel__MMColParam = "1";
if (request.getParameter("gbk_id") !=null) {recgbkdel__MMColParam = (String)request.getParameter("gbk_id");}
%>
<%
Driver Driverrecgbkdel = (Driver)Class.forName(MM_myeshop_DRIVER).newInstance();
Connection Connrecgbkdel = DriverManager.getConnection(MM_myeshop_STRING,MM_myeshop_USERNAME,MM_myeshop_PASSWORD);
PreparedStatement Statementrecgbkdel = Connrecgbkdel.prepareStatement("SELECT * FROM gbooks WHERE gbk_id = " + recgbkdel__MMColParam + "");
ResultSet recgbkdel = Statementrecgbkdel.executeQuery();
boolean recgbkdel_isEmpty = !recgbkdel.next();
boolean recgbkdel_hasData = !recgbkdel_isEmpty;
Object recgbkdel_data;
int recgbkdel_numRows = 0;
%>
<html>
<head>
<title>留言版--刪除留言</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<!-- Fireworks MX Dreamweaver MX target. Created Tue Jan 28 14:10:55 GMT+0800 (¥x¥_?D·CRE?!) 2003-->
<script language="JavaScript" type="text/javascript">
<!--
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_nbGroup(event, grpName) { //v6.0
var i,img,nbArr,args=MM_nbGroup.arguments;
if (event == "init" && args.length > 2) {
if ((img = MM_findObj(args[2])) != null && !img.MM_init) {
img.MM_init = true; img.MM_up = args[3]; img.MM_dn = img.src;
if ((nbArr = document[grpName]) == null) nbArr = document[grpName] = new Array();
nbArr[nbArr.length] = img;
for (i=4; i < args.length-1; i+=2) if ((img = MM_findObj(args[i])) != null) {
if (!img.MM_up) img.MM_up = img.src;
img.src = img.MM_dn = args[i+1];
nbArr[nbArr.length] = img;
} }
} else if (event == "over") {
document.MM_nbOver = nbArr = new Array();
for (i=1; i < args.length-1; i+=3) if ((img = MM_findObj(args[i])) != null) {
if (!img.MM_up) img.MM_up = img.src;
img.src = (img.MM_dn && args[i+2]) ? args[i+2] : ((args[i+1])? args[i+1] : img.MM_up);
nbArr[nbArr.length] = img;
}
} else if (event == "out" ) {
for (i=0; i < document.MM_nbOver.length; i++) {
img = document.MM_nbOver[i]; img.src = (img.MM_dn) ? img.MM_dn : img.MM_up; }
} else if (event == "down") {
nbArr = document[grpName];
if (nbArr)
for (i=0; i < nbArr.length; i++) { img=nbArr[i]; img.src = img.MM_up; img.MM_dn = 0; }
document[grpName] = nbArr = new Array();
for (i=2; i < args.length-1; i+=2) if ((img = MM_findObj(args[i])) != null) {
if (!img.MM_up) img.MM_up = img.src;
img.src = img.MM_dn = (args[i+1])? args[i+1] : img.MM_up;
nbArr[nbArr.length] = img;
} }
}
//-->
</script>
<style type="text/css">
<!--
.lineBox {
border: 1px dotted #CCCCCC;
}
.Box {
border: 1px solid #666666;
}
a.ImgButton:hover {
left: 2px;
top: 2px;
right: 0px;
bottom: 0px;
position: relative;
}
-->
</style>
<style type="text/css">
<!--
form {
margin: 0px;
}
.Box1 { border: 1px solid #666666;
clear: both;
}
.style5 {font-weight: bold}
.style6 {color: #FFFFFF; font-size: 18px;}
Boxdel {
font-size: 16px;
}
.style8 {font-size: 16}
-->
</style>
</head>
<body bgcolor="#ffffff" onload="MM
上一篇:
gbook_admin.jsp
下一篇:
那些令你为之触动的好句子,感慨万分