displayitemstable.jsp

来自「BEA WebLogic Server 8.1大全 = BEA webLogic」· JSP 代码 · 共 72 行

JSP
72 行
字号 
<%@ page import="javax.naming.*,java.sql.*,javax.sql.*" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
	<title>XYZ Confectionaries-Display Items</title>
	<b><u>XYZ Confectionaries - Display Items</u></b>
</head>

<body>

<br><br><br>
<% 
	boolean ctxInitialized = false;
	boolean connInitialized = false;
	boolean stmtInitialized = false;
	boolean rsInitialized = false;

	Context ctx = null;
	DataSource ds = null ;
	Connection aConnection = null;
	Statement stmt = null;
	ResultSet rs = null;
	try
	{
		ctx = new InitialContext(); ctxInitialized = true ;
		ds = (DataSource) ctx.lookup("jdbc/XYZConfDataSource");
		aConnection = ds.getConnection(); connInitialized = true;
		stmt = aConnection.createStatement(); stmtInitialized = true;
		rs = stmt.executeQuery( " SELECT * FROM XYZCONF.ITEM "); rsInitialized = true;
%>
<table frame="box" rules="all">
<caption align="bottom">Items in the XYZ Confectionaries ITEM table</caption>
<tr> <th>ID</th><th>Description</th><th>Stock</th><th>Price</th> </tr>
<%
		while (rs.next()) {
%>
<tr><td><%=rs.getString(1)%></td><td><%=rs.getString(2)%></td><td><%=rs.getDouble(3)%></td><td><%=rs.getDouble(4)%></td></tr>
<%
		}
%>
</table>
<%
	}
	catch (NamingException ne)
	{
		ne.printStackTrace();
%>
Naming Exception occurred. <%=ne.getMessage()%>
<%
	}
	catch (SQLException sqle)
	{
		sqle.printStackTrace();
%>
SQL Exception occurred. <%=sqle.getMessage()%>
<%
	}
	finally
	{
		if (rsInitialized) rs.close();
		if (stmtInitialized) stmt.close();
		if (connInitialized) aConnection.close();
		if (ctxInitialized) ctx.close();
	}
%>


</body>
</html>

displayitemstable.jsp - 源码说明

本页面展示了「BEA WebLogic Server 8.1大全 = BEA webLogic server 8.1 unleashed (美) Mark Artiges等著 袁毅 ... [等] 译 eng 」中的 displayitemstable.jsp 源码文件，采用 JSP 编程语言编写，共 72 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与BEA相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

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