Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try{
- Class.forName("oracle.jdbc.driver.OracleDriver");
- Connection con=DriverManager.getConnection(
- "jdbc:oracle:thin:@localhost:1521:xe","ZTRENDS","ZTRENDS");
- PreparedStatement ps=con.prepareStatement("UPDATE ITEMSn" +
- "SET name = ?, photo= ?" +
- "WHERE item_ID = ?;");
- ps.setString(1,"sonoo");
- FileInputStream fin=new FileInputStream("C:\picture000.jpg");
- ps.setBinaryStream(2,fin,fin.available());
- ps.setInt(3,1);
- int i=ps.executeUpdate();
- System.out.println(i+" records affected");
- System.out.println(ps);
- con.close();
- }catch (Exception e) {e.printStackTrace();}
Add Comment
Please, Sign In to add comment