📄 changeform.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%@ page import="aa.Login" %>
<jsp:useBean id="login" class="Login" scope="session" >
</jsp:useBean>
<html>
<BODY>
<table align="center"border="0"width="740"height="18"bgcolor=greencell spacing="1">
<tr>
<td width="100%">
<a href="<%=response.encodeURL("http://localhost:8080/test/showBookList.jsp")%>">书目浏览</a>|
<a href="<%=response.encodeURL("http://localhost:8080/test/userRegister.jsp")%>">用户注册</a>|
<a href="<%=response.encodeURL("http://localhost:8080/test/userLogin.jsp")%>">用户登陆 </a>|
<a href="<%=response.encodeURL("http://localhost:8080/test/buybook.jsp")%>">订购图书 </a>|
<a href="<%=response.encodeURL("http://localhost:8080/test/modifyForm.jsp")%>">修改定单 </a>|
<a href="<%=response.encodeURL("http://localhost:8080/test/showOrderForm.jsp")%>">查看定单 </a>|
<a href="<%=response.encodeURL("http://localhost:8080/test/modifyPassword.jsp")%>">修改密码 </a>|
<a href="<%=response.encodeURL("http://localhost:8080/test/modifyMessage.jsp")%>">修改个人信息 </a></td>
</tr></table>
<% //如果客户直接进入该页面将被转向登录页面。
if(session.isNew())
{response.sendRedirect("userLogin.jsp");
}
//如果没有成功登录将被转向登录页面
String success=login.getSuccess();
if(success==null)
{success="";
}
if(!(success.equals("ok")))
{response.sendRedirect("userLogin.jsp");
}
%>
<% //获取订单号：
String order_number=request.getParameter("order_number");
if(order_number==null)
{order_number="";
}
byte b[]=order_number.getBytes("ISO-8859-1");
order_number=new String(b);
//获取新的定数：
String newMount=request.getParameter("mount");
if(newMount==null)
{newMount="0";
}
byte c[]=newMount.getBytes("ISO-8859-1");
newMount=new String(c);
Connection con=null;
Statement sql=null;
ResultSet rs=null;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
try
{con=DriverManager.getConnection("jdbc:odbc:shop","sa","");
sql=con.createStatement();
String condition=
"UPDATE orderform SET mount = "+newMount+" WHERE order_number="+"'"+order_number+"'";
//更新订单：
sql.executeUpdate(condition);
out.print("<BR>"+"订单被更新");
}
catch(SQLException e)
{ out.print("<BR>"+"更新失败");
}
%>
</BODy>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -