package com.cat.multi.sql;

import com.cat.multi.net.NetPath;

import com.cat.multi.net.PathManager;

import java.util.Set;

/**

* Created by cat on 2018/1/28.

* java sqlite3

*/

public class Main {

public static void main(String[] args) throws InterruptedException {

DaoManager.createTable();

DaoManager.insert(NetPath.urlPath1, PathManager.generatePathFromUrlFinal(NetPath.urlPath1));

DaoManager.insert(NetPath.urlPath2, PathManager.generatePathFromUrlFinal(NetPath.urlPath2));

Set<UriBean> set = DaoManager.select();

for (UriBean bean : set) {

System.out.println(bean);

DaoManager.delete(bean.getUrl());

}

Thread.sleep(300);

System.err.println("--------###-------");

set = DaoManager.select();

for (UriBean bean : set) {

System.out.println(bean);

// DaoManager.delete(bean.getUrl());

}

DaoManager.dropTable();

Thread.sleep(600);

System.err.println("-XXX-------###-------");

set = DaoManager.select();

for (UriBean bean : set) {

System.out.println(bean);

// DaoManager.delete(bean.getUrl());

}

}

}