数组拼接sql语句[通俗易懂]

//type= {1，2，3}
StringBuilder querysql = new StringBuilder("from 表名 tbbb LEFT JOIN 表名 c ON tbbb.ID = c.ID where 1=1");
        if(type!= null && type.length>0){ 
   
            String typEend= " and ";
            String typeString= "";
            for (int i=0;i<type.length;i++){ 
   
                typeString= typeString+ " or "+ "tbbb.abc= "+ type[i];
            }
            typeString = typeString.substring(3);
            typeEnd= typeEnd+"("+string+")";
            querysql.append(typeEnd);
        }