@TestpublicvoidtestPage(){//设置分页参数Page<User> page =newPage<>(2,3);//Preparing: SELECT uid AS id,username AS name,//age,email,is_deleted FROM t_user WHERE is_deleted=0 LIMIT ?,?
userMapper.selectPage(page,null);//获取分页数据List<User> list = page.getRecords();
list.forEach(System.out::println);System.out.println();System.out.println("当前页:"+page.getCurrent());System.out.println("每页显示的条数:"+page.getSize());System.out.println("总记录数:"+page.getTotal());System.out.println("总页数:"+page.getPages());System.out.println("是否有上一页:"+page.hasPrevious());System.out.println("是否有下一页:"+page.hasNext());}
Creating a newSqlSessionSqlSession[org.apache.ibatis.session.defaults.DefaultSqlSession@15dc339f] was not registered for synchronization because synchronization is not active
2023-02-1409:42:36.662INFO21336---[ main]com.zaxxer.hikari.HikariDataSource:HikariPool-1-Starting...2023-02-1409:42:36.842INFO21336---[ main]com.zaxxer.hikari.HikariDataSource:HikariPool-1-Start completed.JDBCConnection[HikariProxyConnection@695085082 wrapping com.mysql.cj.jdbc.ConnectionImpl@59cda16e] will not be managed by Spring==>Preparing:SELECT id,name,price,version FROM t_product WHERE id=?==>Parameters:1(Long)<==Columns: id, name, price, version
<==Row:1, 新华字典,100,1<==Total:1Closing non transactional SqlSession[org.apache.ibatis.session.defaults.DefaultSqlSession@15dc339f]Creating a newSqlSessionSqlSession[org.apache.ibatis.session.defaults.DefaultSqlSession@10b1a751] was not registered for synchronization because synchronization is not active
JDBCConnection[HikariProxyConnection@1406114969 wrapping com.mysql.cj.jdbc.ConnectionImpl@59cda16e] will not be managed by Spring==>Preparing:SELECT id,name,price,version FROM t_product WHERE id=?==>Parameters:1(Long)<==Columns: id, name, price, version
<==Row:1, 新华字典,100,1<==Total:1Closing non transactional SqlSession[org.apache.ibatis.session.defaults.DefaultSqlSession@10b1a751]Creating a newSqlSessionSqlSession[org.apache.ibatis.session.defaults.DefaultSqlSession@5a1c3cb4] was not registered for synchronization because synchronization is not active
JDBCConnection[HikariProxyConnection@709841971 wrapping com.mysql.cj.jdbc.ConnectionImpl@59cda16e] will not be managed by Spring==>Preparing:UPDATE t_product SET name=?, price=?, version=?WHERE id=?AND version=?==>Parameters: 新华字典(String),150(Integer),2(Integer),1(Long),1(Integer)<==Updates:1Closing non transactional SqlSession[org.apache.ibatis.session.defaults.DefaultSqlSession@5a1c3cb4]
小李修改的结果:1Creating a newSqlSessionSqlSession[org.apache.ibatis.session.defaults.DefaultSqlSession@7f5538a1] was not registered for synchronization because synchronization is not active
JDBCConnection[HikariProxyConnection@1929218620 wrapping com.mysql.cj.jdbc.ConnectionImpl@59cda16e] will not be managed by Spring==>Preparing:UPDATE t_product SET name=?, price=?, version=?WHERE id=?AND version=?==>Parameters: 新华字典(String),70(Integer),2(Integer),1(Long),1(Integer)<==Updates:0Closing non transactional SqlSession[org.apache.ibatis.session.defaults.DefaultSqlSession@7f5538a1]
小王修改的结果:0Creating a newSqlSessionSqlSession[org.apache.ibatis.session.defaults.DefaultSqlSession@34780cd9] was not registered for synchronization because synchronization is not active
JDBCConnection[HikariProxyConnection@1648278215 wrapping com.mysql.cj.jdbc.ConnectionImpl@59cda16e] will not be managed by Spring==>Preparing:SELECT id,name,price,version FROM t_product WHERE id=?==>Parameters:1(Long)<==Columns: id, name, price, version
<==Row:1, 新华字典,150,2<==Total:1Closing non transactional SqlSession[org.apache.ibatis.session.defaults.DefaultSqlSession@34780cd9]Creating a newSqlSessionSqlSession[org.apache.ibatis.session.defaults.DefaultSqlSession@1ab5f08a] was not registered for synchronization because synchronization is not active
JDBCConnection[HikariProxyConnection@1860118977 wrapping com.mysql.cj.jdbc.ConnectionImpl@59cda16e] will not be managed by Spring==>Preparing:UPDATE t_product SET name=?, price=?, version=?WHERE id=?AND version=?==>Parameters: 新华字典(String),120(Integer),3(Integer),1(Long),2(Integer)<==Updates:1Closing non transactional SqlSession[org.apache.ibatis.session.defaults.DefaultSqlSession@1ab5f08a]
小王修改重试的结果:1Creating a newSqlSessionSqlSession[org.apache.ibatis.session.defaults.DefaultSqlSession@66b59b7d] was not registered for synchronization because synchronization is not active
JDBCConnection[HikariProxyConnection@1395725953 wrapping com.mysql.cj.jdbc.ConnectionImpl@59cda16e] will not be managed by Spring==>Preparing:SELECT id,name,price,version FROM t_product WHERE id=?==>Parameters:1(Long)<==Columns: id, name, price, version
<==Row:1, 新华字典,120,3<==Total:1Closing non transactional SqlSession[org.apache.ibatis.session.defaults.DefaultSqlSession@66b59b7d]
老板看价格:120