Convert the string array to the SQL in condition and use SQL to query

For example, I want to convert String [] str = {"4", "5", "6"} to a String of "'4', '5', and '6. In this way, I can use SQL query: select * from tableName id in (string.

The source code implemented in the project is as follows:
Copy codeThe Code is as follows:
StringBuffer idsStr = new StringBuffer ();
For (int I = 0; I <ids. length; I ++ ){
If (I> 0 ){
IdsStr. append (",");
}
IdsStr. append ("'"). append (ids [I]). append ("'");
}

Another method I have come up with is as follows:
Copy codeThe Code is as follows:
Public static String stringArray2Strin (String [] str ){

StringBuffer sb = new StringBuffer ();
For (int I = 0; I <str. length; I ++ ){
Sb. append ("'"). append (str [I]). append ("'"). append (",");
}
Return sb. toString (). substring (0, sb. length ()-1 );
}

Public static void main (String [] args ){
String [] str = {"4", "5", "6 "};
System. out. println (ItemGroupService. stringArray2String (str ));
}