<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*;"%>
<html>
<head>
<title>jsp操作Oracle数据库示例</title>
</head>
<body>
2007.11.2日--石刚
<table width="300" border="1" cellpadding="0" cellspacing="0"
bordercolordark="#0099CC" bordercolorlight="#DEF3FA">
<th>
编号
</th>
<th>
用户名
</th>
<th>
性别
</th>
<th>
年龄
</th>
<th>
积分
</th>
<%
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url = "jdbc:oracle:thin:@127.0.0.1:1521:orl";
String user = "scott";
String password = "tiger";
int i = 0;
Connection conn = DriverManager.getConnection(url, user, password);
Statement stmt = conn
.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sql = "select * from test";
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
%>
<%
if (i % 2 == 0) {
out.println("<tr>");
out.println("<td width='20%' bgcolor='#DEF3FA'>"
+ rs.getString("pid") + "</td>");
out.println("<td width='20%' bgcolor='#DEF3FA'>"
+ rs.getString("name") + "</td>");
out.println("<td width='20%' bgcolor='#DEF3FA'>"
+ rs.getString("sex") + "</td>");
out.println("<td width='20%' bgcolor='#DEF3FA'>"
+ rs.getString("age") + "</td>");
out.println("<td width='20%' bgcolor='#DEF3FA'>"
+ rs.getString("lev") + "</td>");
out.println("</tr>");
i++;
} else {
out.println("<tr>");
out.println("<td width='20%'>" + rs.getString("pid")
+ "</td>");
out.println("<td width='20%'>" + rs.getString("name")
+ "</td>");
out.println("<td width='20%'>" + rs.getString("sex")
+ "</td>");
out.println("<td width='20%'>" + rs.getString("age")
+ "</td>");
out.println("<td width='20%'>" + rs.getString("lev")
+ "</td>");
out.println("</tr>");
i++;
}
%>
<%
}
%>
<%
rs.close();
stmt.close();
conn.close();
%>
</table>
</body>
</html>
| 诚征版主 | 版主堂 | 意见建议 | 大史记 | 论坛地图