向mysql数据库中插入大二进制文件和大文本

@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();
}

}

转载于:https://www.cnblogs.com/haofaner/p/5652755.html