lab17.java

jdbc 源代码

package com.jdbclab;
import  com.sun.rowset.*;
import java.sql.*;
public class Lab17
{
	public static void main(String[] args){
	    if(args.length!=3){
		  System.out.println(
			  "Usage: java jdbclab.Test19 url username password");
		   System.exit(0);
		}
		CachedRowSetImpl crs =null;
		try{
		 Class.forName("oracle.jdbc.driver.OracleDriver");
		 Class.forName("com.mysql.jdbc.Driver");
		 crs = new CachedRowSetImpl();
		 crs.setUrl(args[0]);
	     crs.setUsername(args[1]);
	     crs.setPassword(args[2]);
	     crs.setCommand("select * from t_sd0709_test");
         crs.execute();
		 JdbcUtil.printRs(crs);
		 crs.beforeFirst();
		 System.out.println("----------   second---------");
		 JdbcUtil.printRs(crs);
		}catch(Exception e){
		  e.printStackTrace();
		}finally{
		  JdbcUtil.release(crs);
		}
	
	}
}