beantest.jsp

来自「里面所含源码是本人平时做程序的一些实例」· JSP 代码 · 共 62 行

JSP
62
字号
<%@ page language="java" import="java.sql.*" pageEncoding="gbk"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
	<head>
		<title>javaBean</title>
	</head>
	<body>

		<table width="500" border="1" align="center">
			<tr>
				<td>
					<h2>
						title
					</h2>
				</td>
				<td>
					<h2>
						type
					</h2>
				</td>
			</tr>
			<jsp:useBean id="bean" scope="application" class="demo.bean.Bean"></jsp:useBean>
			<jsp:setProperty name="bean" property="title" />
			<jsp:setProperty name="bean" property="note" />
			<%!ResultSet rs = null;
				Connection conn = null;
				Statement st = null;
				%>
			<%
				conn = bean.getConn();
				try{
				st = conn.createStatement();
				}
				catch(Exception e)
				{out.println(e.getMessage());}
				String strSql = "select * from test";
				rs = st.executeQuery(strSql);
				
				while (rs.next()) {
			%>
			<tr>
				<td>
					<%
						out.println(rs.getString("title"));
					%>
				</td>
				<td>
					<%
						out.println(rs.getString("note"));
					%>
				</td>
			</tr>
			<%
				}
				
			
			%>
		</table>

	</body>
</html>

⌨️ 快捷键说明

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