eclipse中使用注解解决Oracle过程的有游标的方法： 有resultMap异常等问题

最新推荐文章于 2023-10-14 22:30:33 发布
最新推荐文章于 2023-10-14 22:30:33 发布
阅读量913 收藏 1
点赞数 1
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_43532158/article/details/95320159
版权

在oracle中

Oracle过程的有游标的方法:

create or replace package mypackage1 as
       type t_cursor is ref cursor;
end mypackage1;

create or replace procedure proc_test6(page in number,sizes in number,p_cur out mypackage1.t_cursor,zpage out number,zrecord out number)
as 
begin
  select count(*) into zrecord from users_info;
  select Ceil(zrecord/sizes) into zpage from dual;
  open  p_cur for 'select * from(select rownum rn,u.* from zhaoliying.users_info u where rownum<='||page*sizes||') where rn>'||sizes*(page-1);   
end;

–在eclipse中

接口中的配置:
package com.wj.mapper;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.One;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.ResultMap;
import org.apache.ibatis.annotations.ResultType;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.apache.ibatis.mapping.StatementType;
import org.apache.ibatis.type.JdbcType;

import com.wj.entity.User;

public interface IUserMapper {
	//设置resultMap
	@Results(id="rm" ,value={
		@Result(id=true,column="userid",property="id"),
		@Result(column="uname",property="name"),
		@Result(column="sex",property="sex"),
		@Result(column="age",property="age"),
		@Result(column="birthday",property="birth"),
	})
	//设置返回
	@ResultType(com.wj.entity.User.class)
	@Options(statementType=StatementType.CALLABLE)
	@Select({"call proc_test6(#{page,mode=IN,jdbcType=INTEGER},
	#{sizes,mode=IN,jdbcType=INTEGER},
	//重点
	**#{p_cur,mode=OUT,jdbcType=CURSOR,resultMap=rm},**
	#{zpage,mode=OUT,jdbcType=INTEGER},
	#{zrecord,mode=OUT,jdbcType=INTEGER})"
	})
	public void testProc(Map map);
}

测试类：main中

Map map=new HashMap();
			map.put("page", 1);
			map.put("sizes", 3);
			us.testProc(map);
			List<User> rs=(List<User>)map.get("p_cur");
			for (User user : rs) {
				System.out.println(user.getName());
			}
			System.out.println("-----------------------");
			System.out.println(map.get("zpage"));
			System.out.println(map.get("zrecord"));

如何没有@ResultType(com.wj.entity.User.class)
异常:

Exception in thread "main" org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.executor.ExecutorException: No constructor found in void matching [java.math.BigDecimal, java.math.BigDecimal, java.lang.String, java.math.BigDecimal, java.lang.String, java.sql.Timestamp, java.math.BigDecimal]
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
	at com.sun.proxy.$Proxy18.selectOne(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:166)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:82)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
	at com.sun.proxy.$Proxy26.testProc(Unknown Source)
	at com.wj.service.UserServiceImpl.testProc(UserServiceImpl.java:63)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:338)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:197)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
	at com.sun.proxy.$Proxy31.testProc(Unknown Source)
	at com.wj.test.Test.main(Test.java:56)
Caused by: org.apache.ibatis.executor.ExecutorException: No constructor found in void matching [java.math.BigDecimal, java.math.BigDecimal, java.lang.String, java.math.BigDecimal, java.lang.String, java.sql.Timestamp, java.math.BigDecimal]
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.createByConstructorSignature(DefaultResultSetHandler.java:664)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.createResultObject(DefaultResultSetHandler.java:617)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.createResultObject(DefaultResultSetHandler.java:590)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getRowValue(DefaultResultSetHandler.java:392)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValuesForSimpleResultMap(DefaultResultSetHandler.java:351)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValues(DefaultResultSetHandler.java:326)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRefCursorOutputParameter(DefaultResultSetHandler.java:167)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleOutputParameters(DefaultResultSetHandler.java:149)
	at org.apache.ibatis.executor.statement.CallableStatementHandler.query(CallableStatementHandler.java:69)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:77)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)
	... 19 more

如果没有**#{p_cur,mode=OUT,jdbcType=CURSOR,resultMap=rm},**中没有resultMap=rm；
异常:

