我想里面SQLite数据库拆分逗号。 我有一个Product_ code在一个产品表中的两个product_ code型。 可以看看图片产品表product_ code柱有两个PRODCUT type.How我能做到这一点？

I want to split comma inside SQLite database. I have two product_code type in one Product_code in one Product table. can look at the picture Product table product_code column have two prodcut type.How I can do this?

推荐答案

哟可以分割产品code与，

yo can split productCode with ,

String productCodes = cursor.getString(cursor.getColumnIndex("product_code"));  
String[] codes = productCodes.split(",");  

String code1 = codes[0]);
String code2 = codes[1]);



//for (String code: codes )  
// {  
//    System.out.println(code);  
// }