Mega Code Archive

 

Categories / Java Tutorial / Database

 

Insert Picture

FileInputStream fis =  null;       PreparedStatement ps = null;       try {          File file = new File(photo);          fis = new FileInputStream(file);          ps = conn.prepareStatement("insert into pictable(id, name, pic)values(?,?,?)");          ps.setString(1, id);          ps.setString(2, name);          ps.setBinaryStream(3, fis,(int)file.length());          ps.executeUpdate();       }