@Test
public void run() throws ClassNotFoundException, SQLException,
FileNotFoundException {
try {
Connection conn = jdbcUtils. getConnection();
PreparedStatement pst = conn
.prepareStatement( "insert into myblob values(null,?)");
File file = new File( "E:\\Java\\学习\\day17-jdbc\\视频\\1.课程介绍.avi" );
FileInputStream fs = new FileInputStream(file);
pst.setBinaryStream(1, fs, ( int) file.length());
int row = pst.executeUpdate();
if (row != 0) {
System. out.println( "插入成功");
}
} catch (Exception e) {
e.printStackTrace();
}
}
@Test
public void save() throws ClassNotFoundException, SQLException,
FileNotFoundException {
try {
Connection conn = jdbcUtils.getConnection();
PreparedStatement pst = conn
.prepareStatement("insert into mytext values(null,?)");
File file = new File("E:\\Java\\Workspaces\\DAO\\a.txt");
FileReader fr = new FileReader(file);
pst.setCharacterStream(1, fr, (int) file.length());
int row = pst.executeUpdate();
if (row != 0) {
System.out.println("插入成功");
}
} catch (Exception e) {
e.printStackTrace();
}
}
