⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 modifyform.jsp

📁 可以让初学者有一个感性的认识
💻 JSP
字号:
🔍 
<HTML>
<%@page contentType="text/html;charset=GB2312"%>
<%@page import="java.sql.*" %>
<%@page import="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");
%>

<BODY bgcolor=white><Font size=3>
<%@include file="head1.txt"%>

<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","","");
		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=3>"+"用户名"+"</Font>");
			out.print("<TH width=50>"+"<Font size=3>"+"姓名"+"</Font>");
			out.print("<TH width=160>"+"<Font size=3>"+"订购号"+"</Font>");
			out.print("<TH width=160>"+"<Font size=3>"+"书名"+"</Font>");
			out.print("<TH width=60>"+"<Font size=3>"+"订购数量"+"</Font>");
			out.print("<TH width=60>"+"<Font size=3>"+"电话"+"</Font>"); 
			out.print("<TH width=160>"+"<Font size=3>"+"地址"+"</Font>");
		out.print("</TR>");

		while(rs.next())
		{
			out.print("<TR>");
				out.print("<TD>"+"<Font size=3>"+rs.getString(1)+"</TD>");
				out.print("<TD>"+"<Font size=3>"+rs.getString(2)+"</TD>");
				out.print("<TD>"+"<Font size=3>"+rs.getString(3)+"</TD>");
				out.print("<TD>"+"<Font size=3>"+rs.getString(4)+"</TD>");
				out.print("<TD>"+"<Font size=3>"+rs.getString(5)+"</TD>");
				out.print("<TD>"+"<Font size=3>"+rs.getString(6)+"</TD>");
				out.print("<TD>"+"<Font size=3>"+rs.getString(7)+"</TD>");
			out.print("</TR>");
		}
		out.print("</Table>");
		con.close();
	}catch(SQLException e){}
%>

<P>修改订单：
<%	String str1=response.encodeURL("deleteForm.jsp");
	String str2=response.encodeURL("changeForm.jsp");
%>

<FORM action="<%=str1%>" method=post>
	<BR>输入订购号<INPUT type="text" name="order_number1">*
	<INPUT type="submit" value="提交删除" name="k">
</FORM>
<FORM action="<%=str2%>" method=post>
	<BR>输入订购号<INPUT type="text" name="order_number">*
	<BR>输入新订数<INPUT type="text" name="mount">*
	<INPUT type="submit" value="提交修改" name="p">
</FORM>

</FONT>
</BODY>
</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -