📄 queryemp.jsp
字号:
<%@ page import = "java.sql.*" %>
<html>
<head>
<title>从Oracle数据库查询信息</title>
</head>
<body>
<%!
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
String driver_type = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle:thin:@localhost:1521:ora9201";
String username = "scott";
String password = "tiger";
String queryString = "SELECT * FROM emp";
%>
<%
try {
Class.forName(driver_type);
Connection conn =
DriverManager.getConnection(url, username, password);
Statement stmt = conn.createStatement ();
ResultSet rset = stmt.executeQuery (queryString);
ResultSetMetaData md = rset.getMetaData();
int no_cols = md.getColumnCount();
String[] col_names = new String[no_cols];
for(int i = 0; i < no_cols; i++)
col_names[i] = md.getColumnLabel(i+1);
%>
<table border=1>
<tr>
<% for(int i = 0; i < no_cols; i++) { %>
<td bgcolor="#008080"><font color="#FFFFFF">
<%= col_names[i] %> </font></td>
<% } %>
</tr>
<% while (rset.next ()) { %>
<tr>
<% for(int i = 1; i <= no_cols; i++) { %>
<td><%= rset.getString(i) %> </td>
<% } %>
</tr>
<%
}
}
catch(Exception e){ }
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -