<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%><%
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@192.168.210.101:1521:redant";
String user="scott";
String password="tiger";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); %>
<html><body>
<form name="form1" method="post" action="OracleTest.jsp">
<table border="1" width="100%">
<th align='center'>EMPID</th><th align='center'>ENAME</th><th align='center'>JOB</th><th align='center'>MGR</th><th align='center'>HIREDATE</th><th align='center'>SAL</th><th align='center'>COMM</th><th align='center'>DEPTNO</th>
<%
String sql="select * from emp";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {
%>
<tr>
<td align="center"><%=rs.getString(1)%></td>
<td align="center"><%=rs.getString(2)%></td>
<td align="center"><%=rs.getString(3)%></td>
<td align="center"><%=rs.getString(4)%></td>
<td align="center"><%=rs.getString(5)%></td>
<td align="center"><%=rs.getString(6)%></td>
<td align="center"><%=rs.getString(7)%></td>
<td align="center"><%=rs.getString(8)%></td>
</tr>
<%}%>
</table>
</form>
<%
rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
这是我的代码:
<%@ page import="java.sql.*"%><%
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@192.168.210.101:1521:redant";
String user="scott";
String password="tiger";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); %>
<html><body>
<form name="form1" method="post" action="OracleTest.jsp">
<table border="1" width="100%">
<th align='center'>EMPID</th><th align='center'>ENAME</th><th align='center'>JOB</th><th align='center'>MGR</th><th align='center'>HIREDATE</th><th align='center'>SAL</th><th align='center'>COMM</th><th align='center'>DEPTNO</th>
<%
String sql="select * from emp";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {
%>
<tr>
<td align="center"><%=rs.getString(1)%></td>
<td align="center"><%=rs.getString(2)%></td>
<td align="center"><%=rs.getString(3)%></td>
<td align="center"><%=rs.getString(4)%></td>
<td align="center"><%=rs.getString(5)%></td>
<td align="center"><%=rs.getString(6)%></td>
<td align="center"><%=rs.getString(7)%></td>
<td align="center"><%=rs.getString(8)%></td>
</tr>
<%}%>
</table>
</form>
<%
rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
这是我的代码:
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货