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

package com.soft136.shop.DAO; 
 
import java.sql.Connection; 
import java.sql.DriverManager; 
import java.sql.PreparedStatement; 
 
import java.sql.SQLException; 
 
public class UploadDao { 
	public void uploadPicture(String dir, String picname) 
			throws SQLException, ClassNotFoundException { 
		Connection conn = null; 
		PreparedStatement ps = 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("insert into picture(picid,picname,picurl) values(picid_seq.nextval,?,?)"); 
			ps.setString(1, picname); 
			ps.setString(2, dir+"\\"+picname); 
			ps.executeUpdate(); 
 
		} finally { 
			if (ps != null) { 
				ps.close(); 
			} 
			if (conn != null) { 
				conn.close(); 
			} 
		} 
 
	} 
}