当前页面: 开发资料首页 → Java 专题 → 使用JdbcRowSet和CachedRowSet的例子

使用JdbcRowSet和CachedRowSet的例子

摘要: 使用JdbcRowSet和CachedRowSet的例子

</td> </tr> <tr> <td width="528" height="35" valign="top" class="ArticleTeitle">

//Access数据库

import java.sql.*;

import javax.sql.rowset.*;            

import com.sun.rowset.*;

public class JDBCRowSetExample{

  public static void main(String[] argv){

    String url      = "jdbc:odbc:zz3zcwb";

    String login    = "";  

    String password = "";  

       

    try {

      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();

 

     JdbcRowSet rowSet =  new  JdbcRowSetImpl();

   

  //set url,login and password;

  rowSet.setUrl( url );

  rowSet.setUsername(login );

  rowSet.setPassword(password );

       rowSet.setCommand("select * from Article");

        rowSet.execute();

        while(rowSet.next()){

             String id=rowSet.getString("Article_id");

             String name=rowSet.getString("Article_name");

           System.out.println("id="+id+"  name="+name);

        }

      rowSet.close();

    } catch(Exception e) {

      e.printStackTrace();

    }

  }

}

//mysql数据库

import java.sql.*;

import javax.sql.rowset.*;            

import com.sun.rowset.*;

public class JDBCCachedRowSetExample{

  public static void main(String[] argv){

    String url= "jdbc:mysql://127.0.0.1:3306/soft?user=root&password=";

    String login    = "";  

    String password = "";  

       

    try {

      Class.forName("com.mysql.jdbc.Driver").newInstance();

      CachedRowSet crs=new CachedRowSetImpl();

   

  //set url,login and password;

  crs.setUrl( url );

  crs.setUsername(login );

  crs.setPassword(password );

       crs.setCommand("select * from soft");

        crs.setPageSize(5);

        crs.execute();

        while(crs.nextPage()){

            System.out.println("----------------------");

            while(crs.next()) {

            System.out.println(crs.getInt("soft_id")+"\t\t"+crs.getString("soft_name"));

           }

        }

      crs.close();

    } catch(Exception e) {

      e.printStackTrace();

    }

  }

}

function TempSave(ElementID) { CommentsPersistDiv.setAttribute("CommentContent",document.getElementById(ElementID).value); CommentsPersistDiv.save("CommentXMLStore"); } function Restore(ElementID) { CommentsPersistDiv.load("CommentXMLStore"); document.getElementById(ElementID).value=CommentsPersistDiv.getAttribute("CommentContent"); } </td> <td width="173" valign="top" class="ArticleTeitle">
</td> </tr> <tr> <td height="25" colspan="2" valign="top" class="ArticleTeitle">

↑返回目录
前一篇: 将数据库操作封装到Javabean
后一篇: 堵塞连接泄漏