JSP 网上在线拍照源码

package com.test; import java.io.File; import java.io.FileInputStream; import java.io.FileOutputStream; import java.io.IOException; import java.io.InputStream; import java.io.OutputStream; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import oracle.sql.BLOB; public class photoDAO { public void savePic(int length, String bitmap_data) throws Exception{ byte[] bytes = new byte[length]; bytes = new sun.misc.BASE64Decoder().decodeBuffer(bitmap_data); writeToFile(bytes); insert(bytes); } private void writeToFile(byte[] buffer) throws IOException { File myFile = new File("C://1.jpg"); FileOutputStream fos = new FileOutputStream(myFile); fos.write(buffer); } public void insert(byte[] buffer)throws Exception { int id=1; String sql; Connection conn=getConnection(); conn.setAutoCommit(false); sql="delete from a where iid=?"; PreparedStatement ps=conn.prepareStatement(sql); ps.setInt(1, id); ps.execute(); conn.commit(); sql="insert into a(iid,photo) values(?,empty_blob())"; PreparedStatement ps1=conn.prepareStatement(sql); ps1.setInt(1, id); ps1.executeUpdate(); sql="select * from a where iid=? for update"; ps1.setInt(1, id); ResultSet rs=ps1.executeQuery(sql); if(rs.next()) { BLOB blob=(BLOB) rs.getBlob("photo"); blob.putBytes(1,buffer); ps.close(); ps1.close(); conn.commit(); } try { conn.close(); } catch(Exception e) { e.printStackTrace(); } } public static Connection getConnection()throws Exception { //DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); //使用OCI8连接到数据库 //Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:dragon","dragon","123456"); //conn.setAutoCommit(true); //return conn; DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); String url="jdbc:oracle:thin:@localhost:1521:dragon"; String user="dragon"; String password="123456"; Connection conn= DriverManager.getConnection(url,user,password); return conn; } }