Functions — github.com/fast-sql/FastSQL

hub / github.com/fast-sql/FastSQL / functions

Functions321 in github.com/fast-sql/FastSQL

⨍ Functions 321◇ Types & classes 35

↓ 244 callersMethodappend

追加任意字符串

src/main/java/top/fastsql/SQL.java:72

↓ 29 callersMethodtoString

()

src/main/java/top/fastsql/SQL.java:1361

↓ 27 callersMethodgetName

()

src/test/java/top/fastsql/SysDict.java:92

↓ 27 callersMethodgetSQL

()

src/main/java/top/fastsql/dao/BaseDAO.java:84

↓ 24 callersMethodtoString

()

src/main/java/top/fastsql/dto/ResultPage.java:53

↓ 22 callersMethodcheckNull

()

src/main/java/top/fastsql/SQL.java:1329

↓ 16 callersMethodcamelToUnderline

驼峰转下划线 camelToUnderline - camel_to_underline @param param 驼峰形式的字符串 @return 下划线形式的字符串

src/main/java/top/fastsql/util/StringExtUtils.java:15

↓ 14 callersMethoduseSql

使用sql字符串 @see SQL#str(String)

src/main/java/top/fastsql/SQL.java:114

↓ 13 callersMethodFROM

(String table)

src/main/java/top/fastsql/SQL.java:252

↓ 13 callersMethodSELECT

()

src/main/java/top/fastsql/SQL.java:154

↓ 10 callersMethodWHERE

()

src/main/java/top/fastsql/SQL.java:303

↓ 10 callersMethodgetFieldValue

获取对象的字段值 @param object 对象 @param fieldStr 对象属性的字符串名称

src/main/java/top/fastsql/util/EntityRefelectUtils.java:89

↓ 9 callersMethodqueryList

查询多行结果封装为一个对象列表 @param returnClassType Class<T>类型 T 可以为String/Integer/Long/Short/BigDecimal/BigInteger/Float/Double/Boolean或者任意DTO

src/main/java/top/fastsql/SQL.java:933

↓ 9 callersMethodqueryOne

查询单行结果封装为一个对象 @param returnClassType Class<T>类型 T 可以为 String/Integer/Long/Short/BigDecimal/BigInteger/Float/Double/Boole

src/main/java/top/fastsql/SQL.java:827

↓ 8 callersMethodsetDataSourceType

(DataSourceType dataSourceType)

src/main/java/top/fastsql/SQLFactory.java:127

↓ 7 callersMethodbeanParameter

(Object beanParam)

src/main/java/top/fastsql/SQL.java:791

↓ 7 callersMethodbuild

()

src/main/java/top/fastsql/SQL.java:633

↓ 7 callersMethodgetInClause

根据列表获取IN语句 eg. 1,2,3 返回（1,2,3） eg. "1","q","u" 返回（'1','q','u'） @param collection 列表 @return IN语句

src/main/java/top/fastsql/util/FastSqlUtils.java:25

↓ 7 callersMethodgetString

(String key)

src/main/java/top/fastsql/dto/RowMap.java:32

↓ 7 callersMethodsql

创建一个SQL实例

src/main/java/top/fastsql/SQLFactory.java:45

↓ 7 callersMethodupdate

执行INSERT/UPDATE/DELETE语句 @return 返回更新的行数

src/main/java/top/fastsql/SQL.java:1130

↓ 7 callersMethodvarParameter

可变参数，替换Sql中使用?占位符 @param vars 参数列表

src/main/java/top/fastsql/SQL.java:801

↓ 6 callersMethodgetSmartCountSQL

获取统计数量的sql @param sql origin sql

src/main/java/top/fastsql/util/PageUtils.java:38

↓ 6 callersMethodparameter

(SqlParameterSource sqlParameterSource)

src/main/java/top/fastsql/SQL.java:665

↓ 5 callersMethodINSERT_INTO

(String table, String... columns)

src/main/java/top/fastsql/SQL.java:204

↓ 5 callersMethodVALUES

(String... columnValues)

src/main/java/top/fastsql/SQL.java:221

↓ 5 callersMethodsetDataSource

(DataSource dataSource)

src/main/java/top/fastsql/SQLFactory.java:119

↓ 5 callersMethodupdate

全更新 null值在数据库中设置为null

src/main/java/top/fastsql/dao/BaseDAO.java:307

↓ 4 callersMethodafterInsert

(E entity, int count)

src/main/java/top/fastsql/dao/BaseDAO.java:638

↓ 4 callersMethodappendNoQuotes

(StringBuilder builder, Object value)

src/main/java/top/fastsql/util/FastSqlUtils.java:75

↓ 4 callersMethodbeforeInsert

(E entity)

src/main/java/top/fastsql/dao/BaseDAO.java:635

↓ 4 callersMethodcreateSQL

@see SQLFactory#createSQL()

src/main/java/top/fastsql/SQLFactory.java:37

↓ 4 callersMethodgetConnection

()

src/main/java/top/fastsql/datasource/FastDataSource.java:28

