JAVA sql Àà

  1. DriverManager
  2. Connection
  3. Statement
  4. ResultSet
  5. SQLException

ʾÀý£º

<%
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>