cn.songxinqiang.study.mybatis.sqlprovider.OrderSQLProvider.java Source code

Introduction

Here is the source code for cn.songxinqiang.study.mybatis.sqlprovider.OrderSQLProvider.java

Source

/**
 * <pre>
 * Copyright 2014,2015 sxq(songxinqiang@vip.qq.com).
 * 
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 * 
 *      http://www.apache.org/licenses/LICENSE-2.0
 * 
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 * </pre>
 */
/*
 * 20151130--?5:24:19
 * sxq(songxinqiang@vip.qq.com)
 */
package cn.songxinqiang.study.mybatis.sqlprovider;

import java.util.Map;

import org.apache.ibatis.jdbc.SQL;

/**
 *
 * <p>
 * ?, , ????.
 * </p>
 *
 * @author sxq-20151130
 *
 */
public class OrderSQLProvider {

    private static final String TABLE_NAME = "orders";

    public String getSql(Map<String, Object> parameters) {
        Integer uid = (Integer) parameters.get("id");
        SQL sql = new SQL().SELECT("order_id, order_no, order_price").FROM(TABLE_NAME);
        if (uid != null) {
            sql = sql.WHERE("order_id = #{id}");
        }
        return sql.toString();
    }

    public String getAllSql() {
        SQL sql = new SQL().SELECT("order_id, order_no, order_price").FROM(TABLE_NAME);
        return sql.toString();
    }

}