67,516
社区成员
发帖
与我相关
我的任务
分享
import java.io.InputStream;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class test {
public static void main(String[] args) {
create();
}
static void create(){
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
try{
conn = JDBCUtils.getConnection();
String sql = "insert into blob(data) values(?)";
ps = conn.prepareStatement(sql);
File file = new File("02.jpg");
InputStream in = new BufferedInputStream(new FileInputStream(file));
ps.setBinaryStream(1, in, file.length());
int i = ps.executeUpdate();
in.close();
System.out.println(i);
}catch(Exception e){
e.printStackTrace();
}finally{
JDBCUtils.free(rs, ps, conn);
}
}
}