本文整理汇总了Java中com.taobao.tddl.matrix.jdbc.TDataSource.setConnectionProperties方法的典型用法代码示例。如果您正苦于以下问题：Java TDataSource.setConnectionProperties方法的具体用法？Java TDataSource.setConnectionProperties怎么用？Java TDataSource.setConnectionProperties使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类com.taobao.tddl.matrix.jdbc.TDataSource的用法示例。
在下文中一共展示了TDataSource.setConnectionProperties方法的4个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: main
import com.taobao.tddl.matrix.jdbc.TDataSource; //导入方法依赖的package包/类
public static void main(String[] args) throws TddlException, SQLException {
TDataSource ds = new TDataSource();
// init a datasource with dynamic config on diamond
ds.setAppName("XIAMI_WEB_ATHENA");
Map cp = new HashMap();
cp.put(ConnectionProperties.ALLOW_TEMPORARY_TABLE, "true");
// cp.put(ConnectionProperties.MERGE_CONCURRENT, "true");
ds.setConnectionProperties(cp);
ds.init();
System.out.println("init done");
Connection conn = ds.getConnection();
// select all records
PreparedStatement ps = conn.prepareStatement("select user_id,num from (SELECT user_id, count(*) AS num FROM receive_flowers GROUP BY user_id having num >= 100) t ORDER BY num desc");
ResultSet rs = ps.executeQuery();
while (rs.next()) {
StringBuilder sb = new StringBuilder();
int count = rs.getMetaData().getColumnCount();
for (int i = 1; i <= count; i++) {
String key = rs.getMetaData().getColumnLabel(i);
Object val = rs.getObject(i);
sb.append("[" + rs.getMetaData().getTableName(i) + "." + key + "->" + val + "]");
}
System.out.println(sb.toString());
}
rs.close();
ps.close();
conn.close();
System.out.println("query done");
}
示例2: main
import com.taobao.tddl.matrix.jdbc.TDataSource; //导入方法依赖的package包/类
public static void main(String[] args) throws TddlException, SQLException, FileNotFoundException {
Log4jConfigurer.initLogging("src/main/resources/log4j.properties");
TDataSource ds = new TDataSource();
// 设置默认db(ob)
ds.setAppName("DEV_DPS_APP");
ds.setTopologyFile("tddl-topology-dps.xml");
ds.setRuleFile("tddl-rule-dps-nonmysql.xml");
// 设置simba2的mysql
App subApp = new App();
subApp.setAppName("DAILY_SOLAR_MERCURY_APP");
subApp.setRuleFile("tddl-rule-dps-simba2-mysql.xml");
ds.addSubApp(subApp);
// 添加subway的mysql
subApp = new App();
subApp.setAppName("DEV_SUBWAY_MYSQL");
subApp.setRuleFile("tddl-rule-dps-subway-mysql.xml");
ds.addSubApp(subApp);
Map cp = new HashMap();
cp.put("ALLOW_TEMPORARY_TABLE", "True");
cp.put(ConnectionProperties.TEMP_TABLE_DIR, ".\\temp\\");
cp.put(ConnectionProperties.TEMP_TABLE_CUT_ROWS, false);
cp.put(ConnectionProperties.TEMP_TABLE_MAX_ROWS, 1000);
ds.setConnectionProperties(cp);
ds.init();
System.out.println("init done");
// subway_adgroup_list.sql
// solar_adgroup_list.sql
String sql = SqlFileUtil.getSql("replace.txt");
// sql = SqlFileUtil.getSql("solar_adgroup_list.sql");
Connection conn = ds.getConnection();
{
PreparedStatement ps = conn.prepareStatement(sql);
long start = System.currentTimeMillis();
ResultSet rs = ps.executeQuery();
while (rs.next()) {
StringBuilder sb = new StringBuilder();
int count = rs.getMetaData().getColumnCount();
for (int i = 1; i <= count; i++) {
String key = rs.getMetaData().getColumnLabel(i);
Object val = rs.getObject(i);
sb.append("[" + rs.getMetaData().getTableName(i) + "." + key + "->" + val + "]");
}
System.out.println(sb.toString());
}
System.out.println("done " + (System.currentTimeMillis() - start));
rs.close();
ps.close();
}
conn.close();
}
示例3: JDBCClient
import com.taobao.tddl.matrix.jdbc.TDataSource; //导入方法依赖的package包/类
public static void JDBCClient(String dbTypeStack, boolean async) throws Exception {
us = new TDataSource();
// if ("tddl".equalsIgnoreCase(dbTypeStack) ||
// "mysql".equalsIgnoreCase(dbTypeStack)) {
us.setAppName("andor_mysql_qatest");
// } else if ("tdhs".equalsIgnoreCase(dbTypeStack)) {
// us.setAppName("andor_tdhs_qatest");
// } else if ("hbase".equalsIgnoreCase(dbTypeStack)) {
// us.setAppName("andor_hbase_qatest");
// }
us.setRuleFile(ruleFile + dbTypeStack + "_" + rule);
if ((!"tddl".equalsIgnoreCase(dbTypeStack)) && (!"tdhs".equalsIgnoreCase(dbTypeStack))) {
us.setTopologyFile(machineTapologyFile);
us.setSchemaFile(schemaFile + dbTypeStack + "_" + schema);
}
Map<String, Object> cp = new HashMap<String, Object>();
if ("tdhs".equalsIgnoreCase(dbTypeStack)) {
cp.put(ExtraCmd.USE_TDHS_FOR_DEFAULT, "true");
}
if ("hbase".equalsIgnoreCase(dbTypeStack)) {
cp.put(ExtraCmd.HBASE_MAPPING_FILE, "matrix/hbase_mapping.xml");
}
us.setConnectionProperties(cp);
try {
us.init();
} catch (Exception e) {
Assert.fail(ExceptionUtils.getFullStackTrace(e));
}
}
示例4: main
import com.taobao.tddl.matrix.jdbc.TDataSource; //导入方法依赖的package包/类
public static void main(String[] args) throws TddlException, SQLException {
TDataSource ds = new TDataSource();
// init a datasource with dynamic config on diamond
ds.setAppName("CREDITCTRL_APP");
Map cp = new HashMap();
// cp.put(ConnectionProperties.MERGE_CONCURRENT, "false");
ds.setConnectionProperties(cp);
ds.init();
System.out.println("init done");
Connection conn = ds.getConnection();
System.out.println("insert done");
// select all records
PreparedStatement ps = conn.prepareStatement("SELECT * from SYS_LOG");
// PreparedStatement ps =
// conn.prepareStatement("SELECT device_id from bullet_dt_device_content limit 10");
ResultSet rs = ps.executeQuery();
while (rs.next()) {
StringBuilder sb = new StringBuilder();
int count = rs.getMetaData().getColumnCount();
for (int i = 1; i <= count; i++) {
String key = rs.getMetaData().getColumnLabel(i);
Object val = rs.getObject(i);
sb.append("[" + rs.getMetaData().getTableName(i) + "." + key + "->" + val + "]");
}
System.out.println(sb.toString());
}
rs.close();
ps.close();
conn.close();
System.out.println("query done");
}