2 |
|
|
3 |
import java.io.File; |
import java.io.File; |
4 |
import java.io.FileReader; |
import java.io.FileReader; |
|
import java.io.IOException; |
|
|
import java.sql.Connection; |
|
|
import java.sql.DriverManager; |
|
|
import java.sql.SQLException; |
|
5 |
import java.util.ArrayList; |
import java.util.ArrayList; |
6 |
import java.util.List; |
import java.util.List; |
7 |
import java.util.Map; |
import java.util.Map; |
144 |
verbose = Boolean.parseBoolean( conf.getProperty("VERBOSE") ); |
verbose = Boolean.parseBoolean( conf.getProperty("VERBOSE") ); |
145 |
logger.info("Starting with VERBOSE:" + verbose); |
logger.info("Starting with VERBOSE:" + verbose); |
146 |
|
|
147 |
Connection conn = getConnection(); |
Database db = new Database(conf); |
|
Database db = new Database(conn); |
|
148 |
|
|
149 |
db.resetResultTable(); |
db.resetResultTable(); |
150 |
|
|
170 |
//Lookup lookup = new Lookup(7400, db); |
//Lookup lookup = new Lookup(7400, db); |
171 |
//lookup.doLookup(); |
//lookup.doLookup(); |
172 |
} |
} |
|
|
|
|
public static Connection getConnection() throws SQLException, IOException { |
|
|
|
|
|
String db_host = conf.getProperty("DB_HOST"); |
|
|
String db_user = conf.getProperty("DB_USER"); |
|
|
String db_pass = conf.getProperty("DB_PASS"); |
|
|
|
|
|
|
|
173 |
|
|
|
|
|
|
Connection conn = null; |
|
|
Properties connectionProps = new Properties(); |
|
|
connectionProps.put("user", db_user); |
|
|
connectionProps.put("password", db_pass); |
|
|
|
|
|
conn = DriverManager.getConnection( |
|
|
"jdbc:mysql://" + |
|
|
db_host + |
|
|
":3306/", |
|
|
connectionProps); |
|
|
logger.info("Connected to database"); |
|
|
return conn; |
|
|
} |
|
|
|
|
174 |
} |
} |