xml和图片添加数据库以及复制

数据库表格

向数据库里添加数据代码

  public static void main(String[] args) throws Exception{
        Connection connection = DbUtils.getConnection();
        PreparedStatement preparedStatement = connection.prepareStatement( "insert into test3(cont,phone) values (?,?)" );
        preparedStatement.setCharacterStream( 1,new FileReader( ".idea\\misc.xml" ) );
        preparedStatement.setBinaryStream( 2,new FileInputStream( "C:\\Users\\ckd\\Desktop\\1.jpg" ) );
        int res=preparedStatement.executeUpdate();
        preparedStatement.close();
        connection.close();
        System.out.println("ok");
    }

读取并复制

public static void main(String[] args) throws Exception {
        Connection connection = DbUtils.getConnection();
        PreparedStatement preparedStatement = connection.prepareStatement( "select * from test3 where id=?" );
        preparedStatement.setInt( 1, 2  );
        ResultSet resultSet = preparedStatement.executeQuery();
        if (resultSet.next()) {
            Reader reader = resultSet.getCharacterStream( "cont");
            InputStream is = resultSet.getBinaryStream( "phone" );
            FileWriter fileWriter = new FileWriter( "src\\acopy.xml" );
            char[] buff = new char[1024];
            int len = 0;
            while ((len = reader.read( buff )) != -1) {
                fileWriter.write( buff, 0, len );
                fileWriter.flush();
            }
            fileWriter.close();
            reader.close();
            FileOutputStream fos = new FileOutputStream( "src\\1.jpg" );
            byte[] buf2 = new byte[1024];
            int len2 = 0;
            while ((len2 =is.read( buf2 )) != -1) {
                fos.write( buf2, 0, len2 );
                fos.flush();
            }
            fos.close();
            is.close();
        }
        resultSet.close();
        preparedStatement.close();
        connection.close();
        System.out.println("ok");
    }
}