<% String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=c:\\www\\jspbook\\data\\guestbook.mdb"; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = java.sql.DriverManager.getConnection(url); Statement st = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); String sql = "select * from guestbook"; ResultSet rs = st.executeQuery(sql); while( rs.next() ) { out.print( rs.getString("content") ); } %> |
<%@ page contentType="text/html; charset=gb2312" language="java"
import="java.util.*, java.sql.*" %> <html> <head> <title>ORACLE Connection</title> </head> <body> <% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String url = "jdbc:odbc:Driver={microsoft odbc for oracle};server=otec;uid=pjms;pwd=pjms"; Connection cn = java.sql.DriverManager.getConnection(url); Statement st = cn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); String sql = "select * from dual"; ResultSet rs = st.executeQuery(sql); while( rs.next() ) { out.print( rs.getString(1) ); } rs.close(); st.close(); cn.close(); %> </body> </html> |