用javabean来实现MySQL的分页显示

用javabean来实现MySQL的分页显示,标签：sql数据库教程,access数据库教程,http://www.xxk123.com
      {
          System.out.println("Class not found exception occur. Message is:");
          System.out.println(e.getMessage());
      }

      // establish connection to the database throught driver
      try
      {       
          con = DriverManager.getConnection(ConnStr);    
      }
      // display sql error message
      catch (SQLException e)
      {
          System.out.print("SQL Exception occur. Message is:");
          System.out.print(e.getMessage());     
      }    
  }   
   
    
  // perform a query with records returned
  public ResultSet executeQuery(String sql)  throws SQLException
  {     
      
      ResultSet rs = null;        
      try
      {
          stmt = con.createStatement();
          rs = stmt.executeQuery(sql);    
          while(rs.next())
              this.rows ++;         
          rs = stmt.executeQuery(sql);
      }
      catch (SQLException e)
      {
          System.out.print("Query:"+e.getMessage());
      }    
      
      this.rs = rs;
      return rs;    
  }

  // perform a query without records returned
  public boolean executeUpdate(String sql)  
  {     
      try
      {
          stmt = con.createStatement();
          stmt.executeUpdate(sql);                            
          return true;    

上一页  [1] [2] [3] [4] [5]  下一页