利用Druid数据源构建SQL语句

利用这个组件来构建SQL语句，也是一种思路吧

        //简单sql
        SQLSelect sqlSelect = new SQLSelect();
        
        OracleSelectQueryBlock queryBlock = new OracleSelectQueryBlock();
        //列名
        queryBlock.addSelectItem(new SQLIdentifierExpr("name"));
        queryBlock.addSelectItem(new SQLIdentifierExpr("age"));
        queryBlock.addSelectItem(new SQLIdentifierExpr("id"));
        queryBlock.setFrom(new SQLExprTableSource(new SQLIdentifierExpr("t_user")));
        //待分页
        queryBlock.setLimit(new SQLLimit(new SQLNumberExpr(1), new SQLNumberExpr(10)));
        sqlSelect.setQuery(queryBlock);
        
        String sql = SQLUtils.toSQLString(sqlSelect);
        System.out.println(sql);

 

转载于:https://www.cnblogs.com/weiguangyue/p/9965780.html