JDBCConnectorTest.java

package test.kb.howtokb.jdbc;

import java.io.IOException;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import kb.howtokb.clustering.sim.CategorySimilarity;
import kb.howtokb.tools.InformationExtraction;
import kb.howtokb.utils.SQLiteJDBCConnector;

public class JDBCConnectorTest {
	public static void main(String[] args) throws ClassNotFoundException, SQLException, IOException {
		List<Integer> ids = new ArrayList<>();
		ids.add(2); ids.add(3);
		System.out.println(InformationExtraction.getListofActivitySurfaceFromDb(ids));
		
		ResultSet rs = SQLiteJDBCConnector.q("select json from categoryjson where id=3;");
		if (rs.next()){
			System.out.println(rs.getString("json"));
		}
		CategorySimilarity s = new CategorySimilarity();
		System.out.println(s.sim(3, 5));
	}
}