try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(Exception e){
System.out.println("Connection error:"+e);
}

解决方案 »

  1.   

    package com.itfjq;
    import java.sql.*;
    public class page{
    String[] arr;              
    int columncount;           
    int page;                  
    int pagecount;             
    String link;               
    Connection conn=null;
    public page(){}
    public page(String sql,int pagesize){
    try{
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    conn=DriverManager.getConnection("jdbc:odbc:aaa","","");
    Statement st=conn.createStatement();
    ResultSet rs=st.executeQuery(sql);
    ResultSetMetaData rsmd = rs.getMetaData(); 
    columncount=rsmd.getColumnCount();
    int current_record=page*pagesize+1;
    rs.absolute(current_record);
    while(rs.next()){
    for(int i=1;i<=columncount;i++){
    Object f_object=rs.getObject(i);
    System.out.print(f_object.toString()+"<br>");
    }
    }
    }catch(SQLException sqle){
    sqle.getMessage();
    }finally{
    try{
    if(conn!=null){
    conn.close();
    }
    }catch(Exception e){}
    }
    }
    }