5个回答
展开全部
我来帮你解答吧。展示表article,假设表article有2个字段,id number和name varchar:<%@ page language="java" contentType="text/html; charset=GBK"
pageEncoding="GBK"%>
<%@ page import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" " http://www.w3.org/TR/html4/loose.dtd">
<%
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@127.0.0.1:1521:orcl", "username", "password""; //改成自己数据库内容Connection conn=DriverManager.getConnection(url); //建立数据库连接
Statement stmt=conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from article ");
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<title>disply table content</title>
</head>
<body><table border=1> <tr> <td>id</td> <td>name</td> </tr>
<%
while(rs.next()) {
%>
<tr>
<td><%=rs.getInt("id") %></td>
<td><%=rs.getString("name") %></td>
</tr><%}%>
</table>
</body><%stmt.close();
pstmt.close();
conn.close();%>
</html>
pageEncoding="GBK"%>
<%@ page import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" " http://www.w3.org/TR/html4/loose.dtd">
<%
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@127.0.0.1:1521:orcl", "username", "password""; //改成自己数据库内容Connection conn=DriverManager.getConnection(url); //建立数据库连接
Statement stmt=conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from article ");
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<title>disply table content</title>
</head>
<body><table border=1> <tr> <td>id</td> <td>name</td> </tr>
<%
while(rs.next()) {
%>
<tr>
<td><%=rs.getInt("id") %></td>
<td><%=rs.getString("name") %></td>
</tr><%}%>
</table>
</body><%stmt.close();
pstmt.close();
conn.close();%>
</html>
本回答由网友推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
展开全部
<%@ taglib prefix="s" uri="/struts-tags" %>
<s:iterator value="LI.list" status="vs">
<tr>
<td><s:property value="#vs.id"/></td>
<td><s:property value="vs.name"/></td>
<td><s:property value="vs.birthday"/></td>
<td><s:property value="vs.gender"/></td>
<td><s:property value="vs.career"/></td>
<td><s:property value="vs.address"/></td>
<td><s:property value="vs.mobile"/></td>
<td>
<a href="profile_findById.action?id=<s:property value="id"/>">明细</a>
<a href="profile_update.action?id=<s:property value="id"/>">修改</a>
</td>
</tr>
</s:iterator>
<s:iterator value="LI.list" status="vs">
<tr>
<td><s:property value="#vs.id"/></td>
<td><s:property value="vs.name"/></td>
<td><s:property value="vs.birthday"/></td>
<td><s:property value="vs.gender"/></td>
<td><s:property value="vs.career"/></td>
<td><s:property value="vs.address"/></td>
<td><s:property value="vs.mobile"/></td>
<td>
<a href="profile_findById.action?id=<s:property value="id"/>">明细</a>
<a href="profile_update.action?id=<s:property value="id"/>">修改</a>
</td>
</tr>
</s:iterator>
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
更多回答（3）
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
