＋设为首页 ＋添加到收藏夹
如何将一张jpg的图insert到数据库中？
String trace="c:\\aa.jpg";
java.io.File file = new java.io.File(trace);
java.io.FileInputStream fis = new java.io.FileInputStream(file);
out.println(file.length());
//打开数据库
ResultSet result=null;
String mSql=null;
PreparedStatement prestmt=null;
DBstep.iDBManager2000 DbaObj=new DBstep.iDBManager2000();
DbaObj.OpenConnection();
//将文件写到数据库中
mSql="insert into marklist (MarkBody) values (?)";
prestmt =DbaObj.Conn.prepareStatement(mSql);
prestmt.setBinaryStream(1,fis,(int)file.length());
DbaObj.Conn.setAutoCommit(true) ;
prestmt.executeUpdate();
DbaObj.Conn.commit();
