📄 buybook.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%@ page import="j0202_05_login.*" %>
<%@ page import="java.io.*" %>
<%!
public String codeString(String s)
{String str=s;
try{byte b[]=str.getBytes("ISO-8859-1");
str=new String (b);
return str;
}
catch(Exception e)
{return str;
}
}
%>
<HTML>
<BODY color="#FF6600"><Font SIZE=4>
<jsp:useBean id="login" class="j0202_05_login.Login" scope="session" >
</jsp:useBean>
<a href="<%=response.encodeURL("main.jsp") %>">首页(main)</a>
<a href="<%=response.encodeURL("registertj.jsp") %>">用户注册(register)</a>
<a href="<%=response.encodeURL("bookinftj.jsp") %>">录入图书(bookinf)</a>
<a href="<%=response.encodeURL("buybook.jsp") %>">查看订单(bookinf)</a>
<br>
<P>
您的订单:
<% String cus_name=login.getCus_name();
if(cus_name==null)
{cus_name="";
}
cus_name=codeString(cus_name);
Connection con;
Statement sql;
ResultSet rs;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
try{
con=DriverManager.getConnection("jdbc:odbc:LocalServer","sa","");
sql=con.createStatement();
String condition="select * from buyinf where cus_name="+"'"+cus_name+"'";
rs=sql.executeQuery(condition);
out.print("<Table Border>");
out.print("<TR>");
out.print("<TH width=50>"+"<Font size=1>"+"表单号"+"</Font>");
out.print("<TH width=50>"+"<Font size=1>"+"商品编号"+"</Font>");
out.print("<TH width=50>"+"<Font size=1>"+"商品名称"+"</Font>");
out.print("<TH width=40>"+"<Font size=1>"+"作者"+"</Font>");
out.print("<TH width=40>"+"<Font size=1>"+"单价"+"</Font>");
out.print("<TH width=40>"+"<Font size=1>"+"数量"+"</Font>");
out.print("<TH width=40>"+"<Font size=1>"+"总价"+"</Font>");
out.print("</TR>");
while(rs.next())
{out.print("<TR>");
String id=rs.getString(1);
out.print("<TD >"+rs.getString(1)+"</TD>");
out.print("<TD >"+rs.getString(3)+"</TD>");
out.print("<TD >"+rs.getString(4)+"</TD>");
out.print("<TD >"+rs.getString(5)+"</TD>");
out.print("<TD >"+rs.getString(6)+"</TD>");
out.print("<TD >"+rs.getString(7)+"</TD>");
out.print("<TD >"+rs.getString(8)+"</TD>");
out.print("</TR>");
}
out.print("</Table>");
con.close();
}
catch(SQLException e){}
%>
</Font>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -