www.pudn.com > shop.rar > Asd.java

package com.soft136.shop.DAO; 
 
import java.sql.Connection; 
import java.sql.DriverManager; 
import java.sql.PreparedStatement; 
import java.sql.ResultSet; 
import java.sql.SQLException; 
import com.sun.rowset.CachedRowSetImpl; 
import javax.sql.rowset.CachedRowSet; 
import oracle.jdbc.rowset.OracleCachedRowSet; 
 
public class Asd { 
 
	/** 
	 * @param args 
	 */ 
 
		public CachedRowSet getGoodsMessage() throws SQLException, ClassNotFoundException { 
			Connection conn = null; 
			PreparedStatement ps = null; 
			ResultSet rs = null; 
			try { 
				Class.forName("oracle.jdbc.driver.OracleDriver"); 
				conn = DriverManager.getConnection( 
						"jdbc:oracle:thin:@192.168.1.250:1521:coach", "shop", "shop"); 
				ps = conn.prepareStatement("SELECT GOODS_ID,GOODS_NAME,TYPE_ID,GOODS_PRICE,GOODS_DICOUNT,GOODS_DESC,SUPPLIER,QTY,ISPREFERRED,PIC_URL FROM GOODS"); 
				rs = ps.executeQuery(); 
				CachedRowSet crs = new CachedRowSetImpl(); 
				crs.populate(rs); 
				return crs; 
			} finally { 
				if (ps != null) { 
					ps.close(); 
				} 
				if (conn != null) { 
					conn.close(); 
				} 
			} 
			} 
 
	public static void main(String[] args) { 
		// TODO Auto-generated method stub 
      try{      
    	  CachedRowSet crs=new Asd().getGoodsMessage(); 
      }catch(Exception e){ 
    	  e.printStackTrace(); 
      } 
	} 
 
}