MyBatis 5.Java API
来源:互联网 发布:迅捷数据恢复软件 编辑:程序博客网 时间:2024/06/02 10:53
SqlSession
String resource = "org/mybatis/builder/mybatis-config.xml";InputStream inputStream = Resources.getResourceAsStream(resource);SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();SqlSessionFactory factory = builder.build(inputStream);
URL getResourceURL(String resource)URL getResourceURL(ClassLoader loader, String resource)InputStream getResourceAsStream(String resource)InputStream getResourceAsStream(ClassLoader loader, String resource)Properties getResourceAsProperties(String resource)Properties getResourceAsProperties(ClassLoader loader, String resource)Reader getResourceAsReader(String resource)Reader getResourceAsReader(ClassLoader loader, String resource)File getResourceAsFile(String resource)File getResourceAsFile(ClassLoader loader, String resource)InputStream getUrlAsStream(String urlString)Reader getUrlAsReader(String urlString)Properties getUrlAsProperties(String urlString)Class classForName(String className)
手动创建过程
DataSource dataSource = BaseDataTest.createBlogDataSource();TransactionFactory transactionFactory = new JdbcTransactionFactory();Environment environment = new Environment("development", transactionFactory, dataSource);Configuration configuration = new Configuration(environment);configuration.setLazyLoadingEnabled(true);configuration.setEnhancementEnabled(true);configuration.getTypeAliasRegistry().registerAlias(Blog.class);configuration.getTypeAliasRegistry().registerAlias(Post.class);configuration.getTypeAliasRegistry().registerAlias(Author.class);configuration.addMapper(BoundBlogMapper.class);configuration.addMapper(BoundAuthorMapper.class);SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();SqlSessionFactory factory = builder.build(configuration);
SqlSessionFactory
SqlSessionFactory 有六个方法可以用来创建 SqlSession 实例。通常来说,如何决定是你 选择下面这些方法时:
- Transaction (事务): 你想为 session 使用事务或者使用自动提交(通常意味着很多 数据库和/或 JDBC 驱动没有事务)?
- Connection (连接): 你想 MyBatis 获得来自配置的数据源的连接还是提供你自己
- Execution (执行): 你想 MyBatis 复用预处理语句和/或批量更新语句(包括插入和 删除)?
SqlSession openSession()SqlSession openSession(boolean autoCommit)SqlSession openSession(Connection connection)SqlSession openSession(TransactionIsolationLevel level)SqlSession openSession(ExecutorType execType,TransactionIsolationLevel level)SqlSession openSession(ExecutorType execType)SqlSession openSession(ExecutorType execType, boolean autoCommit)SqlSession openSession(ExecutorType execType, Connection connection)Configuration getConfiguration();
SqlSession
语句执行方法
<T> T selectOne(String statement, Object parameter)<E> List<E> selectList(String statement, Object parameter)<K,V> Map<K,V> selectMap(String statement, Object parameter, String mapKey)int insert(String statement, Object parameter)int update(String statement, Object parameter)int delete(String statement, Object parameter)
他们分别有不要参数对象的重载
<T> T selectOne(String statement)<E> List<E> selectList(String statement)<K,V> Map<K,V> selectMap(String statement, String mapKey)int insert(String statement)int update(String statement)int delete(String statement)
查询分页的高级方法
<E> List<E> selectList (String statement, Object parameter, RowBounds rowBounds)<K,V> Map<K,V> selectMap(String statement, Object parameter, String mapKey, RowBounds rowbounds)void select (String statement, Object parameter, ResultHandler<T> handler)void select (String statement, Object parameter, RowBounds rowBounds, ResultHandler<T> handler)
int offset = 100;int limit = 25;RowBounds rowBounds = new RowBounds(offset, limit);
0 0
- MyBatis 5.Java API
- MyBatis Java API
- mybatis之JAVA API
- Mybatis--Java API
- MyBatis基于Java API配置
- 使用Java API配置MyBatis
- mybatis-Java API(六)
- Github Mybatis深入学习之Java API
- Github Mybatis深入学习之Java API .
- mybatis系列-Java API(五)
- Mybatis API 使用指南
- MyBatis的API
- Mybatis 学习之API
- Mybatis开发工具API
- MyBatis核心API测试
- Mybatis(四)-用API来配置MyBatis
- 5.Java常用API 1
- ElasticSearch 5.x Java API
- ANTLR快餐教程(2)
- iOS导航栏pop的时候出现短暂蓝色
- 获取文件占用进程信息
- 纯
- 贝尔曼方程(Bellman Equation)
- MyBatis 5.Java API
- 结构体中的字节对齐问题
- FishC笔记—10 讲 列表:一个打了激素的数组
- java8 汇聚操作之reduce、collect用法
- 泛型和枚举
- Java面试整理 关于final、static、abstract
- navigationbar的细节
- 逻辑回归原理小结
- 紫书搜索 习题7-7 UVA