java 存sql图片_使用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!");

}