hangy2k
发贴: 12
积分: 0
|
于 2003-07-17 10:38
database.jsp
<%@ page import="java.sql.Statement" %> <%@ page import="java.util.Properties" %> <%@ page import="java.sql.Driver" %> <%@ page import="java.sql.Connection" %> <%@ page import="java.sql.ResultSet" %> <html> <%@ page session="false"%> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <body bgcolor="white"> <% int i=0; String stmt = "SELECT name FROM person"; try{ Properties props = new Properties(); props.put("user", "scott"); props.put("password", "tiger"); props.put("server", "test"); Driver myDriver = (Driver)Class.forName("weblogic.jdbc.oci.Driver").newInstance(); Connection conn = myDriver.connect("jdbc:weblogic:oracle", props); Statement queryAuthors = conn.createStatement(); ResultSet results = queryAuthors.executeQuery(stmt);
while (results.next()){ String name = results.getString(1); out.println("<BR>" + (i+1) + ") " + name +"<BR>"); i++; } }catch(Exception e){ out.println("Exception occur !!! Exception : " + e); } %> </body> </html>
here a simple jsp directly connect to the database using bea weblogic and oracle.
|