如何在JSP页面显示Oracle数据库内容
1个回答
展开全部
<span style="font-size:12px;">
<span style="font-size:14px;">
<%@ page language="java" import="java.sql.*,java.io.*,java.util.*"%>
<%@ page contentType="text/html;charset=utf-8"%>
<%@ page import="com.oracle.enjoyshop.base.ConnectionFactory" %> /*引用数据库连接类*/
<%@ page import="com.oracle.enjoyshop.util.JDBCUtil" %> /*引用资源关闭类*/
<html>
<head>
<title>从数据库中的某个表拿到该表所有的数据</title>
<style type="text/css">
table {
border: 2px #CCCCCC solid;
width: 360px;
}
td,th {
height: 30px;
border: #CCCCCC 1px solid;
}
</style>
</head>
<body>
<%
Connection conn = null;
Statement stmt = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
conn = ConnectionFactory.getConnection();
String findSQL = "select u_id,u_name,u_pwd,u_tel,u_email,u_birthday,u_money from zzl_user ";
pstmt = conn.prepareStatement(findSQL);
rs=pstmt.executeQuery();
%>
<br>
<br>
<table align="center">
<tr>
<th>
<%
out.print("ID");
%>
</th>
<th>
<%
out.print("NAME");
%>
</th>
<th>
<%
out.print("PWD");
%>
</th>
<th>
<%
out.print("TEL");
%>
</th>
<th>
<%
out.print("EMAIL");
%>
</th>
<th>
<%
out.print("BRITH");
%>
</th>
<th>
<%
out.print("MENOY");
%>
</th>
</tr>
<%
while (rs.next()) {
%>
<tr>
<td>
<%
out.print(rs.getLong(1));
%>
</td>
<td>
<%
out.print(rs.getString(2));
%>
</td>
<td>
<%
out.print(rs.getString(3));
%>
</td>
<td>
<%
out.print(rs.getString(4));
%>
</td>
<td>
<%
out.print(rs.getString(5));
%>
</td>
<td>
<%
out.print(rs.getDate(6));
%>
</td>
<td>
<%
out.print(rs.getDouble(7));
%>
</td>
</tr>
<%
}
%>
</table>
<%
JDBCUtil.close(conn, pstmt, stmt, rs);
%>
</body>
</html>
<span style="font-size:14px;">
<%@ page language="java" import="java.sql.*,java.io.*,java.util.*"%>
<%@ page contentType="text/html;charset=utf-8"%>
<%@ page import="com.oracle.enjoyshop.base.ConnectionFactory" %> /*引用数据库连接类*/
<%@ page import="com.oracle.enjoyshop.util.JDBCUtil" %> /*引用资源关闭类*/
<html>
<head>
<title>从数据库中的某个表拿到该表所有的数据</title>
<style type="text/css">
table {
border: 2px #CCCCCC solid;
width: 360px;
}
td,th {
height: 30px;
border: #CCCCCC 1px solid;
}
</style>
</head>
<body>
<%
Connection conn = null;
Statement stmt = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
conn = ConnectionFactory.getConnection();
String findSQL = "select u_id,u_name,u_pwd,u_tel,u_email,u_birthday,u_money from zzl_user ";
pstmt = conn.prepareStatement(findSQL);
rs=pstmt.executeQuery();
%>
<br>
<br>
<table align="center">
<tr>
<th>
<%
out.print("ID");
%>
</th>
<th>
<%
out.print("NAME");
%>
</th>
<th>
<%
out.print("PWD");
%>
</th>
<th>
<%
out.print("TEL");
%>
</th>
<th>
<%
out.print("EMAIL");
%>
</th>
<th>
<%
out.print("BRITH");
%>
</th>
<th>
<%
out.print("MENOY");
%>
</th>
</tr>
<%
while (rs.next()) {
%>
<tr>
<td>
<%
out.print(rs.getLong(1));
%>
</td>
<td>
<%
out.print(rs.getString(2));
%>
</td>
<td>
<%
out.print(rs.getString(3));
%>
</td>
<td>
<%
out.print(rs.getString(4));
%>
</td>
<td>
<%
out.print(rs.getString(5));
%>
</td>
<td>
<%
out.print(rs.getDate(6));
%>
</td>
<td>
<%
out.print(rs.getDouble(7));
%>
</td>
</tr>
<%
}
%>
</table>
<%
JDBCUtil.close(conn, pstmt, stmt, rs);
%>
</body>
</html>
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
TableDI
2024-07-18 广告
在上海悉息信息科技有限公司，我们深知Excel在数据处理中的重要作用。在Excel中引用不同工作表（sheet）的数据是常见的操作，这有助于整合和分析跨多个工作表的信息。通过在工作表名称前加上感叹号“!”，您可以轻松地引用其他工作表中的数据...
点击进入详情页
本回答由TableDI提供
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
