cn.caijava.core.spring.jdbc

类 JdbcTemplateUtil

java.lang.Object

cn.caijava.core.spring.jdbc.JdbcTemplateUtil

@Component
public class JdbcTemplateUtil
extends Object

构造器概要

构造器

构造器和说明
JdbcTemplateUtil()

方法概要

限定符和类型	方法和说明
static long	count(String countSql)
static long	count(String countSql, Map<String,Object> args)
static String	makeInsertOnDuplicateKeyUpdateToTableSql(String tableName, Map<String,Field> fieldMap, Predicate<? super String> columnFilter)
static List<Map<String,Object>>	query(String sql)
static List<Map<String,Object>>	query(String sql, Map<String,Object> args)
static <T> List<T>	queryByType(String sql, Class<T> clazz)
static <T> List<T>	queryByType(String sql, Map<String,Object> args, Class<T> clazz)
static <T> int[]	saveOrUpdate(List<T> pos, Predicate<? super String> predicate) 返回值含义 Statement.executeBatch() 和springJPA共用事务问题 DataSourceUtils.getConnection(javax.sql.DataSource)

从类继承的方法 java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

构造器详细资料

JdbcTemplateUtil

public JdbcTemplateUtil()

方法详细资料

query

public static List<Map<String,Object>> query(String sql,
                                             Map<String,Object> args)

query

public static List<Map<String,Object>> query(String sql)

count

public static long count(String countSql,
                         Map<String,Object> args)

count

public static long count(String countSql)

queryByType

public static <T> List<T> queryByType(String sql,
                                      Class<T> clazz)

queryByType

public static <T> List<T> queryByType(String sql,
                                      Map<String,Object> args,
                                      Class<T> clazz)

saveOrUpdate

public static <T> int[] saveOrUpdate(List<T> pos,
                                     Predicate<? super String> predicate)

 返回值含义 Statement.executeBatch()
 和springJPA共用事务问题 DataSourceUtils.getConnection(javax.sql.DataSource)
 

参数:

pos - 数据库实体列表

predicate - 表字段过滤器

返回:

T 结果实体

makeInsertOnDuplicateKeyUpdateToTableSql

public static String makeInsertOnDuplicateKeyUpdateToTableSql(String tableName,
                                                              Map<String,Field> fieldMap,
                                                              Predicate<? super String> columnFilter)