insertimagesqlserver.java

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

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;


public class insertImageSqlserver {
	public static void main(String []agrs){
		Connection conn = null;
		try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=Moftec;","sa","123456");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		FileInputStream fis = null;
		File file = new File("D:/My Documents/DSC00116.jpg");
		try {
			fis = new FileInputStream(file);
		} catch (FileNotFoundException e) {
			e.printStackTrace();
		}
		PreparedStatement ps = null;
		try {
			ps = conn.prepareStatement("insert into gs_img(lei,year,img) values (?,?,?)");
			/******************************/
			ps.setString(1,"ivan"); 
			ps.setInt(2,4); 
			ps.setBinaryStream(3,fis,(int)file.length()); 
			ps.executeUpdate(); 
			ps.close(); 
			/******************************/
		} catch (SQLException e) {
			e.printStackTrace();
		}
		try{ 
			fis.close(); 
			System.out.println("写进去了！"); 
		}catch(IOException e){ 
			System.out.println("fis cann't cloase!"); 
		} 
	}
}