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

最新推荐文章于 2024-05-31 15:34:18 发布

cim39930

最新推荐文章于 2024-05-31 15:34:18 发布

阅读量266

点赞数

文章标签：数据库 java

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

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7558084/viewspace-1002830/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7558084/viewspace-1002830/