//该格式会转码导致部分数据丢失
ftp.setFileType(FTP.ASCII_FILE_TYPE);  
//该格式不会丢失数据
ftp.setFileType(FTP.BINARY_FILE_TYPE);

/**
 * ftp上传下载工具类
 */
public class FtpUtil {
    /**
     * Description: 向FTP服务器上传文件
     *
     * @param host     FTP服务器hostname
     * @param port     FTP服务器端口
     * @param username FTP登录账号
     * @param password FTP登录密码
     * @param basePath FTP服务器基础目录
     * @param filePath FTP服务器文件存放路径。例如分日期存放：/2015/01/01。文件的路径为basePath+filePath
     * @param filename 上传到FTP服务器上的文件名
     * @param input    输入流
     * @return 成功返回true，否则返回false
     */
    public static boolean uploadFile(String host, int port, String username, String password, String basePath,
                                     String filePath, String filename, InputStream input) throws IOException {
        boolean result = false;
        FTPClient ftp = new FTPClient();
        try {
            int reply;
            ftp.connect(host, port);// 连接FTP服务器
            // 如果采用默认端口，可以使用ftp.connect(host)的方式直接连接FTP服务器
            ftp.login(username, password);// 登录
            reply = ftp.getReplyCode();
            if (!FTPReply.isPositiveCompletion(reply)) {
                ftp.disconnect();
                return result;
            }
            ftp.enterLocalPassiveMode();  //设置被动模式
            //切换到上传目录
            if (!ftp.changeWorkingDirectory(basePath + filePath)) {
                //如果目录不存在创建目录
                String[] dirs = filePath.split("/");
                String tempPath = basePath;
                for (String dir : dirs) {
                    if (null == dir || "".equals(dir)) continue;
                    tempPath += "/" + dir;
                    if (!ftp.changeWorkingDirectory(tempPath)) {
                        if (!ftp.makeDirectory(tempPath)) {
                            return result;
                        } else {
                            ftp.changeWorkingDirectory(tempPath);
                        }
                    }
                }
            }
            //设置上传文件的类型为二进制类型
            ftp.setFileType(FTP.BINARY_FILE_TYPE);

            //上传文件
            if (!ftp.storeFile(filename, input)) {
                return result;
            }
            input.close();
            ftp.logout();
            result = true;
        } catch (IOException e) {
           // e.printStackTrace();
           throw e;
        } finally {
            if (ftp.isConnected()) {
                try {
                    ftp.disconnect();
                } catch (IOException ioe) {
                }
            }
        }
        return result;
    }

    /**
     * Description: 从FTP服务器下载文件
     *
     * @param host       FTP服务器hostname
     * @param port       FTP服务器端口
     * @param username   FTP登录账号
     * @param password   FTP登录密码
     * @param remotePath FTP服务器上的相对路径
     * @param fileName   要下载的文件名
     * @param localPath  下载后保存到本地的路径
     * @return
     */
    public static boolean downloadFile(String host, int port, String username, String password, String remotePath,
                                       String fileName, String localPath) {
        boolean result = false;
        FTPClient ftp = new FTPClient();
        try {
            int reply;
            ftp.connect(host, port);
            // 如果采用默认端口，可以使用ftp.connect(host)的方式直接连接FTP服务器
            ftp.login(username, password);// 登录
            reply = ftp.getReplyCode();
            if (!FTPReply.isPositiveCompletion(reply)) {
                ftp.disconnect();
                return result;
            }
            ftp.enterLocalPassiveMode();  //设置被动模式
            ftp.changeWorkingDirectory(remotePath);// 转移到FTP服务器目录
            FTPFile[] fs = ftp.listFiles();
            for (FTPFile ff : fs) {
                if (ff.getName().equals(fileName)) {
                    File localFile = new File(localPath + "/" + ff.getName());
                    OutputStream is = new FileOutputStream(localFile);
                    ftp.retrieveFile(ff.getName(), is);
                    is.close();
                }
            }

            ftp.logout();
            result = true;
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            if (ftp.isConnected()) {
                try {
                    ftp.disconnect();
                } catch (IOException ioe) {
                }
            }
        }
        return result;
    }

    /**
     * 删除FTP上指定路径的文件
     *
     * @param host
     * @param port
     * @param username
     * @param password
     * @param ftpDirAndFileName
     * @return
     */
    public static boolean deleteFile(String host, int port, String username, String password, String ftpDirAndFileName) {
        FTPClient ftp = new FTPClient();
        try {
            int reply;
            ftp.connect(host, port);
            // 如果采用默认端口，可以使用ftp.connect(host)的方式直接连接FTP服务器
            ftp.login(username, password);// 登录
            reply = ftp.getReplyCode();
            if (!FTPReply.isPositiveCompletion(reply)) {
                ftp.disconnect();
                return false;
            }
            boolean hasDelete = ftp.deleteFile(ftpDirAndFileName);

            ftp.logout();
            return hasDelete;
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            if (ftp.isConnected()) {
                try {
                    ftp.disconnect();
                } catch (IOException ioe) {
                }
            }
        }

        return false;
    }
}

