Shulou(Shulou.com)05/31 Report--

How to convert string array into sql in condition using sql query, I believe that many inexperienced people are at a loss about this. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

For example, I want to convert String [] str = {"4", "5", "6"} into a string of "4", 5 ", 6". So I can use sql to query: select * from tableName id in (string). The source code implemented in the project is as follows: the copy code is as follows: StringBuffer idsStr = new StringBuffer (); for (int I = 0; I

0) {idsStr.append (",");} idsStr.append ("'") .append (IDS [I]) .append ("'");}

Another way I can think of is as follows: copy the code as follows: public static String stringArray2Strin (String [] str) {StringBuffer sb = new StringBuffer (); for (int I = 0; I < str.length; iTunes +) {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));}

After reading the above, do you know how to transform the string array into the in condition of sql and query it with sql? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.