↓ 4 callersMethodgetDataSource

()

src/main/java/top/fastsql/SQL.java:1323

↓ 4 callersMethodprocessSelectBody

处理selectBody去除Order by

src/main/java/top/fastsql/util/CountSqlParser.java:174

↓ 3 callersMethodSET

(String... columnEqValue)

src/main/java/top/fastsql/SQL.java:240

↓ 3 callersMethodUPDATE

(String table)

src/main/java/top/fastsql/SQL.java:235

↓ 3 callersMethodafterUpdate

(E entity, int count)

src/main/java/top/fastsql/dao/BaseDAO.java:647

↓ 3 callersMethodbeforeUpdate

(E entity)

src/main/java/top/fastsql/dao/BaseDAO.java:644

↓ 3 callersMethodgetRowMapper

(Class<T> returnClassType)

src/main/java/top/fastsql/SQL.java:1336

↓ 3 callersMethodgetRowsSQL

(String sql, int pageNumber, int perPageSize, DataSourceType dataSourceType)

src/main/java/top/fastsql/util/PageUtils.java:12

↓ 3 callersMethodgetSimpleCountSql

获取普通的Count-sql @param sql 原查询sql @return 返回count查询sql

src/main/java/top/fastsql/util/CountSqlParser.java:100

↓ 3 callersMethodgetValue

(String key, Class<CLS> cls)

src/main/java/top/fastsql/dto/RowMap.java:64

↓ 3 callersMethodifTrue

(boolean bool, Consumer<SQL> sQLConsumer)

src/main/java/top/fastsql/SQL.java:1316

↓ 3 callersMethodqueryInteger

()

src/main/java/top/fastsql/SQL.java:851

↓ 3 callersMethodqueryPage

