www.pudn.com > shop.rar > GoodDao.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 oracle.jdbc.rowset.OracleCachedRowSet; 
 
 
 
public class GoodDao { 
	public OracleCachedRowSet 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(); 
			OracleCachedRowSet crs = new OracleCachedRowSet(); 
			crs.populate(rs); 
			return crs; 
		} finally { 
			if (ps != null) { 
				ps.close(); 
			} 
			if (conn != null) { 
				conn.close(); 
			} 
		} 
 
	} 
	 
	public OracleCachedRowSet getResult(int goods_id) 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 WHERE GOODS_ID="+goods_id); 
			rs = ps.executeQuery(); 
			OracleCachedRowSet crs = new OracleCachedRowSet(); 
			crs.populate(rs); 
			return crs; 
		} finally { 
			if (ps != null) { 
				ps.close(); 
			} 
			if (conn != null) { 
				conn.close(); 
			} 
		} 
 
	} 
}