【JSP开源代码栏目提醒】:本文主要为网学会员提供update_gold.jsp,希望对需要update_gold.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 gold_id ="";
if (request.getParameter("gold_id") !=null) {gold_id = (String)request.getParameter("gold_id");}
String reality_gold ="";
if (request.getParameter("reality_gold") !=null) {reality_gold = (String)request.getParameter("reality_gold");}
String gold_value ="";
if (request.getParameter("gold_value") !=null) {gold_value = (String)request.getParameter("gold_value");}
%>
<%
Driver DriverUpdateGoldData = (Driver)Class.forName(MM_OnlineBook_DRIVER).newInstance();
Connection ConnUpdateGoldData = DriverManager.getConnection(MM_OnlineBook_STRING,MM_OnlineBook_USERNAME,MM_OnlineBook_PASSWORD);
PreparedStatement UpdateGoldData = ConnUpdateGoldData.prepareStatement("UPDATE gold_data SET reality_gold ='"+reality_gold+"', gold_value ='"+gold_value+"' WHERE gold_id ='"+gold_id+"'");
UpdateGoldData.executeUpdate();
%>
<%
response.sendRedirect("gold_list.jsp");
ConnUpdateGoldData.close();
%>