jsp+access的小例子

<%@ page import="java.sql.*" %>

<%
 String url = "jdbc:odbc:test";
 Connection con;
 Statement stmt;
 String query = "select * from t1";
 try {
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 }
 catch(java.lang.ClassNotFoundException e) {
  System.err.print("ClassNotFoundException: ");
  //加载jdbc-odbc桥错误
  System.err.println(e.getMessage());
 //其他错误
 }
 try{
  con = DriverManager.getConnection(url, "admin", "");//数据库连接
  stmt = con.createStatement();
  ResultSet rs = stmt.executeQuery(query);
  while(rs.next()){
   out.println(rs.getString(1));
   out.println(rs.getString(2));
   out.println(rs.getString(3));
   out.println(rs.getString(4));
   out.println("<br>");
  }
  stmt.close();
  con.close();
 }
 catch(Exception e){
 }
%>

gb2312和unicode的转换用的是 String InsertStr = new String(Insert.getBytes("ISO8859_1"),"gb2312");

test是我设置的odbc名字