File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
package com.takensoft.taken_bi_manager;
import java.util.LinkedHashMap;
import java.util.List;
import com.takensoft.taken_bi_manager.common.connection.db.util.DBConnectionUtil;
import com.takensoft.taken_bi_manager.common.connection.db.util.DataTypeUtil;
import com.takensoft.taken_bi_manager.common.connection.db.vo.ConnectionDB;
import com.takensoft.taken_bi_manager.common.vo.CheckMessage;
import com.takensoft.taken_bi_manager.common.vo.SystemCode.DatabaseType;
import com.takensoft.taken_bi_manager.data.vo.ColumnData;
import com.takensoft.taken_bi_manager.data.vo.DataTable;
import com.takensoft.taken_bi_manager.data.vo.Dataset;
public class DBConnectTest {
public static void main(String[] args) throws Exception {
DBConnectionUtil dbc = new DBConnectionUtil();
ConnectionDB cdb = new ConnectionDB();
cdb.setDatabaseNm("crosswalks");
cdb.setDatabaseType(DatabaseType.POSTGRESQL);
cdb.setConectIp("210.180.118.83");
cdb.setConectPort("5432");
cdb.setConectNm("테스트 DB");
cdb.setUserId("takensoft");
cdb.setSchemaNm("crosswalk");
// cdb.setUserPassword("Ts2020kr!@#");
cdb.setUserPassword("tts64103165!@");
dbc.createDatabaseDAO(cdb);
CheckMessage checkMessage = dbc.dbConnectionCheck(cdb);
List<Dataset> datasets = dbc.getDBConnectionTableList(cdb);
for(Dataset temp : datasets) {
System.out.println(temp.getTableNm());
System.out.println("---------------------------------------------------");
DataTable dt = new DataTable(temp);
dbc.setDataTableByDBConnectionTable(cdb, dt);
for(List<Object> item : dt.getRowData()) {
for(Object data : item) {
System.out.println(data);
}
}
/*
cd = DataTypeUtil.convertDataTypeDbtoJavaList(cd, cdb.getDatabaseType());
for(ColumnData it: cd) {
System.out.println("컬럼명 : " + it.getColumnNm());
System.out.println("타입 : " +it.getDbDataType() + ": " + it.getDataTy());
System.out.println("길이 : " +it.getDataSize());
if(it.getColumnNm().equals("cmmn_code_group")) {
}
}
System.out.println("---------------------------------------------------");
*/
}
System.out.println(checkMessage.getMessage());
}
}