package jdbc_day3;
import java.io.File;
import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class SavePic {
static Connection conn = null;
static PreparedStatement Pstmt = null;
public static void main(String[] args) {
insertPic();
}
public static void insertPic(){
String driver = "oracle.jdbc.driver.OracleDriver";
String url = "java:oracle:thin:@localhost:1521:orcl";
String sql = "insert into stu_lu(id, name, photo) values (myseq.nextval,?,?)";
try {
Class.forName(driver);
conn = DriverManager.getConnection(url,"system","0000");
Pstmt = conn.prepareStatement(sql);
File f = new File("mykfc.jpg");
FileInputStream fis = new FileInputStream(f);
Pstmt.setString(1, "peter");
Pstmt.setBinaryStream(2, fis, (int)f.length());
int n = Pstmt.executeUpdate();
System.out.println(n+"条记录被更新");
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}