org.apache.ibatis.builder.BuilderException: Could not find value method on SQL annotation.  Cause: java.lang.IllegalStateException: Missing resultmap in property 'p_cur'.  Parameters of type java.sql.ResultSet require a resultmap.
	at org.apache.ibatis.builder.annotation.MapperAnnotationBuilder.getSqlSourceFromAnnotations(MapperAnnotationBuilder.java:472)
	at org.apache.ibatis.builder.annotation.MapperAnnotationBuilder.parseStatement(MapperAnnotationBuilder.java:289)
	at org.apache.ibatis.builder.annotation.MapperAnnotationBuilder.parse(MapperAnnotationBuilder.java:134)
	at org.apache.ibatis.binding.MapperRegistry.addMapper(MapperRegistry.java:72)
	at org.apache.ibatis.session.Configuration.addMapper(Configuration.java:741)
	at org.mybatis.spring.mapper.MapperFactoryBean.checkDaoConfig(MapperFactoryBean.java:80)
	at org.springframework.dao.support.DaoSupport.afterPropertiesSet(DaoSupport.java:44)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1769)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1706)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:583)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:502)
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:312)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:310)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200)
	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:251)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1065)
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:584)
	at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:91)
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:373)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1344)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:502)
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:312)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:310)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:761)
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:868)
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:549)
	at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:144)
	at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:85)
	at com.wj.test.Test.main(Test.java:21)
Caused by: java.lang.IllegalStateException: Missing resultmap in property 'p_cur'.  Parameters of type java.sql.ResultSet require a resultmap.
	at org.apache.ibatis.mapping.ParameterMapping$Builder.validate(ParameterMapping.java:112)
	at org.apache.ibatis.mapping.ParameterMapping$Builder.build(ParameterMapping.java:104)
	at org.apache.ibatis.builder.SqlSourceBuilder$ParameterMappingTokenHandler.buildParameterMapping(SqlSourceBuilder.java:123)
	at org.apache.ibatis.builder.SqlSourceBuilder$ParameterMappingTokenHandler.handleToken(SqlSourceBuilder.java:67)
	at org.apache.ibatis.parsing.GenericTokenParser.parse(GenericTokenParser.java:78)
	at org.apache.ibatis.builder.SqlSourceBuilder.parse(SqlSourceBuilder.java:45)
	at org.apache.ibatis.scripting.defaults.RawSqlSource.<init>(RawSqlSource.java:46)
	at org.apache.ibatis.scripting.xmltags.XMLLanguageDriver.createSqlSource(XMLLanguageDriver.java:60)
	at org.apache.ibatis.builder.annotation.MapperAnnotationBuilder.buildSqlSourceFromStrings(MapperAnnotationBuilder.java:482)
	at org.apache.ibatis.builder.annotation.MapperAnnotationBuilder.getSqlSourceFromAnnotations(MapperAnnotationBuilder.java:465)
	... 33 more

七月 10, 2019 12:23:39 下午 org.springframework.context.support.AbstractApplicationContext refresh
警告: Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'userService': Unsatisfied dependency expressed through field 'userMapper'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'IUserMapper' defined in file [E:\java1\java培训\SSM\MyBatis\demo\mybatis_spring_mysql\target\classes\com\wj\mapper\IUserMapper.class]: Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: org.apache.ibatis.builder.BuilderException: Could not find value method on SQL annotation.  Cause: java.lang.IllegalStateException: Missing resultmap in property 'p_cur'.  Parameters of type java.sql.ResultSet require a resultmap.
Exception in thread "main" org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'userService': Unsatisfied dependency expressed through field 'userMapper'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'IUserMapper' defined in file [E:\java1\java培训\SSM\MyBatis\demo\mybatis_spring_mysql\target\classes\com\wj\mapper\IUserMapper.class]: Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: org.apache.ibatis.builder.BuilderException: Could not find value method on SQL annotation.  Cause: java.lang.IllegalStateException: Missing resultmap in property 'p_cur'.  Parameters of type java.sql.ResultSet require a resultmap.
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:587)
	at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:91)
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:373)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1344)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:502)
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:312)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:310)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:761)
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:868)
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:549)
	at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:144)
	at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:85)
	at com.wj.test.Test.main(Test.java:21)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'IUserMapper' defined in file [E:\java1\java培训\SSM\MyBatis\demo\mybatis_spring_mysql\target\classes\com\wj\mapper\IUserMapper.class]: Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: org.apache.ibatis.builder.BuilderException: Could not find value method on SQL annotation.  Cause: java.lang.IllegalStateException: Missing resultmap in property 'p_cur'.  Parameters of type java.sql.ResultSet require a resultmap.
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1710)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:583)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:502)
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:312)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:310)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200)
	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:251)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1065)
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:584)
	... 15 more
Caused by: java.lang.IllegalArgumentException: org.apache.ibatis.builder.BuilderException: Could not find value method on SQL annotation.  Cause: java.lang.IllegalStateException: Missing resultmap in property 'p_cur'.  Parameters of type java.sql.ResultSet require a resultmap.
	at org.mybatis.spring.mapper.MapperFactoryBean.checkDaoConfig(MapperFactoryBean.java:83)
	at org.springframework.dao.support.DaoSupport.afterPropertiesSet(DaoSupport.java:44)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1769)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1706)
	... 25 more