@Before
public void loadDb() {
    try {
        connection = DriverManager.getConnection("jdbc:sqlite:C:\\Users\\Administrator\\Desktop\\data.db");
        System.out.println("连接成功");
    } catch (SQLException e) {
    	e.printStackTrace();
    }
}

@After
public void after() {
    try {
        connection.close();
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

public Map queryMap(String sql) throws SQLException {
    HashMap row = null;
    System.out.print("执行：" + sql);
    ResultSet rs = connection.createStatement().executeQuery(sql);
    if (rs.next()) {
        ResultSetMetaData md = rs.getMetaData();
        int columns = md.getColumnCount();
        row = new HashMap(columns);
        for (int i = 1; i <= columns; ++i) {
            if (i > 1) System.out.print(",  ");
            row.put(md.getColumnName(i), rs.getObject(i));
            System.out.print(rs.getObject(i) + " " + md.getColumnName(i));
        }
    }
    rs.close();
    return row;
}

public List queryList(String sql) throws SQLException {
    System.out.print("执行：" + sql);
    ResultSet rs = connection.createStatement().executeQuery(sql);
    ResultSetMetaData md = rs.getMetaData();
    int columns = md.getColumnCount();
    ArrayList list = new ArrayList(50);
    while (rs.next()) {
        HashMap row = new HashMap(columns);
        for (int i = 1; i <= columns; ++i) {
            if (i > 1) System.out.print(",  ");
            row.put(md.getColumnName(i), rs.getObject(i));
            System.out.print(rs.getObject(i) + " " + md.getColumnName(i));
        }
        list.add(row);
    }
    rs.close();
    return list;
}

import java.sql.*;

public class SQLiteJDBC
{
  public static void main( String args[] )
  {
    Connection c = null;
    try {
      Class.forName("org.sqlite.JDBC");
      c = DriverManager.getConnection("jdbc:sqlite:test.db");
    } catch ( Exception e ) {
      System.err.println( e.getClass().getName() + ": " + e.getMessage() );
      System.exit(0);
    }
    System.out.println("Opened database successfully");
  }
}

FileDownloader.setupOnApplicationOnCreate(this)
    .connectionCreator(new FileDownloadUrlConnection
    .Creator(
        new FileDownloadUrlConnection.Configuration()
        .connectTimeout(15_000) // set connection timeout.
        .readTimeout(15_000) // set read timeout.
	)
).commit();

AlertDialog.Builder builder = new AlertDialog.Builder(context);
builder.setTitle("是否需要下载离线地图？");
builder.setMessage(f.getAbsolutePath() + " 没有找到离线地图文件");
builder.setCancelable(true);
final ProgressDialog dialog22 = new ProgressDialog(this);
dialog22.setTitle("正在下载离线地图");
dialog22.setCancelable(false);
builder.setPositiveButton("下载(文件>500M)", new DialogInterface.OnClickListener() {
    @Override
    public void onClick(final DialogInterface dialog, int which) {
        FileDownloader.getImpl().create(Config.KJMAPDOWNLOAD)
            .setAutoRetryTimes(100)
            .setPath(f.getAbsolutePath(),true)
            .setListener(new FileDownloadLargeFileListener() {
                @Override
                protected void pending(BaseDownloadTask task, long soFarBytes, long totalBytes) {
                    dialog22.show();
                }
                @Override
                protected void progress(BaseDownloadTask task, long soFarBytes, long totalBytes) {
                    dialog22.setMessage( "重试"+task.getRetryingTimes()+"次,下载速度：" + task.getSpeed() + "kb/s,百分比：" + soFarBytes / 1048576 + "/" + totalBytes / 1048576 + "M");
                }
                @Override
                protected void completed(BaseDownloadTask task) {
                    Toast.makeText(LineActivity.this, "下载成功，请重新打开该页面", Toast.LENGTH_LONG).show();
                    String oldFileUrl=task.getPath()+"/"+task.getFilename();
                    Log.i("oldFileUrl",oldFileUrl);
                    File oldName=new File(oldFileUrl);
                    File newName=new File(f.getAbsolutePath()+"/"+Config.KJMAPDOWNLOADFILENAME);
                    if (oldName.renameTo(newName)){
                        Log.i("LineActivity","重命名成功");
                    }else {
                        Log.e("LineActivity","重命名失败");
                    }
                    dialog22.dismiss();
                }
                @Override
                protected void paused(BaseDownloadTask task, long soFarBytes, long totalBytes) {
                }
                @Override
                protected void error(BaseDownloadTask task, Throwable e) {
                    Toast.makeText(LineActivity.this, "下载失败", Toast.LENGTH_LONG).show();
                    dialog22.dismiss();
                }
                @Override
                protected void warn(BaseDownloadTask task) {
                }
            }).start();
        dialog.dismiss();
    }
});
builder.setNegativeButton("取消", new DialogInterface.OnClickListener() {
    @Override
    public void onClick(DialogInterface dialog, int which) {
        dialog.dismiss();
    }
});
AlertDialog dialog = builder.create();
dialog.show();