Question

在java中怎么使用prepareStatement向mysql数据库中插入值

Answer 1

String sql="insert into pic values(1,'pic1',?)";

PreparedStatement pstm=conn.prepareStatement(sql);
Blob blob=BLOB.getEmptyBLOB();
pstm.setBlob(1, blob);
pstm.executeUpdate();
pstm.close();

sql="select * from pic where pic_id=1 for update";
pstm=conn.prepareStatement(sql);
ResultSet rs=pstm.executeQuery();
if(rs.next()){
Blob b=rs.getBlob("pic_data");
OutputStream out=b.setBinaryStream(1);
InputStream in =new FileInputStream("j:/pic.jpg");

int k=-1;
while((k=in.read())!=-1){
out.write(k);

}
out.flush();
out.close();
in.close();
}
conn.close();
rs.close();
pstm.close();

Answer 2

留个QQ，把例子发给你。

追问

1625554389

追答

已发。