Caused by: org.apache.ibatis.builder.BuilderException: Could not find value method on SQL annotation.  Cause: java.lang.IllegalStateException: Missing resultmap in property 'p_cur'.  Parameters of type java.sql.ResultSet require a resultmap.
	at org.apache.ibatis.builder.annotation.MapperAnnotationBuilder.getSqlSourceFromAnnotations(MapperAnnotationBuilder.java:472)
	at org.apache.ibatis.builder.annotation.MapperAnnotationBuilder.parseStatement(MapperAnnotationBuilder.java:289)
	at org.apache.ibatis.builder.annotation.MapperAnnotationBuilder.parse(MapperAnnotationBuilder.java:134)
	at org.apache.ibatis.binding.MapperRegistry.addMapper(MapperRegistry.java:72)
	at org.apache.ibatis.session.Configuration.addMapper(Configuration.java:741)
	at org.mybatis.spring.mapper.MapperFactoryBean.checkDaoConfig(MapperFactoryBean.java:80)
	... 28 more
Caused by: java.lang.IllegalStateException: Missing resultmap in property 'p_cur'.  Parameters of type java.sql.ResultSet require a resultmap.
	at org.apache.ibatis.mapping.ParameterMapping$Builder.validate(ParameterMapping.java:112)
	at org.apache.ibatis.mapping.ParameterMapping$Builder.build(ParameterMapping.java:104)
	at org.apache.ibatis.builder.SqlSourceBuilder$ParameterMappingTokenHandler.buildParameterMapping(SqlSourceBuilder.java:123)
	at org.apache.ibatis.builder.SqlSourceBuilder$ParameterMappingTokenHandler.handleToken(SqlSourceBuilder.java:67)
	at org.apache.ibatis.parsing.GenericTokenParser.parse(GenericTokenParser.java:78)
	at org.apache.ibatis.builder.SqlSourceBuilder.parse(SqlSourceBuilder.java:45)
	at org.apache.ibatis.scripting.defaults.RawSqlSource.<init>(RawSqlSource.java:46)
	at org.apache.ibatis.scripting.xmltags.XMLLanguageDriver.createSqlSource(XMLLanguageDriver.java:60)
	at org.apache.ibatis.builder.annotation.MapperAnnotationBuilder.buildSqlSourceFromStrings(MapperAnnotationBuilder.java:482)
	at org.apache.ibatis.builder.annotation.MapperAnnotationBuilder.getSqlSourceFromAnnotations(MapperAnnotationBuilder.java:465)
	... 33 more
