📄 modifyform.jsp
字号:
modifyForm.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><% //如果客户直接进入该页面将被转向登录页面。 if(session.isNew()) {response.sendRedirect("userLogin.jsp"); } //如果没有成功登录将被转向登录页面 String success=login.getSuccess(); if(success==null) {success=""; } if(!(success.equals("ok"))) {response.sendRedirect("userLogin.jsp"); }%><HTML><BODY ><Font size=1><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><P>你的订单：<% String logname=login.getLogname(); if(logname==null) {logname=""; } Connection con; Statement sql; ResultSet rs; try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } catch(ClassNotFoundException e){} try{ con=DriverManager.getConnection("jdbc:odbc:shop","sa",""); sql=con.createStatement(); String condition="SELECT * FROM orderform WHERE logname = "+"'"+logname+"'"; rs=sql.executeQuery(condition); out.print("<Table Border>"); out.print("<TR>"); out.print("<TH width=50>"+"<Font size=1>"+"用户名"); out.print("<TH width=50>"+"<Font size=1>"+"姓名"); out.print("<TH width=160>"+"<Font size=1>"+"订购号"); out.print("<TH width=160>"+"<Font size=1>"+"书名"); out.print("<TH width=60>"+"<Font size=1>"+"订购数量"); out.print("<TH width=60>"+"<Font size=1>"+"电话"); out.print("<TH width=160>"+"<Font size=1>"+"地址"); out.print("</TR>"); while(rs.next()) { out.print("<TR>"); out.print("<TD >"+"<Font size=1>"+rs.getString(1)+"</TD>"); out.print("<TD >"+"<Font size=1>"+rs.getString(2)+"</TD>"); out.print("<TD >"+"<Font size=1>"+rs.getString(3)+"</TD>"); out.print("<TD >"+"<Font size=1>"+rs.getString(4)+"</TD>"); out.print("<TD >"+"<Font size=1>"+rs.getString(5)+"</TD>"); out.print("<TD >"+"<Font size=1>"+rs.getString(6)+"</TD>"); out.print("<TD >"+"<Font size=1>"+rs.getString(7)+"</TD>"); out.print("</TR>") ; } out.print("</Table>"); con.close(); } catch(SQLException e) { }%><P>修改订单：<%String str1=response.encodeURL("deletForm.jsp"); String str2=response.encodeURL("changeForm.jsp");%> <FORM action="<%=str1%>" method=post> <BR>输入订购号<Input TYPE=text name=order_number >* <Input type=submit name="k" value="提交删除"> </FORM> <FORM action="<%=str2%>" method=post> <BR>输入订购号<Input TYPE=text name=order_number >* <BR>输入新定数<Input TYPE=text name=mount >* <Input type=submit name="p" value="提交修改"> </FORM></BODY></HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -