mybatis3源码解析--操作数据库
2023-06-13 09:16:59 时间
<configuration>
<settings>
<setting name="useGeneratedKeys" value="true"/>
<setting name="mapUnderscoreToCamelCase" value="true"/>
<setting name="logImpl" value="STDOUT_LOGGING"/>
</settings>
<environments default="dev">
<environment id="dev">
<transactionManager type="JDBC">
<property name="" value=""/>
</transactionManager>
<dataSource type="UNPOOLED">
<property name="driver" value="org.hsqldb.jdbcDriver"/>
<property name="url" value="jdbc:hsqldb:mem:star"/>
<property name="username" value="sa"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper class="com.star.mybatis.UserMapper"/>
</mappers>
</configuration>
2、实体对象映射数据库表
@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
private int id;
private String createTime;
private String uname;
private String password;
private String nickName;
}
3、mapper对象
public interface UserMapper {
@Select("SELECT * FROM user")
List<User> getUsers();
}
4、执行sql
@Test
public void test1() {
Reader reader = Resources.getResourceAsReader("mybatis-config.xml");
SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
SqlSession sqlSession = sessionFactory.openSession();
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
List<User> users = userMapper.getUsers();
System.out.println(users);
}
-------------------------------------------------------------------------------------
Logging initialized using 'class org.apache.ibatis.logging.stdout.StdOutImpl' adapter.
Opening JDBC Connection
Setting autocommit to false on JDBC Connection [org.hsqldb.jdbc.JDBCConnection@79d8407f]
==> Preparing: SELECT * FROM user
==> Parameters:
<== Columns: ID, CREATE_TIME, UNAME, PASSWORD, NICK_NAME
<== Row: 0, 2022-11-11 10:10:10, star, 123456, star_nick
<== Row: 1, 2022-11-12 10:10:10, moon, admin, moon_nick
<== Total: 2
相关文章
- 全功能数据库管理工具-RazorSQL 10大版本发布
- SpringBoot数据库配置源码解析:自动配置内部实现解析
- 从零开始构建向量数据库:Milvus 的源码编译安装(一)
- Postgresql源码安装详解数据库
- 分析MySQL与PHP源码分析:窥视数据库的魔窟(mysqlphp源码)
- : dbnetOracle数据库架构之DBNET机器(oracle机器名)
- MySQL源码包:提升数据库性能的利器(mysql 源码包)
- ASP实现与MySQL数据库的连接(asp连接mysql源码)
- 6天玩转MySQL源码,尽览数据库开发新视界(6天玩转mysql源码)
- C语言如何连接Oracle数据库(c 怎么连 oracle)
- 利用C语言实现ATM自动取款机的Oracle数据库接口(c oracle atm)
- CDA提升Oracle数据库性能的新途径(cda oracle)
- 从mdb文件到MySQL实现数据库迁移(.mdb文件 mysql)
- 使用MySQL数据库的注意事项(mysql。长时间)
- MySQL解释器防幻读算法,用户并发修改数据时,请求统一锁释放防止幻读现象存在,保证数据库数据的一致性
- 如何在数据库中用好Transaction?
- 用PHP连接OracleforNT远程数据库