JSP往MYSQL中插入，读写图片

package com.njue.image; import java.sql.*; import java.util.ArrayList; import java.io.*; import java.nio.*; public class UploadImage { String userName="root"; String password="123456"; Connection conn=null; Statement stmt=null; String url="jdbc:mysql://localhost:3306/mysql"; public boolean storeImage(String path,String sql) { try { File file = new File(path); //打开文件 FileInputStream fin = new FileInputStream(file); //建一个缓冲保存数据 ByteBuffer nbf = ByteBuffer.allocate((int) file.length()); byte[] array = new byte[1024]; int offset = 0, length = 0; //读存数据 while ((length = fin.read(array)) > 0) { if (length != 1024) nbf.put(array, 0, length); else nbf.put(array); offset += length; } //关闭文件 fin.close(); //新建一个数组保存要写的内容 byte[] content = nbf.array(); //保存数据 return setImage(sql, content); } catch (FileNotFoundException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } //如果发生文件读写错误都会返回false return false; } private boolean setImage(String sqlstr, byte[] in) { boolean flag = false; if (sqlstr == null) sqlstr = "select * from image"; try { Class.forName("com.mysql.jdbc.Driver"); conn=DriverManager.getConnection(url,userName,password); stmt = conn.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); ResultSet rs = stmt.executeQuery(sqlstr); if (rs.next()) { rs.updateBytes(2, in); //2表示更新第二个字段，机image这个字段 rs.updateRow(); } else { rs.moveToInsertRow(); rs.updateBytes(2, in); rs.insertRow(); } rs.close(); flag = true; } catch (Exception e) { e.printStackTrace(); } return flag; } }