weixin_43532158
关注
  • 1
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
四、Mybatis 执行流程全解析
org_hjh的博客
07-13 106
知识点： 执行流程解析 Mybatis 插件开发 一、执行流程解析 1. 配置文件解析 configuration 理解解析流程之前先回顾一下mybatis中配置文件的结构： mybatis-config.xml <configuration> <properties/> <settting/> <typeHandlers/> &...
mybatis动态SQL时间比较遇到的坑
qq_42896477的博客
08-19 954
原动态SQL @Select("<script>" +"select s.* ,t.fShortName currencyName ,o.orderNum ,o.buyNum thePrincipa from fvirtualcointype t " +" INNER JOIN shouyijilu s" +" O...
Spring Mybatis详解
banketree
05-03 2222
介绍MyBatis 是支持定制化 SQL、存储过程以及高级映射的优秀的持久层框架，它支持定制化 SQL、存储过程以及高级映射，它避免了几乎所有的 JDBC 代码和手动设置参数以及获取结果集，它可以使用简单的 XML 或注解来配置和映射原生信息，将接口和 Java 的 POJOs(Plain Old Java Objects,普通的 Java对象)映射成数据库中的记录。架构构造由数据源配置文件、SQ...
Mybatis系列全解（四）：全网最全！Mybatis配置文件XML全貌详解
潘潘和他的朋友们
12-08 1884
封面：洛小汐 作者：潘潘 做大事和做小事的难度是一样的。两者都会消耗你的时间和精力，所以如果决心做事，就要做大事，要确保你的梦想值得追求，未来的收获可以配得上你的努力。 前言 上一篇文章 《Mybatis系列全解（三）：Mybatis简单CRUD使用介绍》 ，我们基本上手了 Mybatis 的增删改查操作，也感受到 Mybatis 的简单高效舒美，但是肯定有部分朋友对于 Mybatis 的配置文件只是了解基本组成和大致用法，尚无一套完整的结构记忆，所以本篇文章我们将详细的介绍 Mybatis 的配.
MyBatis学习总结(三)注解
刘清涛的专栏
08-07 321
 使用MyBatis注解开发，可以省去类配置文件，简洁方便。但是比较复杂的SQL和动态SQL还是建议书写类配置文件。 注解还是不推荐使用的。只是了解了解！简单的CRUD可以使用注解。简单写写。     把之前的例子改成使用注解的。 UserMapper.java package com.cy.mybatis.mapper; import java.util.List; import j...
Oracle出现超出打开游标最大数的解决方法
01-19
本文实例讲述了Oracle出现超出打开游标最大数的解决方法。分享给大家供大家参考，具体如下： Java代码在执行conn.createStatement()和conn.prepareStatement()的时候，实际上都是相当与在数据库中打开了一个cursor。...
Oracle存储过程游标用法分析
12-16
本文实例讲述了Oracle存储过程游标用法。分享给大家供大家参考，具体如下： 使用游标的5个步骤 1、声明一些变量用于保存select语句返回的指 2、声明游标，并指定select 语句 3、打开游标 4、从游标中获取记录 5、...
oracle 在一个存储过程中调用另一个返回游标的存储过程
12-16
第一种情况是返回的游标是某个具体的表或视图的数据，如： SQL-Code: 代码如下: CREATE OR REPLACE PROCEDURE P_TESTA ( PRESULT OUT SYS_REFCURSOR ) AS BEGIN OPEN PRESULT FOR SELECT * FROM USERS; END P_TESTA;...
mybatis中动态Sql标签库和ResultMap
qq_53909398的博客
03-15 1318
RESULTMAP 作用:自定义映射关系，一般当表字段与实体类属性不一样时使用（例如 Emp实体类和表t_emp） package com.atchengdu.mybatis.dao; public class Emp { private Integer eid; private String ename; private Integer age; private String sex; private String email; priva.
eclipse 使用maven 构建 springboot+mybatis
zhouzhiwengang的专栏
03-15 1万+
本文转载至：http://www.cnblogs.com/java-zhao/p/5350021.html 1、项目结构 2、pom.xml <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:sche
报错 java: 程序包org.apache.ibatis.annotations不存在
热门推荐
UserGuan的博客
01-07 4万+
解决办法在pom.xml文件中配置以下内容即可。
全网首篇eclipse 实现 Spring整合Mybatis
最新发布
m0_74381444的博客
10-14 515
纯注解开发 eclipse 实现 Spring整合Mybatis,简单易学，一口气领悟
org.apache.ibatis.annotations.Param注解
zk052300的博客
09-09 9288
在mybatis的Map类中，方法参数为多个时，前面一般需要加上@Param注解，例如 User getUser(@Param(“userId”)String userId,@Param(“password”)String password); @Param注解分为spring的和mybatis的： org.springframework.data.repository.query.Para...
mybatis怎么接收oracle存储过程的结果
lio567的博客
08-08 1383
其实无论是返回以下哪种类型,其实都是键值对对的形式 普通类型 oracle(即存储过程) create or replace procedure testReturnResult(returnResult out varchar2) as begin returnResult :='返回结果'; end ; java service: Map<String,Object> m...
java.sql.resultset方法与使用技巧
Memory1011的博客
03-05 420
转自：http://www.pinlue.com/article/2019/06/1102/299144817241.html
java sql 参数默认值_java.sql.resultset方法与使用技巧
weixin_36296827的博客
02-28 1194
接口 ResultSetpublic interface ResultSet表示数据库结果集的数据表，通常通过执行查询数据库的语句生成。ResultSet 对象具有指向其当前数据行的指针。最初，指针被置于第一行之前。next 方法将指针移动到下一行；因为该方法在 ResultSet 对象中没有下一行时返回 false，所以可以在 while 循环中使用它来迭代结果集。默认的 ResultSet 对...
MyBatis注解Annotation介绍及Demo
weixin_33859844的博客
04-21 350
MyBatis可以利用SQL映射文件来配置，也可以利用Annotation来设置。MyBatis提供的一些基本注解如下表所示。注解目标相应的XML描述@CacheNamespace类<cache> 为给定的命名空间（比如类）配置缓存。属性：implemetation,eviction,flushInterval , size 和 readWrite 。@Cach...
MyBatis框架核心之(五)注解使用resultMap及多表查询
弱弱的猿
12-12 3万+
五、resultMap与多表查询（注解）   传统的mapper.xml+接口使用接口映射相对较麻烦 所以我们可以使用注解来简化开发   支持的注解有以下： MyBatis可以利用SQL映射文件来配置，也可以利用Annotation来设置。MyBatis提供的一些基本注解如下表所示。 注解 目标 相对应的 XML 描述
oracle课件：第六章 游标和异常管理.ppt
08-23
本文总结了《Oracle数据库基础》课程中的第六章内容——游标和异常管理。该章节共包含以下几个部分：游标概述...通过学习本章，读者能够掌握游标的使用方法和异常处理的原理，提升对Oracle数据库的基础知识和操作技能。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值