java.lang.NumberFormatException: For input string

 

严重: java.lang.NumberFormatException: For input string: "companyCode"

 

在 object数组的时候,要注意好类型的转换.

 

------java.lang.NumberFormatException: For input string 解决方法--------------------------------------------------------
字符分割异常 转化字符或输入字符问题 

 

public List<?> findAgencyArSumDetail(
		SettlementAgencyARDetailResult headInfoArResult) {
		String sql = "SELECT CNTR_SIZE||CNTR_TYPE AS containerSizes,"
				+ " COMPANY_CDE AS companyCode,"
				+ " FULL_EMPTY_IND AS fullEmptyIndicator,"
				+ " EXP_IMP_IND AS expImportIndicator,"
				+ " SOC_IND AS socIndicator,"
				+ " COUNT(*) AS containeraCount,"
				+ " SUM(FEE_AMT) AS toTalNum,"
				+ " FEE_PRICE AS feePrice"
				+ " FROM CBS_SET_DOC_AG_CNTR "
				+ " WHERE SVVD_ID=:svvdId"
				+ " AND PORT_CDE=:portCode"
				+ " AND COMPANY_CDE=:companyCode"
				+ " AND SO_COMPANY_CDE=:SOCompanyCode"
				+ " AND FEE_TYPE=:feeType"
				+ " AND ACT_FLAG=:actualFlag"
				+ " GROUP BY(CNTR_SIZE||CNTR_TYPE,FULL_EMPTY_IND,SOC_IND,EXP_IMP_IND,FEE_PRICE,COMPANY_CDE)";
		SQLQuery querys = (SQLQuery) cbsModuleRepository.getSessionFactory()
		.getCurrentSession().createSQLQuery(sql.toString());
	 
		querys.setParameter(SettlementContant.SVVD_ID,
				headInfoArResult.getSvvdId());
		querys.setParameter(SettlementContant.PORT_CODE,
				headInfoArResult.getPortCode());
		querys.setParameter(SettlementContant.COMPANY_CODE,
				headInfoArResult.getCompanyCode());
		querys.setParameter(SettlementContant.SO_COMPANY_CODE,
				headInfoArResult.getShipownerCompanyCode());
		querys.setParameter(SettlementContant.FEE_TYPE,
				headInfoArResult.getChargeCode());
		querys.setParameter(SettlementContant.ACTUAL_FLAG,
				SettlementContant.ACTUAL_FLAG_Y);
		List<Object[]> list = querys.list();
		SettlementAgencySumDetailResult agencySumDetailResult = null;
		List<SettlementAgencySumDetailResult> queryList = new ArrayList<SettlementAgencySumDetailResult>();
		for (Object[] object : list) {
			agencySumDetailResult = new SettlementAgencySumDetailResult();
			agencySumDetailResult.setContainerSizes((String) object[0]);
			agencySumDetailResult.setCompanyCode((String) object[1]);
			agencySumDetailResult.setFullEmptyIndicator((String) object[2]);
			agencySumDetailResult.setExpImportIndicator((String) object[3]);
			agencySumDetailResult.setSocIndicator((String) object[4]);
			agencySumDetailResult.setContaineraCount((BigDecimal) object[5]);
			agencySumDetailResult.setToTalNum((BigDecimal) object[6]);
			agencySumDetailResult.setFeePrice((BigDecimal) object[7]);
			queryList.add(agencySumDetailResult);
		}
		return queryList;
	}

 注意循环遍历放到 List中..

 

这里还有关于HQL中在字符串的拼接问题.

 

      第一种:

+ " commBl.billBasicUuid= " + docHead.getBusinessReferenceUuid()
+ " AND commBl.companyCode = '" +docHead.getCompanyCode()+"'"
+ " AND commBl.commissionMode '" +arItem.getChargeCodeGroup()+"'"
+ " AND commBl.commissionType '" +arItem.getChargeCode()+"'"

 

hql.append(" WHERE commBl.billBasicUuid=:businessReferenceUuid");
		hql.append(" AND commBl.companyCode =:companyCode");
		hql.append(" AND commBl.commissionMode=:chargeCodeGroup");
		hql.append(" AND commBl.commissionType=:chargeCode");

	第二种:

Query query = cbsModuleRepository.getSessionFactory()
				.getCurrentSession().createQuery(hql.toString());
		query.setParameter(SettlementContant.BUSINESS_REFERENCE_UUID,
				settlementHead.getBusinessReferenceUuid());
		query.setParameter(SettlementContant.COMPANY_CODE,
				settlementHead.getCompanyCode());
		query.setParameter(SettlementContant.CHARGE_CODE_GROUP,
				settlementAR.getChargeCodeGroup());
		query.setParameter(SettlementContant.CHARGE_CODE,
				settlementAR.getChargeCode());

 

 

跟上边的可以比较一下,这里例举2中拼接的例子.

 

评论

1 楼 灵力不足 2012-06-10  

Struts Problem Report

Struts has detected an unhandled exception:




Messages:

•For input string: ""



File:

java/lang/NumberFormatException.java



Line number:

48



--------------------------------------------------------------------------------

Stacktraces

java.lang.NumberFormatException: For input string: ""
    java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
    java.lang.Integer.parseInt(Integer.java:470)
    java.lang.Integer.valueOf(Integer.java:554)
    com.webExam.action.QuestionAction.getExamBean(QuestionAction.java:47)
    com.webExam.action.QuestionAction.create(QuestionAction.java:83)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:597)
    com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:452)
    com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:291)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:254)
    com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:176)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:263)
    org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:133)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:207)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:207)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:190)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:243)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:142)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:166)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:176)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:190)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:187)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
    org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
    org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:485)
    org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
    org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)
    org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
    org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    java.lang.Thread.run(Thread.java:619)
    

--------------------------------------------------------------------------------

You are seeing this page because development mode is enabled. Development mode, or devMode, enables extra debugging behaviors and reports to assist developers. To disable this mode, set:
   struts.devMode=false
in your WEB-INF/classes/struts.properties file.


我的报错是这样的，那是什么问题呢，也是数据库吗