java实现按图存储,使用Java实现在SQLserver中实现图片的存储

使用Java实现在SQLserver中实现图片的存储

Connection conn = null; try{ DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver()); conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://IP:1433;DataBaseName=Moftec","sa","mymm"); } catch(Exception e ) { //捕捉异常并抛出IOException out.println("Can not connec to the database! The exception is " + e.toString()); } FileInputStream fis=null; File file = new File("E:/java/chart.jpg"); try{ fis = new FileInputStream(file); }catch(FileNotFoundException e){ out.println("Not find file!"); } PreparedStatement ps = conn.prepareStatement("Insert into gs_img (lei,years,img) values (?,?,?)"); ps.setString(1,"ivan"); ps.setInt(2,4); ps.setBinaryStream(3,fis,(int)file.length()); ps.executeUpdate(); ps.close(); try{ fis.close(); out.println("写进去了！"); }catch(IOException e){ out.println("fis cann't cloase!"); }