Advertisement
Guest User

Untitled

a guest
Jan 29th, 2017
183
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 3.08 KB | None | 0 0
  1. private static Connection con = null;
  2.     private static Connection con_orcl = null;
  3.     //private static String username = "eaist_nsi";
  4.     //private static String password = "eaist";
  5.     //private static String URL = "jdbc:oracle:thin:@//172.17.42.4:1521/eaistr"; //demo1
  6.     //private static String URL = "jdbc:oracle:thin:@//10.242.4.110:1521/orcl"; // local
  7.     //private static String URL = "jdbc:oracle:thin:@//172.16.76.41:1521/eaistr"; // prom
  8.     //private static String URL_SPHINX = "jdbc:mysql://172.16.76.43:9306?characterEncoding=utf8&maxAllowedPacket=512000"; //prom
  9.     //private static String URL_SPHINX = "jdbc:mysql://10.241.5.79:9315?characterEncoding=utf8&maxAllowedPacket=512000";//local
  10.     //private static String URL_SPHINX = "jdbc:mysql://172.17.42.12:9306?characterEncoding=utf8&maxAllowedPacket=512000";
  11.  
  12.  
  13.     public static void main(String[] args) throws SQLException {
  14.  
  15.         String login = args[0].split('@')[0].split('/')[0];
  16.         String password = args[0].split('@')[0].split('/')[1];
  17.         StringBuffer sb = new StringBuffer();
  18.         sb.append("jdbc:oracle:thin:@//");
  19.         sb.append(args[0].split('@')[1]);
  20.  
  21.         String URL = sb.toString();
  22.  
  23.         sb = new StringBuilder();
  24.         sb.append("jdbc:mysql://");
  25.         sb.append(args[1]);
  26.         sb.append("?characterEncoding=utf8&maxAllowedPacket=512000");
  27.  
  28.         String URL_SPHINX = sb.toString();
  29.         String target = args[2];
  30.  
  31.         try {
  32.             Class.forName("com.mysql.jdbc.Driver").newInstance();
  33.             con = DriverManager.getConnection(URL_SPHINX, "", "");
  34.         } catch (InstantiationException | IllegalAccessException | ClassNotFoundException e) {
  35.             throw new IllegalArgumentException(e);
  36.         }
  37.         //соединяемся
  38.         if(con != null) {
  39.             System.out.println("Connection mysql Successful !\n");
  40.  
  41.             try {
  42.                 con_orcl = DriverManager.getConnection(URL, username, password);
  43.             } catch (SQLException e) {
  44.                 e.printStackTrace();
  45.             }
  46.             if (con_orcl !=null) {
  47.                 System.out.println("Connection oracle Successful !\n");
  48.  
  49.                 if (target.equals("address")) {
  50.                     System.out.println();
  51.                     System.out.println("CLEAR INDEX ADDROBJ");
  52.                     clear("ADDROBJ", con);
  53.                     System.out.println("loadAddrObj start");
  54.                     setFields();
  55.                     String sql1 = "select " + buildNamesList(fields, true) + " from N_ADDROBJ where ACTSTATUS=1 ";
  56.                     getAddrObj(sql1, con_orcl, con);*/
  57.                 } else {
  58.                     System.out.println("CLEAR INDEX HOUSE");
  59.                     clear("HOUSE", con);
  60.                     System.out.println("loadHause start");
  61.                     setHouseFields();
  62.                     String sql2 = "select " + buildNamesList(fields, true) + " from N_HOUSE ";
  63.                     getHouse(sql2, con_orcl, con);
  64.                 }
  65.             }
  66.  
  67.             con.close();
  68.             con_orcl.close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement