📄 sea.jsp

📁 我们做的J2EE课程设计实验,使用JSF语言编写一个简易的订单系统,麻雀虽小五脏俱全,适合初学者学习J2EE时参考,代码简炼精深,具有一定的参考价值.

💻 JSP

字号:

<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.io.*"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'sea.jsp' starting page</title>
    
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->

  </head>
  
  <body>
  <jsp:useBean id="handle" class="ch6.database" scope="request">
  <jsp:setProperty name="handle" property="Order"/>
  </jsp:useBean>
 <table border=1>
<tr><td>订单号</td><td>购买人</td><td>总价</td></tr>
<%
try
{
ResultSet rst=handle.search_order();
while(rst.next())
{
out.println("<tr>");
out.println("<td>"+rst.getString("Order")+"</td>");
out.println("<td>"+rst.getString("Buyer")+"</td>");
out.println("<td>"+rst.getInt("Sum")+"</td>");
out.println("</tr>");
}
rst.close();
}
catch(Exception e)
{
}
%>
</table>
<table border=1>
<tr><td>订单号</td><td>物料号</td><td>物料</td><td>数量</td><td>单价</td></tr>
<%
try
{
ResultSet rst=handle.search_orderitem();
while(rst.next())
{
out.println("<tr>");
out.println("<td>"+rst.getString("Order")+"</td>");
out.println("<td>"+rst.getString("Itemnum")+"</td>");
out.println("<td>"+rst.getString("Item")+"</td>");
out.println("<td>"+rst.getInt("Num")+"</td>");
out.println("<td>"+rst.getInt("Price")+"</td>");
out.println("</tr>");
}
rst.close();
}
catch(Exception e)
{
}
%>
</table>
    <br>
  </body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -