public class SQLUtils extends Object
限定符和类型 | 方法和说明 |
---|---|
static String |
makeDeleteSql(String tableName,
Map<String,Object> where)
拼接delete SQL语句
|
static String |
makeDynamicSql(String dynamicSql,
Map<String,Object> params)
拼接 动态SQL
String dynamicSql = "select * from article where {id = #id } {and val = $val } {vas in($vas )} {and creation > $createTime}";
<1>使用map作为参数
Map
|
static String |
makeDynamicSql(String dynamicSql,
Object params)
拼接 动态SQL
|
static String |
makeInsertSql(String tableName,
Map<String,Object> columns)
拼接 insert SQL语句
|
static String |
makeSelectAllSql(String tableName,
Map<String,Object> where)
拼接 select * SQL语句
|
static String |
makeUpdateSql(String tableName,
Map<String,Object> set,
Map<String,Object> where)
拼接update SQL语句
|
static void |
setDateFormat(String format)
设置date format
|
static String |
sqlValue(double value)
拼接SQL语法的字段字符串值
|
static String |
sqlValue(double[] value)
拼接SQL语法的字段字符串值
|
static String |
sqlValue(float value)
拼接SQL语法的字段字符串值
|
static String |
sqlValue(float[] value)
拼接SQL语法的字段字符串值
|
static String |
sqlValue(int value)
拼接SQL语法的字段字符串值
|
static String |
sqlValue(int[] value)
拼接SQL语法的字段字符串值
|
static String |
sqlValue(List<Object> value)
拼接SQL语法的字段字符串值
|
static String |
sqlValue(long value)
拼接SQL语法的字段字符串值
|
static String |
sqlValue(long[] value)
拼接SQL语法的字段字符串值
|
static String |
sqlValue(Object value)
拼接SQL语法的字段字符串值
|
static String |
sqlValue(Object[] value)
拼接SQL语法的字段字符串值
|
static String |
sqlValue(short value)
拼接SQL语法的字段字符串值
|
static String |
sqlValue(short[] value)
拼接SQL语法的字段字符串值
|
static String |
sqlValue(String value)
拼接SQL语法的字段字符串值
|
static String |
sqlValue(String[] value)
拼接SQL语法的字段字符串值
|
public static void setDateFormat(String format)
format
- -- date formatpublic static String makeSelectAllSql(String tableName, Map<String,Object> where)
tableName
- -- db 表名称where
- -- where 子句mappublic static String makeInsertSql(String tableName, Map<String,Object> columns)
tableName
- -- db 表名称columns
- -- 列集合mappublic static String makeUpdateSql(String tableName, Map<String,Object> set, Map<String,Object> where)
tableName
- -- db表名称set
- -- update子句mapwhere
- -- where 子句mappublic static String makeDeleteSql(String tableName, Map<String,Object> where)
tableName
- -- db表名称where
- -- where子句mappublic static String makeDynamicSql(String dynamicSql, Object params)
dynamicSql
- params
- public static String makeDynamicSql(String dynamicSql, Map<String,Object> params)
String dynamicSql = "select * from article where {id = #id } {and val = $val } {vas in($vas )} {and creation > $createTime}"; <1>使用map作为参数 Mapparams = new HashMap (); params.put("id", 20060601); params.put("val", "demo_value"); String sql = makeDynamicSql(dynamicSql, params); // sql --> "select * from article where id = 20060601 and val = 'demo_value'" <2>使用java bean作为参数 public static class MyParamBean { * private String id = null; private String val = null; * public String getId() { return id; } public void setId(String id) { this.id = id; } public String getVal() { return val; } public void setVal(String val) { this.val = val; } } * MyParamBean param = new MyParamBean(); param.setId("demo_id"); param.setVal("demo_value"); sql = SqlUtil.makeDynamicSql(dynamicSql, param.setVal); // sql --> "select * from article where id = 'demo_id' and val = 'demo_value'"
dynamicSql
- -- 动态SQL语句params
- -- 替换数据源public static String sqlValue(int value)
value
- -- 数据public static String sqlValue(long value)
value
- -- 数据public static String sqlValue(short value)
value
- -- 数据public static String sqlValue(float value)
value
- -- 数据public static String sqlValue(double value)
value
- -- 数据public static String sqlValue(Object[] value)
value
- -- 数据public static String sqlValue(String[] value)
value
- -- 数据public static String sqlValue(List<Object> value)
value
- -- 数据public static String sqlValue(int[] value)
value
- -- 数据public static String sqlValue(short[] value)
value
- -- 数据public static String sqlValue(long[] value)
value
- -- 数据public static String sqlValue(float[] value)
value
- -- 数据public static String sqlValue(double[] value)
value
- -- 数据Copyright © 2014 EPIC Team. All rights reserved.