且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

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

更新时间:2022-10-04 15:17:47

使用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!"); 
}









本文转自 牛海彬 51CTO博客,原文链接:http://blog.51cto.com/newhappy/77314,如需转载请自行联系原作者