List lstable = new ArrayList();
List ls = new ArrayList();
int i = 1, j = 0, rol = 0;
dbc = new DataBaseConnection();
sqlrol = "select count(*) as rol from sort";
pstmtrol = dbc.getConnection().prepareStatement(sqlrol);
rsrol = pstmtrol.executeQuery();
if (rsrol.next()) {
rol = rsrol.getInt("rol");
}
sql = "select * from sort";
try {
pstmt = dbc.getConnection().prepareStatement(sql);
rs = pstmt.executeQuery();
while (rs.next()) {
Sort vo = new Sort();
vo.setId(rs.getInt("id"));
vo.setName(rs.getString("name"));
vo.setSortno(rs.getString("sortno"));
vo.setImage(rs.getString("image"));
ls.add(vo);
if (i++ % 4 == 0) {
lstable.add(ls);
if (i > 1) {
ls = new ArrayList();
}
ls.clear();
j++;
}