Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private static Connection con = null;
- private static Connection con_orcl = null;
- //private static String username = "eaist_nsi";
- //private static String password = "eaist";
- //private static String URL = "jdbc:oracle:thin:@//172.17.42.4:1521/eaistr"; //demo1
- //private static String URL = "jdbc:oracle:thin:@//10.242.4.110:1521/orcl"; // local
- //private static String URL = "jdbc:oracle:thin:@//172.16.76.41:1521/eaistr"; // prom
- //private static String URL_SPHINX = "jdbc:mysql://172.16.76.43:9306?characterEncoding=utf8&maxAllowedPacket=512000"; //prom
- //private static String URL_SPHINX = "jdbc:mysql://10.241.5.79:9315?characterEncoding=utf8&maxAllowedPacket=512000";//local
- //private static String URL_SPHINX = "jdbc:mysql://172.17.42.12:9306?characterEncoding=utf8&maxAllowedPacket=512000";
- public static void main(String[] args) throws SQLException {
- String login = args[0].split('@')[0].split('/')[0];
- String password = args[0].split('@')[0].split('/')[1];
- StringBuffer sb = new StringBuffer();
- sb.append("jdbc:oracle:thin:@//");
- sb.append(args[0].split('@')[1]);
- String URL = sb.toString();
- sb = new StringBuilder();
- sb.append("jdbc:mysql://");
- sb.append(args[1]);
- sb.append("?characterEncoding=utf8&maxAllowedPacket=512000");
- String URL_SPHINX = sb.toString();
- String target = args[2];
- try {
- Class.forName("com.mysql.jdbc.Driver").newInstance();
- con = DriverManager.getConnection(URL_SPHINX, "", "");
- } catch (InstantiationException | IllegalAccessException | ClassNotFoundException e) {
- throw new IllegalArgumentException(e);
- }
- //соединяемся
- if(con != null) {
- System.out.println("Connection mysql Successful !\n");
- try {
- con_orcl = DriverManager.getConnection(URL, username, password);
- } catch (SQLException e) {
- e.printStackTrace();
- }
- if (con_orcl !=null) {
- System.out.println("Connection oracle Successful !\n");
- if (target.equals("address")) {
- System.out.println();
- System.out.println("CLEAR INDEX ADDROBJ");
- clear("ADDROBJ", con);
- System.out.println("loadAddrObj start");
- setFields();
- String sql1 = "select " + buildNamesList(fields, true) + " from N_ADDROBJ where ACTSTATUS=1 ";
- getAddrObj(sql1, con_orcl, con);*/
- } else {
- System.out.println("CLEAR INDEX HOUSE");
- clear("HOUSE", con);
- System.out.println("loadHause start");
- setHouseFields();
- String sql2 = "select " + buildNamesList(fields, true) + " from N_HOUSE ";
- getHouse(sql2, con_orcl, con);
- }
- }
- con.close();
- con_orcl.close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement