Open jj023721 opened 10 months ago
以下是控制台输入,没看到报错,求解答
Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5fc4381c] was not registered for synchronization because synchronization is not active JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@73497e5b] will not be managed by Spring ==> Preparing: SELECT id,username,password,name,gender,id_no,phone,address,status,create_by,create_time,update_by,update_time FROM user WHERE (username = ?) ==> Parameters: hamster(String) <== Columns: id, username, password, name, gender, id_no, phone, address, status, create_by, create_time, update_by, update_time <== Row: 1, hamster, $2a$10$3gpgu0XGV60V6oJEpHiAtOvuv1/7BZDVCEG.7f9mwkGXmB0d51wxu, 管理员-鸢十六, 1, 510902200308024534, 15882043063, 四川省南充市顺庆区西南石油大学, 0, null, 2022-12-26 00:00:00, 1, 2023-03-14 08:45:29 <== Total: 1 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5fc4381c] Creating a new SqlSession Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@553c536c] JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@73497e5b] will be managed by Spring ==> Preparing: select distinct r.id, r.name, r.key, r.status, r.create_by, r.create_time, r.update_by, r.update_time, r.remark from role r left join user_role ur on ur.rid = r.id where r.status = '0' and ur.status = '0' and ur.uid = ? ==> Parameters: 1(Long) <== Columns: id, name, key, status, create_by, create_time, update_by, update_time, remark <== Row: 1, 系统管理员, admin, 0, null, 2022-12-26 00:00:45, null, 2023-01-04 13:43:44, 最高权限,不可编辑修改 <== Total: 1 Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@553c536c] Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@553c536c] from current transaction ==> Preparing: SELECT p.key FROM permission p LEFT JOIN role_permission rp on p.id = rp.pid LEFT JOIN user_role ur ON ur.rid = rp.rid AND ur.uid = ? WHERE p.status = 0 ==> Parameters: 1(String) <== Columns: key <== Row: sys:board <== Row: sys:board <== Row: sys:board:data <== Row: sys:board:data <== Row: sys:manage <== Row: sys:field <== Row: user:manage <== Row: role:manage <== Row: perms:manage <== Row: sys:user:insert <== Row: sys:user:update <== Row: sys:user:delete <== Row: sys:user:role <== Row: sys:role:insert <== Row: sys:role:update <== Row: sys:role:delete <== Row: sys:role:perms <== Row: sys:perm:insert <== Row: sys:perms:delete <== Row: co:manage <== Row: vehicle:manage <== Row: vehicle:manage <== Row: wh:manage <== Row: cargo:manage <== Row: cargo:type <== Row: trans:manage <== Row: trans:manage <== Row: finance:manage <== Total: 28 Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@553c536c] Transaction synchronization committing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@553c536c] Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@553c536c] Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@553c536c] Creating a new SqlSession Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@701128e0] JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@73497e5b] will be managed by Spring ==> Preparing: SELECT id,username,password,name,gender,id_no,phone,address,status,create_by,create_time,update_by,update_time FROM user WHERE id=? ==> Parameters: 1(Long) <== Columns: id, username, password, name, gender, id_no, phone, address, status, create_by, create_time, update_by, update_time <== Row: 1, hamster, $2a$10$3gpgu0XGV60V6oJEpHiAtOvuv1/7BZDVCEG.7f9mwkGXmB0d51wxu, 管理员-鸢十六, 1, 510902200308024534, 15882043063, 四川省南充市顺庆区西南石油大学, 0, null, 2022-12-26 00:00:00, 1, 2023-03-14 08:45:29 <== Total: 1 Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@701128e0] Transaction synchronization committing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@701128e0] Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@701128e0] Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@701128e0]
name
status
key
role
解决了吗
你好,这里是蒋永梁,你的邮件已收到!
以下是控制台输入,没看到报错,求解答
Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5fc4381c] was not registered for synchronization because synchronization is not active JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@73497e5b] will not be managed by Spring ==> Preparing: SELECT id,username,password,
name
,gender,id_no,phone,address,status
,create_by,create_time,update_by,update_time FROM user WHERE (username = ?) ==> Parameters: hamster(String) <== Columns: id, username, password, name, gender, id_no, phone, address, status, create_by, create_time, update_by, update_time <== Row: 1, hamster, $2a$10$3gpgu0XGV60V6oJEpHiAtOvuv1/7BZDVCEG.7f9mwkGXmB0d51wxu, 管理员-鸢十六, 1, 510902200308024534, 15882043063, 四川省南充市顺庆区西南石油大学, 0, null, 2022-12-26 00:00:00, 1, 2023-03-14 08:45:29 <== Total: 1 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5fc4381c] Creating a new SqlSession Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@553c536c] JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@73497e5b] will be managed by Spring ==> Preparing: select distinct r.id, r.name
, r.key
, r.status
, r.create_by, r.create_time, r.update_by, r.update_time, r.remark fromrole
r left join user_role ur on ur.rid = r.id where r.status = '0' and ur.status = '0' and ur.uid = ? ==> Parameters: 1(Long) <== Columns: id, name, key, status, create_by, create_time, update_by, update_time, remark <== Row: 1, 系统管理员, admin, 0, null, 2022-12-26 00:00:45, null, 2023-01-04 13:43:44, 最高权限,不可编辑修改 <== Total: 1 Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@553c536c] Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@553c536c] from current transaction ==> Preparing: SELECT p.key
FROM permission p LEFT JOIN role_permission rp on p.id = rp.pid LEFT JOIN user_role ur ON ur.rid = rp.rid AND ur.uid = ? WHERE p.status = 0 ==> Parameters: 1(String) <== Columns: key <== Row: sys:board <== Row: sys:board <== Row: sys:board:data <== Row: sys:board:data <== Row: sys:manage <== Row: sys:field <== Row: user:manage <== Row: role:manage <== Row: perms:manage <== Row: sys:user:insert <== Row: sys:user:update <== Row: sys:user:delete <== Row: sys:user:role <== Row: sys:role:insert <== Row: sys:role:update <== Row: sys:role:delete <== Row: sys:role:perms <== Row: sys:perm:insert <== Row: sys:perms:delete <== Row: co:manage <== Row: vehicle:manage <== Row: vehicle:manage <== Row: wh:manage <== Row: cargo:manage <== Row: cargo:type <== Row: trans:manage <== Row: trans:manage <== Row: finance:manage <== Total: 28 Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@553c536c] Transaction synchronization committing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@553c536c] Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@553c536c] Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@553c536c] Creating a new SqlSession Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@701128e0] JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@73497e5b] will be managed by Spring ==> Preparing: SELECT id,username,password,name
,gender,id_no,phone,address,status
,create_by,create_time,update_by,update_time FROM user WHERE id=? ==> Parameters: 1(Long) <== Columns: id, username, password, name, gender, id_no, phone, address, status, create_by, create_time, update_by, update_time <== Row: 1, hamster, $2a$10$3gpgu0XGV60V6oJEpHiAtOvuv1/7BZDVCEG.7f9mwkGXmB0d51wxu, 管理员-鸢十六, 1, 510902200308024534, 15882043063, 四川省南充市顺庆区西南石油大学, 0, null, 2022-12-26 00:00:00, 1, 2023-03-14 08:45:29 <== Total: 1 Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@701128e0] Transaction synchronization committing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@701128e0] Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@701128e0] Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@701128e0]