当前页面: 开发资料首页 → Java 专题 → 使用JdbcRowSet和CachedRowSet的例子
摘要: 使用JdbcRowSet和CachedRowSet的例子
//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(); } } }
↑返回目录
前一篇: 将数据库操作封装到Javabean
后一篇: 堵塞连接泄漏