获取数据源
private boolean isdebug=false;
Dao biDao = isdebug ? getBiDao() : BIDataSource.getBiDataSource("eleme_all", task.getProject_code(), task.getDown_type());
debug主代码
public static NutDao getBiDao() {
String url="jdbc:sqlserver://ip:端口;DatabaseName=表名";
String username="用户名";
String password="密码";
DruidDataSource dataSource = new DruidDataSource();
dataSource.setDriverClassName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
dataSource.setUrl(url);
dataSource.setUsername(username);
dataSource.setPassword(password);
dataSource.setTestOnBorrow(false);
dataSource.setTestOnReturn(false);
dataSource.setTestWhileIdle(true);
dataSource.setValidationQuery("SELECT 1 ");
return new NutDao(dataSource);
}
public static NutDao getTaskDao() {
String url="jdbc:mysql://ip:端口/库名?useUnicode=true&characterEncoding=UTF-8";
String username="用户名";
String password="密码";
DruidDataSource dataSource = new DruidDataSource();
dataSource.setDriverClassName("com.mysql.jdbc.Driver");
dataSource.setUrl(url);
dataSource.setUsername(username);
dataSource.setPassword(password);
dataSource.setTestOnBorrow(false);
dataSource.setTestOnReturn(false);
dataSource.setTestWhileIdle(true);
return new NutDao(dataSource);
}
public static void main(String args[])throws Exception{
NutDao taskDao =getTaskDao();
Record record = taskDao.fetch("eleme_product_task_daily", Cnd.where("id", "=", 4519));
ElemeProductThread ept= new ElemeProductThread(record,null);
ept.isdebug=true;
ept.mysqlDao=taskDao;
ept.doRun();
}