為您找到相關(guān)結(jié)果35,165個(gè)
getSQLinfo.vbs 獲得SQL數(shù)據(jù)/日志空間使用情況的腳本_vbs_腳本之家
CheckSQLData CheckSQLLOG '### GET SQL DATA SPACE USED, SPACE TOTAL, SPACE FREE 'Function checkSQL(strServer,strDB) in the future make it a function... Sub CheckSQLDATA Const adOpenDynamic = 1, adLockOptimistic = 3 Dim strQuery Dim objConnection, objRecordSet Dim strQueryResult, strQueryResult...
www.dbjr.com.cn/article/151...htm 2025-5-31
Go基于GORM 獲取當(dāng)前請(qǐng)求所執(zhí)行的 SQL 信息(思路詳解)_Golang_腳本之...
_ts, isExist := db.InstanceGet(startTime) if !isExist { return } ts, ok := _ts.(time.Time) if !ok { return } sql := db.Dialector.Explain(db.Statement.SQL.String(), db.Statement.Vars...) sqlInfo := new(trace.SQL) sqlInfo.Timestamp = time_parse.CSTLayoutString() sqlInfo....
www.dbjr.com.cn/article/2043...htm 2025-6-9
mybatis-plus saveOrUpdateBatch踩坑記錄_java_腳本之家
Object idVal = tableInfo.getPropertyValue(entity, keyProperty); // 當(dāng)主鍵存在時(shí),會(huì)執(zhí)行sqlSession.selectList(getSqlStatement(SqlMethod.SELECT_BY_ID), entity)查詢?cè)摋l記錄 returnStringUtils.checkValNull(idVal) || CollectionUtils.isEmpty(sqlSession.selectList(getSqlStatement(SqlMethod.SELECT_BY_ID), en...
www.dbjr.com.cn/program/3072734...htm 2025-6-6
SQL創(chuàng)建的幾種存儲(chǔ)過程_MsSql_腳本之家
SET @sql = 'select * from ' + @TblName + ' where ' + @TblAtr + '=' + @CmpStr EXEC (@sql) 表tbl_TeacherInfo Exec sp_getTeacherInfo 'tbl_TeacherInfo','TeaNo', '07417502' // 注意:像這樣的調(diào)用是錯(cuò)誤的 還原成查詢語句 select * from tbl_TeacherInfo where TeaNo = 07417502 之所以...
www.dbjr.com.cn/article/234...htm 2025-5-27
Mybatis插件PageHelper的實(shí)現(xiàn)原理詳解_java_腳本之家
System.out.println(pageInfo.getTotal()); 上述代碼首先調(diào)用了 PageHelper 的 startPage 方法,傳入了當(dāng)前頁碼數(shù)和每頁顯示的條數(shù),然后調(diào)用了 UserDao 的 selectUserList() 方法查詢用戶列表。最后通過 PageInfo 獲取分頁信息,包括總記錄數(shù)、當(dāng)前頁碼數(shù)、每頁顯示的條數(shù)等信息。
www.dbjr.com.cn/program/287484m...htm 2025-6-8
MyBatis-plus批量插入的通用方法使用_java_腳本之家
String columnScript = LEFT_BRACKET + insertSqlColumn.substring(0, insertSqlColumn.length() - 1) + RIGHT_BRACKET; String insertSqlProperty = tableInfo.getKeyInsertSqlProperty(ENTITY_DOT, false) + this.filterTableFieldInfo(fieldList, predicate, i -> i.getInsertSqlProperty(ENTITY_DOT), EMPTY);...
www.dbjr.com.cn/article/2805...htm 2025-5-25
SpringBoot整合Mybatis-plus的具體使用_java_腳本之家
//等價(jià)SQL: SELECT id,name,age,skill,evaluate,fraction FROM user_info WHERE skill LIKE '%畫%' ORDER BY age DESC QueryWrapper<UserInfoEntity> queryWrapper3 = new QueryWrapper<>(); queryWrapper3.lambda().like(UserInfoEntity::getSkill,"畫"); queryWrapper3.lambda().orderByDesc(UserInfoEntity::get...
www.dbjr.com.cn/article/2450...htm 2025-5-18
Android XUtils3框架的基本使用方法(二)_Android_腳本之家
Cursor execQuery(SqlInfo sqlInfo) throws DbException; Cursor execQuery(String sql) throws DbException; } 通過DbManager這個(gè)類我們知道主要它做了以下幾件事情: 1.getDaoConfig 獲取數(shù)據(jù)庫的配置信息 2.getDatabase 獲取數(shù)據(jù)庫實(shí)例 3.saveBindingId saveOrUpdate save 插入數(shù)據(jù)的3個(gè)方法(保存數(shù)據(jù)) 4.repl...
www.dbjr.com.cn/article/897...htm 2025-5-20
怎樣提高mybatis-plus中saveBatch方法的效率_java_腳本之家
Object idVal = tableInfo.getPropertyValue(entity, keyProperty); // 當(dāng)主鍵存在時(shí),會(huì)執(zhí)行sqlSession.selectList(getSqlStatement(SqlMethod.SELECT_BY_ID), entity)查詢?cè)摋l記錄 returnStringUtils.checkValNull(idVal) || CollectionUtils.isEmpty(sqlSession.selectList(getSqlStatement(SqlMethod.SELECT_BY_ID), en...
www.dbjr.com.cn/program/2921461...htm 2025-6-9