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);
}