コード例 #1
0
 public static boolean connect() {
   boolean result = false;
   ServerModel serverModel = new ServerModel();
   serverModel = getServer();
   if (serverModel.getDataname() != null
       || serverModel.getHostname() != null
       || serverModel.getUsername() != null
       || serverModel.getPassword() != null) {
     String data =
         "jdbc:sqlserver://"
             + serverModel.getHostname()
             + ";DATABASENAME= "
             + serverModel.getDataname();
     String user = serverModel.getUsername();
     String pass = serverModel.getPassword();
     DataUtil.DATA = data;
     DataUtil.USRE_NAME = user;
     DataUtil.PASSWORD = pass;
     try {
       Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
       conn = DriverManager.getConnection(DATA, USRE_NAME, PASSWORD);
       result = true;
     } catch (Exception e) {
       result = false;
     }
   } else {
     result = false;
   }
   return result;
 }
コード例 #2
0
  public static ServerModel getServer() {
    ServerModel model = new ServerModel();
    String server = new String();
    try {
      FileReader fr = new FileReader("input/server.ser");
      BufferedReader input = new BufferedReader(fr);
      if (!fr.ready()) {
        model.setDataname(null);
        model.setHostname(null);
        model.setPassword(null);
        model.setUsername(null);
      } else {
        server =
            ServerUtil.deencryptionStr(
                input.readLine()); // StringUtil.decriptString(input.readLine());
        try {
          if (server != null && !server.equals("")) {
            String[] array = server.split(",");
            String host = array[0].substring(0, array[0].length() - 13);
            ;
            model.setHostname(host);
            String data = array[1].substring(0, array[1].length() - 15);
            model.setDataname(data);
            String user = array[2].substring(0, array[2].length() - 15);
            model.setUsername(user);
            String pass = array[3].substring(0, array[3].length() - 9);
            model.setPassword(pass);
          }
        } catch (Exception e) {
          e.printStackTrace();
          JOptionPane.showMessageDialog(null, e.getMessage());
        }
      }
    } catch (Exception e) {
      e.printStackTrace();
      JOptionPane.showMessageDialog(null, "Not found file server! Please configure server!");
    }

    return model;
  }