public static String deactive_proj(String projname) throws IOException, SQLException {
   String sqlst =
       "update projects set Status = \"inactive\" where ProjectName = \"" + projname + "\"";
   String[] result = CommonMethods.db_query_exec(sqlst, "", "update");
   String nresult = StringUtils.join(result, "#@@#");
   return nresult;
 }
 public static String list_proj() throws IOException, SQLException {
   String sqlst = "SELECT * FROM projects";
   String[] result =
       CommonMethods.db_query_exec(
           sqlst, "ProjectName,CreatedDate,Servername,EInst,PInst,Status", "select");
   String nresult = StringUtils.join(result, "#@@#");
   return nresult;
 }
 public static String list_inst_dropdown() throws IOException, SQLException {
   String sqlst = "SELECT name FROM instance_list where image like 'cir%'";
   String sqlst2 = "SELECT name FROM instance_list where image like 'and%'";
   String sqlst1 =
       "SELECT devices.idDevices FROM devices where idDevices in (select PInst from projects where projects.status = 'inactive')  or devices.idDevices not in (select PInst from projects);";
   // String sqlst2 = "SELECT name FROM instance_list";
   String result = "";
   String[] name = CommonMethods.db_query_exec(sqlst, "name", "select");
   String[] imgname = CommonMethods.db_query_exec(sqlst2, "name", "select");
   String[] nmemob = CommonMethods.db_query_exec(sqlst1, "idDevices", "select");
   result =
       StringUtils.join(name, ",")
           + "#@##"
           + StringUtils.join(nmemob, ",")
           + "#@##"
           + StringUtils.join(imgname, ",");
   return result;
 }
 public static void create_proj(String val) throws IOException, SQLException {
   java.util.Date dt = new java.util.Date();
   java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
   String currentTime = sdf.format(dt);
   String[] parts = val.split("##@#@");
   String sqlst =
       "INSERT INTO `projects` (`ProjectName`, `CreatedDate`, `Servername`, `EInst`, `PInst`, `Status`) VALUES ('"
           + parts[0]
           + "','"
           + currentTime
           + "','"
           + parts[1]
           + "','"
           + parts[2]
           + "','"
           + parts[3]
           + "','"
           + parts[4]
           + "');";
   CommonMethods.db_query_exec(sqlst, "", "insert");
 }
 public static String del_proj(String projname) throws IOException, SQLException {
   String sqlst = "DELETE from projects where ProjectName = \"" + projname + "\"";
   String[] result = CommonMethods.db_query_exec(sqlst, "", "delete");
   String nresult = StringUtils.join(result, "#@@#");
   return nresult;
 }