<%@ Page contentType="text/html;charset=gb2312"%>
<%@ Page import="java.sql.*"%>
<html>
<body>
<%Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@10.187.118.158:1521:qing";
String user1="javagroup;
String password1="abc"
Connection conn=DriverManager.getConnection(url,user1,password1);
Statement stmt=conn.createStatement();
String sql="select * form test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){%>
nihao :<%out.print(rs.getString(1))%>
nihaiya:<%out.print(rs.getString(2))%>

<%}
out.print("数据库能用");%>

<%rs.close();
stmt.close();
conn.>
</htclose();
%>
</bodyml>