【JSP开源代码栏目提醒】:网学会员为广大网友收集整理了,update_pub.jsp,希望对大家有所帮助!
<meta name="generator" content="Namo WebEditor(Trial)">
<% // %>
<%@ page contentType="text/html; charset=big5" language="java" import="java.
sql.*" errorPage="" %>
<%@ include file="../../../Connections/OnlineBook.jsp" %>
<%request.setCharacterEncoding("big5");%>
<%
String pub_id ="";
if (request.getParameter("pub_id") !=null) {pub_id = (String)request.getParameter("pub_id");}
String pub_name ="";
if (request.getParameter("pub_name") !=null) {pub_name = (String)request.getParameter("pub_name");}
%>
<%
Driver DriverUpdatePub = (Driver)Class.forName(MM_OnlineBook_DRIVER).newInstance();
Connection ConnUpdatePub = DriverManager.getConnection(MM_OnlineBook_STRING,MM_OnlineBook_USERNAME,MM_OnlineBook_PASSWORD);
PreparedStatement UpdatePub = ConnUpdatePub.prepareStatement("UPDATE online_book.publishing SET pub_name = '"+pub_name+"' WHERE pub_id ='"+pub_id+"'");
UpdatePub.executeUpdate();
%>
<%
response.sendRedirect("close_window.jsp");
ConnUpdatePub.close();
%>