本文整理汇总了Java中org.apache.ibatis.jdbc.SQL类的典型用法代码示例。如果您正苦于以下问题:Java SQL类的具体用法?Java SQL怎么用?Java SQL使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
SQL类属于org.apache.ibatis.jdbc包,在下文中一共展示了SQL类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的Java代码示例。
示例1: findByPage
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
/**
* 查询所有记录(分页)
*
* @param parameter
* @return
*/
public String findByPage(final Map<String, Object> parameter) {
return new SQL() {
{
Class<?> clazz = (Class<?>) parameter.get(CLASS_KEY);
SELECT("*");
FROM(EntityUtil.getTableName(clazz));
if (parameter.containsKey(WHERE_KEY)) {
WHERE((String) parameter.get(WHERE_KEY));
}
if (parameter.containsKey(ORDER_KEY)) {
ORDER_BY((String) parameter.get(ORDER_KEY));
}
if (parameter.containsKey(GROUP_KEY)) {
GROUP_BY((String) parameter.get(GROUP_KEY));
}
}
}.toString();
}
开发者ID:colin-lee,项目名称:mybatis-spring-support,代码行数:25,代码来源:CrudProvider.java
示例2: update
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
public String update(String[] fields, String conditions) {
SQL sql = new SQL().UPDATE(metadata.getTableName() + " AS _this");
for (ColumnProperty property : metadata.getUpdateProperties()) {
String propertyName = property.getName();
// 不包含字段
if (fields.length > 0 && !ArrayUtils.contains(fields, propertyName)) {
continue;
}
Path path = root.getPath(property);
sql.SET(path.getColumn() + "=#{" + path.getPropertyName() + "}");
}
if (conditions != null && conditions.length() > 0) {
sql.WHERE(conditions);
}
return sql.toString();
}
开发者ID:yaoakeji,项目名称:hibatis,代码行数:17,代码来源:SqlBuilder.java
示例3: insert
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
public String insert(T record) {
SQL sql = new SQL().INSERT_INTO(this.getTableName());
getAllDeclaredFields(entityClass).stream()
.filter(field -> !field.isAnnotationPresent(Ignore.class))
.forEach(field -> {
String fieldName = field.getName();
Object value = valueOfField(record, fieldName);
if (null != value) {
if (field.isAnnotationPresent(Column.class)) {
Column annotation = field.getAnnotation(Column.class);
sql.VALUES(annotation.column().trim(), fieldExpression(fieldName, annotation));
} else {
sql.VALUES(columnName(fieldName), fieldExpression(fieldName, null));
}
}
});
if (logger.isDebugEnabled()) {
logger.debug(sql.toString());
}
return sql.toString();
}
开发者ID:superkoh,项目名称:k-framework,代码行数:22,代码来源:BaseSqlBuilder.java
示例4: insertSql
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
public String insertSql(final MemAccount memAccount) {
return new SQL(){{
INSERT_INTO(TABLE_NAME);
VALUES("uid", "#{uid}");
VALUES("name", "#{name}");
VALUES("figure", "#{figure}");
VALUES("account", "#{account}");
VALUES("psw", "#{psw}");
VALUES("email", "#{email}");
VALUES("phone", "#{phone}");
VALUES("channel", "#{channel}");
VALUES("platform", "#{platform}");
VALUES("timeCreate", "#{timeCreate}");
VALUES("timeLastLogin", "#{timeLastLogin}");
VALUES("ipCreate", "#{ipCreate}");
VALUES("ipLastLogin", "#{ipLastLogin}");
VALUES("vipLevel", "#{vipLevel}");
VALUES("vipExp", "#{vipExp}");
VALUES("rmb", "#{rmb}");
}}.toString();
}
开发者ID:ogcs,项目名称:Okra-Ax,代码行数:22,代码来源:AccountSqlProvider.java
示例5: updateSql
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
public String updateSql() {
return new SQL(){{
UPDATE(TABLE_NAME);
SET("uid=#{uid}");
SET("name=#{name}");
SET("figure=#{figure}");
SET("account=#{account}");
SET("psw=#{psw}");
SET("email=#{email}");
SET("phone=#{phone}");
SET("channel=#{channel}");
SET("platform=#{platform}");
SET("timeLastLogin=#{timeLastLogin}");
SET("ipLastLogin=#{ipLastLogin}");
SET("vipLevel=#{vipLevel}");
SET("vipExp=#{vipExp}");
SET("rmb=#{rmb}");
WHERE("uid=#{uid}");
}}.toString();
}
开发者ID:ogcs,项目名称:Okra-Ax,代码行数:21,代码来源:AccountSqlProvider.java
示例6: insertSelective
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table user
*
* @mbg.generated
*/
public String insertSelective(User record) {
SQL sql = new SQL();
sql.INSERT_INTO("user");
if (record.getId() != null) {
sql.VALUES("id", "#{id,jdbcType=INTEGER}");
}
if (record.getUsername() != null) {
sql.VALUES("username", "#{username,jdbcType=VARCHAR}");
}
if (record.getPsw() != null) {
sql.VALUES("psw", "#{psw,jdbcType=VARCHAR}");
}
return sql.toString();
}
开发者ID:RayeWang,项目名称:SpringbootMybatis,代码行数:25,代码来源:UserSqlProvider.java
示例7: selectByExample
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table user
*
* @mbg.generated
*/
public String selectByExample(UserCriteria example) {
SQL sql = new SQL();
if (example != null && example.isDistinct()) {
sql.SELECT_DISTINCT("id");
} else {
sql.SELECT("id");
}
sql.SELECT("username");
sql.SELECT("psw");
sql.FROM("user");
applyWhere(sql, example, false);
if (example != null && example.getOrderByClause() != null) {
sql.ORDER_BY(example.getOrderByClause());
}
return sql.toString();
}
开发者ID:RayeWang,项目名称:SpringbootMybatis,代码行数:25,代码来源:UserSqlProvider.java
示例8: updateByExampleSelective
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table user
*
* @mbg.generated
*/
public String updateByExampleSelective(Map<String, Object> parameter) {
User record = (User) parameter.get("record");
UserCriteria example = (UserCriteria) parameter.get("example");
SQL sql = new SQL();
sql.UPDATE("user");
if (record.getId() != null) {
sql.SET("id = #{record.id,jdbcType=INTEGER}");
}
if (record.getUsername() != null) {
sql.SET("username = #{record.username,jdbcType=VARCHAR}");
}
if (record.getPsw() != null) {
sql.SET("psw = #{record.psw,jdbcType=VARCHAR}");
}
applyWhere(sql, example, true);
return sql.toString();
}
开发者ID:RayeWang,项目名称:SpringbootMybatis,代码行数:29,代码来源:UserSqlProvider.java
示例9: updateByPrimaryKeySelective
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
/**
* This method was generated by MyBatis Generator.
* This method corresponds to the database table user
*
* @mbg.generated
*/
public String updateByPrimaryKeySelective(User record) {
SQL sql = new SQL();
sql.UPDATE("user");
if (record.getUsername() != null) {
sql.SET("username = #{username,jdbcType=VARCHAR}");
}
if (record.getPsw() != null) {
sql.SET("psw = #{psw,jdbcType=VARCHAR}");
}
sql.WHERE("id = #{id,jdbcType=INTEGER}");
return sql.toString();
}
开发者ID:RayeWang,项目名称:SpringbootMybatis,代码行数:23,代码来源:UserSqlProvider.java
示例10: select
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
public String select(Map<String, Object> params) {
Object condition = params.get("condition");
EntityTable entityTable = getEntityTable(condition.getClass());
Pageable pageable = null;
if (params.containsKey("pageable")) {
pageable = (Pageable) params.get("pageable");
}
SQL sql = new SQL();
sql.SELECT(entityTable.getSelectColumns());
sql.FROM(entityTable.getName());
entityTable.getInnerJoins().forEach(sql::INNER_JOIN);
applyWhere(sql, entityTable, condition);
if (pageable == null) {
entityTable.getOrderBys().forEach(sql::ORDER_BY);
return sql.toString();
} else {
return applyPageable(sql, pageable);
}
}
开发者ID:tangr1,项目名称:mybatis-easy-mapper,代码行数:20,代码来源:SQLProvider.java
示例11: update
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
/**
* 更新操作
*
* @param obj
* @return String
*/
public String update(Object obj) {
Class<?> clazz = obj.getClass();
PersistMeta meta = EntityUtil.getMeta(clazz);
StringBuilder setting = new StringBuilder(32);
int i = 0;
for (Map.Entry<String, Field> kv : meta.getColumns().entrySet()) {
if (isNull(kv.getValue(), obj)) {
continue;
}
if (i++ != 0) {
setting.append(',');
}
setting.append('`').append(kv.getKey()).append('`').append("=#{").append(kv.getValue().getName()).append('}');
}
return new SQL().UPDATE(getTableName(meta, obj)).SET(setting.toString()).WHERE("id=#{id}").toString();
}
开发者ID:colin-lee,项目名称:mybatis-spring-support,代码行数:26,代码来源:CrudProvider.java
示例12: insert
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
/**
* 新增操作
*
* @param obj
* @return String
*/
public String insert(Object obj) {
PersistMeta meta = EntityUtil.getMeta(obj.getClass());
StringBuilder names = new StringBuilder(), values = new StringBuilder();
int i = 0;
for (Map.Entry<String, Field> kv : meta.getColumns().entrySet()) {
if (isNull(kv.getValue(), obj)) {
continue;
}
if (i++ != 0) {
names.append(',');
values.append(',');
}
names.append('`').append(kv.getKey()).append('`');
values.append("#{").append(kv.getValue().getName()).append('}');
}
return new SQL().INSERT_INTO(getTableName(meta, obj)).VALUES(names.toString(), values.toString()).toString();
}
开发者ID:colin-lee,项目名称:mybatis-spring-support,代码行数:27,代码来源:CrudProvider.java
示例13: query
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
public String query(DefaultPageAndSortEntity defaultPageAndSortEntity) {
try {
final Map<String, Object> entityData = getParam(defaultPageAndSortEntity);
return new SQL() {
{
SELECT("*");
FROM(TABLE_NAME);
for(String column : entityData.keySet()) {
WHERE(column + "=#{" + entityData.get(column) + "}");
}
}
}.toString();
} catch(Exception e) {
throw new MybatisHelperException("query sql error", e);
}
}
开发者ID:fangjian0423,项目名称:mybatis-helper,代码行数:17,代码来源:SqlProvider.java
示例14: count
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
public String count(DefaultPageAndSortEntity defaultPageAndSortEntity) {
try {
final Map<String, Object> entityData = getParam(defaultPageAndSortEntity);
return new SQL() {
{
SELECT("count(*)");
FROM(TABLE_NAME);
for(String column : entityData.keySet()) {
WHERE(column + "=#{" + entityData.get(column) + "}");
}
}
}.toString();
} catch(Exception e) {
throw new MybatisHelperException("count sql error", e);
}
}
开发者ID:fangjian0423,项目名称:mybatis-helper,代码行数:17,代码来源:SqlProvider.java
示例15: update
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
public String update(Entity model) {
try {
final Map<String, Object> entityData = getParam(model);
entityData.remove("id");
return new SQL() {
{
UPDATE(TABLE_NAME);
for(String column : entityData.keySet()) {
SET(column + "=#{" + entityData.get(column) + "}");
}
WHERE("id = #{id}");
}
}.toString();
} catch(Exception e) {
throw new MybatisHelperException("construct update sql error", e);
}
}
开发者ID:fangjian0423,项目名称:mybatis-helper,代码行数:18,代码来源:SqlProvider.java
示例16: deleteMsgSQLByCustomer
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
/**
* 提供deleteMsgSQLByCustomer的SQL
* @param paramMap
* @return
*/
public String deleteMsgSQLByCustomer(final Map<String, Object> paramMap) {
final int cust_id = (int) paramMap.get("cust_id");
final int level = (int) paramMap.get("level");
if (level != 1 && level != 2 && level != 3)
throw new MmtException("消息库找不到: level=" + level);
if(level == 3)
throw new MmtException("通用消息库不支持按照cust_id删除。");
return new SQL() {
{
DELETE_FROM("msg_repo_l" + level);
WHERE("cust_id=" + cust_id);
}
}.toString();
}
开发者ID:cjm0000000,项目名称:mmt,代码行数:21,代码来源:LocalMsgBeanSQLProvider.java
示例17: buildSelectByIdAndNameMultipleParamAndProviderContextWithAtParam
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
public String buildSelectByIdAndNameMultipleParamAndProviderContextWithAtParam(@Param("id") final Integer id, ProviderContext context, @Param("name") final String name) {
final boolean containsLogicalDelete = context.getMapperMethod().getAnnotation(BaseMapper.ContainsLogicalDelete.class) != null;
final String tableName = context.getMapperType().getAnnotation(BaseMapper.Meta.class).tableName();
return new SQL(){{
SELECT("*");
FROM(tableName);
if (id != null) {
WHERE("id = #{id}");
}
if (name != null) {
WHERE("name like #{name} || '%'");
}
if (!containsLogicalDelete){
WHERE("logical_delete = false");
}
}}.toString();
}
开发者ID:mybatis,项目名称:mybatis-3,代码行数:18,代码来源:OurSqlBuilder.java
示例18: buildSelectByIdAndNameMultipleParamAndProviderContext
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
public String buildSelectByIdAndNameMultipleParamAndProviderContext(final Integer id, final String name, ProviderContext context) {
final boolean containsLogicalDelete = context.getMapperMethod().getAnnotation(BaseMapper.ContainsLogicalDelete.class) != null;
final String tableName = context.getMapperType().getAnnotation(BaseMapper.Meta.class).tableName();
return new SQL(){{
SELECT("*");
FROM(tableName);
if (id != null) {
WHERE("id = #{param1}");
}
if (name != null) {
WHERE("name like #{param2} || '%'");
}
if (!containsLogicalDelete){
WHERE("logical_delete = false");
}
}}.toString();
}
开发者ID:mybatis,项目名称:mybatis-3,代码行数:18,代码来源:OurSqlBuilder.java
示例19: test1
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
@Test
public void test1() {
String sql = new SQL()
.SELECT("id, name").FROM("PERSON A")
.WHERE("name like ?")
.WHERE("id = ?").toString();
System.err.println(sql);
}
开发者ID:Caratacus,项目名称:mybatis-plus-mini,代码行数:10,代码来源:SqlBuilderTest.java
示例20: insertSelectiveSql
import org.apache.ibatis.jdbc.SQL; //导入依赖的package包/类
@Deprecated
public String insertSelectiveSql(final Map<String, Object> param) {
return new SQL() {
{
INSERT_INTO((String) param.get("tableName"));
@SuppressWarnings("unchecked")
Map<String, String> mapping = (Map<String, String>) param.get("columnValueMapping");
for (String key : mapping.keySet()) {
VALUES(key, "#{columnValueMapping." + key + "}");
}
}
}.toString();
}
开发者ID:geeker-lait,项目名称:tasfe-framework,代码行数:16,代码来源:CrudDaoProvider.java
注:本文中的org.apache.ibatis.jdbc.SQL类示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论