求教:使用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!"); 
}
上面那段红色代码是什么意思?不太明白,望各位能够赐教,谢谢!

 

 

阅读更多

没有更多推荐了,返回首页