(String sql, int page, int perPage, SqlParameterSource paramSource, Row

src/main/java/top/fastsql/util/PageTemplate.java:25

↓ 2 callersMethodappendWithQuotes

(StringBuilder builder, Object value)

src/main/java/top/fastsql/util/FastSqlUtils.java:71

↓ 2 callersMethodbyType

(Object value)

src/main/java/top/fastsql/SQL.java:571

↓ 2 callersMethodcreateUseSimpleDateSource

(Driver driver, String url, String username, String password)

src/main/java/top/fastsql/SQLFactory.java:60

↓ 2 callersMethodgetCount

()

src/main/java/top/fastsql/dto/KeyHolderResult.java:19

↓ 2 callersMethodgetDate

(String key)

src/main/java/top/fastsql/dto/RowMap.java:52

↓ 2 callersMethodgetSqlFactory

()

src/main/java/top/fastsql/dao/BaseDAO.java:77

↓ 2 callersMethodgetStringByType

(Object value)

src/main/java/top/fastsql/SQL.java:581

↓ 2 callersMethodinitMetaData

初始化DAO元数据

src/main/java/top/fastsql/dao/BaseDAO.java:108

↓ 2 callersMethodinsert

插入对象中的值到数据库，null值在数据库中会设置为NULL

src/main/java/top/fastsql/dao/BaseDAO.java:186

↓ 2 callersMethodlistOf

(A... elements)

src/main/java/top/fastsql/util/FastSqlUtils.java:138

↓ 2 callersMethodmapItemsParameter

(String k1, Object v1)

src/main/java/top/fastsql/SQL.java:695

↓ 2 callersMethodorderByHashParameters

判断Orderby是否包含参数，有参数的不能去

src/main/java/top/fastsql/util/CountSqlParser.java:267

↓ 2 callersMethodpageThis

(int pageNumber, int perPageSize)

src/main/java/top/fastsql/SQL.java:642

↓ 2 callersMethodprocessFromItem

处理子查询

src/main/java/top/fastsql/util/CountSqlParser.java:233

↓ 2 callersMethodqueryMapList

查询多行结果封装为Map列表 @return Map数组

src/main/java/top/fastsql/SQL.java:994

↓ 2 callersMethodqueryPage

查询结果页 page 小于等于0 查询数量 perPage 小于等于 0 仅查询条数 @param page 第几页从1开始 @param perPage 每页几条最小为1 @param returnClassType 返回的结果类型 @return 返回

src/main/java/top/fastsql/SQL.java:1074

↓ 2 callersMethodsetDepId

(Integer depId)

src/test/java/top/fastsql/TestEntity.java:40

↓ 2 callersMethodtoLocalDate

java.util.Date -- java.time.LocalDate

src/main/java/top/fastsql/util/FastSqlUtils.java:159

↓ 2 callersMethodtoLocalDateTime

java.util.Date -- java.time.LocalDateTime

src/main/java/top/fastsql/util/FastSqlUtils.java:147

↓ 2 callersMethodtop

(int number)

src/main/java/top/fastsql/SQL.java:647

↓ 2 callersMethodunderlineToCamel

下划线转驼峰 underline_to_camel - underlineToCamel @param param 下划线形式的字符串 @return 驼峰形式的字符串

src/main/java/top/fastsql/util/StringExtUtils.java:44

↓ 2 callersMethodupdateForKey

(String... keyColumns)

src/main/java/top/fastsql/SQL.java:1145

↓ 2 callersMethoduseTemplateQueryOne

使用 JdbcTemplate 查询一个

src/main/java/top/fastsql/SQL.java:883

↓ 1 callersMethodAND

(String condition)

src/main/java/top/fastsql/SQL.java:330

↓ 1 callersMethodDELETE_FROM

(String table)

src/main/java/top/fastsql/SQL.java:198

↓ 1 callersMethodIN

()

src/main/java/top/fastsql/SQL.java:392

↓ 1 callersMethodIN_var

使用可变参数

src/main/java/top/fastsql/SQL.java:410

↓ 1 callersMethodaddMapParameterItem

(String key, Object value)

src/main/java/top/fastsql/SQL.java:741

↓ 1 callersMethodafterDelete

(ID id, int count)

src/main/java/top/fastsql/dao/BaseDAO.java:656

↓ 1 callersMethodbatchUpdateByMapParams

(List<Map<String, Object>> mapParamList)

src/main/java/top/fastsql/SQL.java:1175

↓ 1 callersMethodbeforeDelete

(ID id)

src/main/java/top/fastsql/dao/BaseDAO.java:653

↓ 1 callersMethodbothWildcard

返回源字符串的两端添加通配符后的字符串 @param source 源字符串 @return 源字符串的两端添加通配符后的字符串

src/main/java/top/fastsql/util/FastSqlUtils.java:133

↓ 1 callersMethodeq

Generate equal operator and append the param

src/main/java/top/fastsql/SQL.java:450

↓ 1 callersMethodextraOrderBy

extra order by and set default orderby to null @param selectBody

src/main/java/top/fastsql/util/OrderByParser.java:73

↓ 1 callersMethodgetAllFieldWithoutIdByClass

(Class cls)

src/main/java/top/fastsql/util/EntityRefelectUtils.java:167

↓ 1 callersMethodgetIdField

(Object object)

src/main/java/top/fastsql/util/EntityRefelectUtils.java:188

↓ 1 callersMethodgetNamedParameterJdbcTemplate

()

src/main/java/top/fastsql/SQL.java:60

↓ 1 callersMethodgetSmartCountSql

获取智能的countSql @param sql @return

src/main/java/top/fastsql/util/CountSqlParser.java:57

↓ 1 callersMethodgetTableNameFromEntityClass

获取指定实体类对应的表名 @param entityClass 实体类的类型令牌 @return 若指定的类中含有{@code javax.persistence.Table}注解，则返回注解的name字段的值

src/main/java/top/fastsql/util/EntityRefelectUtils.java:27

↓ 1 callersMethodgetType

get Class Type

src/main/java/top/fastsql/dto/RowMap.java:28

↓ 1 callersMethodisSimpleCount

是否可以用简单的count查询方式

src/main/java/top/fastsql/util/CountSqlParser.java:146

↓ 1 callersMethoditerator

()

src/main/java/top/fastsql/dto/ResultPage.java:58

↓ 1 callersMethodleftWildcard

返回源字符串的左端添加通配符后的字符串 @param source 源字符串 @return 源字符串的左端添加通配符后的字符串

src/main/java/top/fastsql/util/FastSqlUtils.java:113

↓ 1 callersMethodlt

(String value)

src/main/java/top/fastsql/SQL.java:491

↓ 1 callersMethodmemoryPage

内存分页 page 1开始 size 大于 0 @param list 列表

src/main/java/top/fastsql/util/FastSqlUtils.java:86

↓ 1 callersMethodmysql

@param pageNumber 页数，从第一页开始 @param perPageSize 每页条数，大于1

src/main/java/top/fastsql/util/PageUtils.java:47

↓ 1 callersMethodoracle

@param pageNumber 页数，从第一页开始 @param perPageSize 每页条数，大于1

src/main/java/top/fastsql/util/PageUtils.java:67

↓ 1 callersMethodpostgresql

@param pageNumber 页数，从第一页开始 @param perPageSize 每页条数，大于1

src/main/java/top/fastsql/util/PageUtils.java:57

↓ 1 callersMethodprocessPlainSelect

处理PlainSelect类型的selectBody

src/main/java/top/fastsql/util/CountSqlParser.java:200

↓ 1 callersMethodprocessWithItemsList

处理WithItem

src/main/java/top/fastsql/util/CountSqlParser.java:221

↓ 1 callersMethodqueryArrayList

查询多行结果封装为Object[]列表 @return Object[]列表

src/main/java/top/fastsql/SQL.java:1019

↓ 1 callersMethodqueryLocalDate

()

src/main/java/top/fastsql/SQL.java:867

↓ 1 callersMethodqueryLocalDateTime

()

src/main/java/top/fastsql/SQL.java:871

↓ 1 callersMethodqueryMap

查询单行结果封装为Map @return Map

src/main/java/top/fastsql/SQL.java:901

next →1–100 of 321, ranked by callers