1

I have this block of code: It is supposed to update mysql table according to conditions: if a column has not null constraint - it is stored in strSplited and then if a condition from if is true then it updates accordingly.

But it always gets the else result, even though conditions from first if are all satisfied.

I dont get it what is wrong (despite this awful code)

P.S I dont get strSplited.length = 1, its always > 1

String queryConstructor = null;
int valoareConstr = constrMax(max);
String[] strSplited = str.trim().split("\\s+");
    if (strSplited.length == 2 && strSplited[0] =="ID" && strSplited[1] == "NumePersoana") {
        queryConstructor = "ALTER TABLE persoane MODIFY NumePersoana char(" + valoareConstr
       + ") not null, MODIFY CNP char(" + valoareConstr + "),MODIFY Adresa char(" + valoareConstr
       + ");";
       String queryConstr = queryConstructor;
       System.out.println("Rez primul if: "+queryConstr);
   } else if (strSplited.length == 2 && strSplited[0] == "NumePersoana" && strSplited[1] == "Adresa") {
        queryConstructor = "ALTER TABLE persoane MODIFY NumePersoana char(" + valoareConstr
       + ") not null, MODIFY CNP char(" + valoareConstr + "), MODIFY Adresa char(" + valoareConstr
       + ") not null;";
   } else if (strSplited.length == 2 && strSplited[0] == "CNP" && strSplited[1] == "Adresa") {
        queryConstructor = "ALTER TABLE persoane MODIFY NumePersoana char(" + valoareConstr
       + "), MODIFY CNP char(" + valoareConstr + ") not null, MODIFY Adresa char(" + valoareConstr
       + ") not null;";
   } else if (strSplited.length == 2 && strSplited[0] == "CNP" && strSplited[1] == "NumePersoana") {
        queryConstructor = "ALTER TABLE persoane MODIFY NumePersoana char(" + valoareConstr
       + ") not null, MODIFY CNP char(" + valoareConstr + ") not null, MODIFY Adresa char(" + valoareConstr
       + ");";
   } 
 }   else if (strSplited.length == 3 && strSplited[0] == "NumePersoana" && strSplited[1] == "CNP" && strSplited[2] == "Adresa") {
     queryConstructor = "ALTER TABLE persoane MODIFY NumePersoana char(" + valoareConstr
  + ") not null, MODIFY CNP char(" + valoareConstr + ") not null, MODIFY Adresa char(" + valoareConstr
  + ") not null;";
 } else {
     queryConstructor = "ALTER TABLE persoane MODIFY NumePersoana char(" + valoareConstr
     + "), MODIFY CNP char(" + valoareConstr + "),MODIFY Adresa char("
     + valoareConstr + ");";
     System.out.println("nu sa executat if-ul asta smecher: " + queryConstructor);
 }

0 Answers0