sql查询where/in

最新推荐文章于 2024-08-09 23:23:34 发布

爱是向我的

最新推荐文章于 2024-08-09 23:23:34 发布

阅读量1.5k

点赞数

分类专栏： sql查询文章标签： sql

本文链接：https://blog.csdn.net/qq_32601201/article/details/52064470

版权

sql查询专栏收录该内容

6 篇文章 0 订阅

订阅专栏

public List<Object> getHousePeopleNoById(String roomObjectId,TableHistory table) {
        StringBuilder selectSql = new StringBuilder();
        String tablename=table.getTableName().trim() + "_BEFORE";
        selectSql.append("select NAME from " + tablename);
        selectSql.append(" where room_id in (" + roomObjectId+")");
        Query query = getSession().createSQLQuery(selectSql.toString());
        List<Object> list = query.list();
        List<Object> nullArr = new ArrayList<Object>();  
        nullArr.add(null);  
        list.removeAll(nullArr);
        return list;
    }

List<RoomNumber> roomNumbers=roomNumberManager.getListByBuildingId(buildingId);
StringBuilder roomObjectId = new StringBuilder(600);
for(int i=0;i<roomNumbers.size();i++){      roomObjectId.append(roomNumbers.get(i).getObjectId()).append(",");
    }
roomObjectId.append("-1");

参数拼成字符串