db2-在做数据导出的时候，WAS报sql错误（springMVC、mybatis、DB2） 急 急急

问题描述

在做数据导出的时候，WAS报sql错误（springMVC、mybatis、DB2） 急 急急

请帮忙看看究竟是报什么错呀，，，急急急

[14-3-7 10:27:37:460 GMT+08:00] 000001fc SystemErr R org.springframework.jdbc.UncategorizedSQLException:
### Error querying database. Cause: com.ibm.db2.jcc.b.SqlException

The error may involve com.rainbow.db.query.personalissue.addresslist.PerAddrListQueryMapper.selectByPerAddrListQuery-Inline

### The error occurred while setting parameters

Cause: com.ibm.db2.jcc.b.SqlException

; uncategorized SQLException for SQL []; SQL state [null]; error code [-99999]; null; nested exception is com.ibm.db2.jcc.b.SqlException
[14-3-7 10:27:37:461 GMT+08:00] 000001fc SystemErr R at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
[14-3-7 10:27:37:461 GMT+08:00] 000001fc SystemErr R at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
[14-3-7 10:27:37:462 GMT+08:00] 000001fc SystemErr R at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
[14-3-7 10:27:37:462 GMT+08:00] 000001fc SystemErr R at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:71)
[14-3-7 10:27:37:462 GMT+08:00] 000001fc SystemErr R at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:346)
[14-3-7 10:27:37:462 GMT+08:00] 000001fc SystemErr R at $Proxy272.selectList(Unknown Source)
[14-3-7 10:27:37:462 GMT+08:00] 000001fc SystemErr R at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:189)
[14-3-7 10:27:37:462 GMT+08:00] 000001fc SystemErr R at com.rainbow.db.query.personalissue.addresslist.PerAddrListQueryMapperImpl.selectByPerAddrListQuery(PerAddrListQueryMapperImpl.java:22)
[14-3-7 10:27:37:462 GMT+08:00] 000001fc SystemErr R at com.rainbow.bl.personalissue.impl.PerAddrListServiceImpl.selectByPerAddrListQuery(PerAddrListServiceImpl.java:120)
[14-3-7 10:27:37:463 GMT+08:00] 000001fc SystemErr R at com.rainbow.bl.personalissue.impl.PerAddrListServiceImpl$$FastClassByCGLIB$$bbc37323.invoke()
[14-3-7 10:27:37:463 GMT+08:00] 000001fc SystemErr R at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
[14-3-7 10:27:37:463 GMT+08:00] 000001fc SystemErr R at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
[14-3-7 10:27:37:463 GMT+08:00] 000001fc SystemErr R at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
[14-3-7 10:27:37:463 GMT+08:00] 000001fc SystemErr R at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
[14-3-7 10:27:37:463 GMT+08:00] 000001fc SystemErr R at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
[14-3-7 10:27:37:463 GMT+08:00] 000001fc SystemErr R at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
[14-3-7 10:27:37:464 GMT+08:00] 000001fc SystemErr R at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
[14-3-7 10:27:37:464 GMT+08:00] 000001fc SystemErr R at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
[14-3-7 10:27:37:464 GMT+08:00] 000001fc SystemErr R at com.rainbow.bl.personalissue.impl.PerAddrListServiceImpl$$EnhancerByCGLIB$$d8b9d10c.selectByPerAddrListQuery()
[14-3-7 10:27:37:464 GMT+08:00] 000001fc SystemErr R at com.rainbow.view.personalissue.PerAddrListController.preAddrlistInfoExport(PerAddrListController.java:617)
[14-3-7 10:27:37:464 GMT+08:00] 000001fc SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[14-3-7 10:27:37:464 GMT+08:00] 000001fc SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
[14-3-7 10:27:37:464 GMT+08:00] 000001fc SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
[14-3-7 10:27:37:465 GMT+08:00] 000001fc SystemErr R at java.lang.reflect.Method.invoke(Method.java:611)
[14-3-7 10:27:37:465 GMT+08:00] 000001fc SystemErr R at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
[14-3-7 10:27:37:465 GMT+08:00] 000001fc SystemErr R at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:436)
[14-3-7 10:27:37:465 GMT+08:00] 000001fc SystemErr R at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:424)
[14-3-7 10:27:37:465 GMT+08:00] 000001fc SystemErr R at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:900)
[14-3-7 10:27:37:465 GMT+08:00] 000001fc SystemErr R at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:827)
[14-3-7 10:27:37:466 GMT+08:00] 000001fc SystemErr R at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
[14-3-7 10:27:37:466 GMT+08:00] 000001fc SystemErr R at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778)
[14-3-7 10:27:37:466 GMT+08:00] 000001fc SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:575)
[14-3-7 10:27:37:466 GMT+08:00] 000001fc SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
[14-3-7 10:27:37:466 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1214)
[14-3-7 10:27:37:466 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:774)
[14-3-7 10:27:37:466 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:456)
[14-3-7 10:27:37:467 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
[14-3-7 10:27:37:467 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:125)
[14-3-7 10:27:37:467 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:92)
[14-3-7 10:27:37:467 GMT+08:00] 000001fc SystemErr R at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
[14-3-7 10:27:37:467 GMT+08:00] 000001fc SystemErr R at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
[14-3-7 10:27:37:467 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:192)
[14-3-7 10:27:37:467 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:89)
[14-3-7 10:27:37:468 GMT+08:00] 000001fc SystemErr R at org.jasig.cas.client.util.HttpServletRequestWrapperFilter.doFilter(HttpServletRequestWrapperFilter.java:62)
[14-3-7 10:27:37:468 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:192)
[14-3-7 10:27:37:468 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:89)
[14-3-7 10:27:37:468 GMT+08:00] 000001fc SystemErr R at org.jasig.cas.client.validation.AbstractTicketValidationFilter.doFilter(AbstractTicketValidationFilter.java:167)
[14-3-7 10:27:37:468 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:192)
[14-3-7 10:27:37:468 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:89)
[14-3-7 10:27:37:469 GMT+08:00] 000001fc SystemErr R at org.jasig.cas.client.authentication.AuthenticationFilter.doFilter(AuthenticationFilter.java:93)
[14-3-7 10:27:37:469 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:192)
[14-3-7 10:27:37:469 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:89)
[14-3-7 10:27:37:469 GMT+08:00] 000001fc SystemErr R at org.jasig.cas.client.session.SingleSignOutFilter.doFilter(SingleSignOutFilter.java:110)
[14-3-7 10:27:37:469 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:192)
[14-3-7 10:27:37:469 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:89)
[14-3-7 10:27:37:469 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:926)
[14-3-7 10:27:37:470 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1023)
[14-3-7 10:27:37:470 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
[14-3-7 10:27:37:470 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:895)
[14-3-7 10:27:37:470 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)
[14-3-7 10:27:37:470 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:195)
[14-3-7 10:27:37:470 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:458)
[14-3-7 10:27:37:470 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:522)
[14-3-7 10:27:37:471 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:311)
[14-3-7 10:27:37:471 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:87)
[14-3-7 10:27:37:471 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
[14-3-7 10:27:37:471 GMT+08:00] 000001fc SystemErr R at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
[14-3-7 10:27:37:471 GMT+08:00] 000001fc SystemErr R at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
[14-3-7 10:27:37:471 GMT+08:00] 000001fc SystemErr R at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
[14-3-7 10:27:37:471 GMT+08:00] 000001fc SystemErr R at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
[14-3-7 10:27:37:472 GMT+08:00] 000001fc SystemErr R at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
[14-3-7 10:27:37:472 GMT+08:00] 000001fc SystemErr R at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
[14-3-7 10:27:37:472 GMT+08:00] 000001fc SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1783)
[14-3-7 10:27:37:472 GMT+08:00] 000001fc SystemErr R Caused by: com.ibm.db2.jcc.b.SqlException
[14-3-7 10:27:37:473 GMT+08:00] 000001fc SystemErr R at com.ibm.db2.jcc.b.s.a(s.java:1517)
[14-3-7 10:27:37:473 GMT+08:00] 000001fc SystemErr R at com.ibm.db2.jcc.b.s.m(s.java:465)
[14-3-7 10:27:37:473 GMT+08:00] 000001fc SystemErr R at com.ibm.db2.jcc.b.s.M(s.java:1102)
[14-3-7 10:27:37:474 GMT+08:00] 000001fc SystemErr R at com.ibm.db2.jcc.b.kf.getString(kf.java:903)
[14-3-7 10:27:37:474 GMT+08:00] 000001fc SystemErr R at com.ibm.db2.jcc.b.kf.getString(kf.java:1234)
[14-3-7 10:27:37:474 GMT+08:00] 000001fc SystemErr R at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:224)
[14-3-7 10:27:37:474 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.type.StringTypeHandler.getNullableResult(StringTypeHandler.java:17)
[14-3-7 10:27:37:474 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.type.StringTypeHandler.getNullableResult(StringTypeHandler.java:8)
[14-3-7 10:27:37:474 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.type.BaseTypeHandler.getResult(BaseTypeHandler.java:29)
[14-3-7 10:27:37:474 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.executor.resultset.FastResultSetHandler.getPropertyMappingValue(FastResultSetHandler.java:267)
[14-3-7 10:27:37:475 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.executor.resultset.FastResultSetHandler.applyPropertyMappings(FastResultSetHandler.java:250)
[14-3-7 10:27:37:475 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.executor.resultset.FastResultSetHandler.getRowValue(FastResultSetHandler.java:224)
[14-3-7 10:27:37:475 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleRowValues(FastResultSetHandler.java:173)
[14-3-7 10:27:37:475 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleResultSet(FastResultSetHandler.java:146)
[14-3-7 10:27:37:475 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleResultSets(FastResultSetHandler.java:112)
[14-3-7 10:27:37:475 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:40)
[14-3-7 10:27:37:475 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:55)
[14-3-7 10:27:37:476 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:41)
[14-3-7 10:27:37:476 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:243)
[14-3-7 10:27:37:476 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:117)
[14-3-7 10:27:37:476 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:72)
[14-3-7 10:27:37:476 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:79)
[14-3-7 10:27:37:476 GMT+08:00] 000001fc SystemErr R at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:73)
[14-3-7 10:27:37:477 GMT+08:00] 000001fc SystemErr R at sun.reflect.GeneratedMethodAccessor1232.invoke(Unknown Source)
[14-3-7 10:27:37:477 GMT+08:00] 000001fc SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
[14-3-7 10:27:37:477 GMT+08:00] 000001fc SystemErr R at java.lang.reflect.Method.invoke(Method.java:611)
[14-3-7 10:27:37:477 GMT+08:00] 000001fc SystemErr R at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:338)
[14-3-7 10:27:37:477 GMT+08:00] 000001fc SystemErr R ... 68 more

时间： 2024-10-22 20:11:24

db2-在做数据导出的时候，WAS报sql错误（springMVC、mybatis、DB2） 急 急急的相关文章

优化-java代码中有个循环，数据量一大直接网页报500错误

问题描述 java代码中有个循环,数据量一大直接网页报500错误 求大神帮忙优化一下,10000数据还可以,但是数据一多网页就崩溃了,就是代码中的row++,加上去就不行了 解决方案 结果是内存益处了 那就是你的程序太耗费资源了. 那个获取page的方法: 1--Page对象村的东西太多了,很多何你写入单元格的数据没关系, 既然这块逻辑是大数据量的,为什么不拆分针对这块逻辑的结构呢? 使用Page造成了很大的内存浪费 在循环外部定义这个结构 List list = null 2--将方法的参数精

asp.net C#中ListView中数据导出到Excel实例

具体代码  代码如下 复制代码 private void 导出数据_Click(object sender, EventArgs e) { ExportToExecl(); } /// <summary> /// 执行导出数据 /// </summary> public void ExportToExecl() { System.Windows.Forms.SaveFileDialog sfd = new SaveFileDialog(); sfd.DefaultExt = &qu

导数据 datatable合并-现在要求做一个导出数据功能，根据不同时间导出数据，如下图

问题描述 现在要求做一个导出数据功能,根据不同时间导出数据,如下图 假如现在是1.15号,那么导出的时候也要把11,12月的也一起导出,如果是最后一个月(供热末期),那么就要导出所有,现在我做的是传入四个日期,但是不知道怎么合并,求指教,或者各位有什么其他方法请指教 解决方案 excel用csv格式解析,用脚本读取对应的数据,导出

excel-asp.net把DataTable里的数据导出到Excel 并且要做合并 某列里多行合并的操作

问题描述 asp.net把DataTable里的数据导出到Excel 并且要做合并 某列里多行合并的操作 把DataTable里的数据导出到Excel 并且要做合并 某列里多行合并的操作 请问有什么方法,求大神指教.谢谢了. 解决方案 http://m.baidu.com/from=1011267h/bd_page_type=1/ssid=0/uid=0/pu=usm%400%2Csz%401321_1004%2Cta%40utouch_2_4.1_11_2.1/baiduid=974ADEE1

我在程序中把数据导出到excel存放在服务器，用户不用下载excel而直接打印，怎么做呢？

问题描述 我在程序中把数据导出到excel存放在服务器,用户不用下载excel而直接打印,怎么做呢? 解决方案 解决方案二:可以网上google代码或者用第三方控件客户不下载就直接打印好像比较难解决方案三:DLL一定要加的那在服务器打开Excel,我也做过,不过没成功,本机好用上传之后不好用了,希望你能够解决

使用utl_file做选择性数据导出

在平时的数据导出中使用exp/expdp能够满足绝大部分的数据导出任务.如果有一些表的数据不多,但是查询条件要复杂一些,使用exp/expdp就很吃力了. 或者在和外部系统的交互中,使用xml或者文本文件是一个很兼容的选择,这个时候使用exp/expdp也满足不了要求. 这个时候可以考虑使用utl_file的提供的一些功能来做选择性的数据导出. 先来使用utl_file做一个简单的例子,输出两行文本内容到output.txt文件中.一行Hello,一行hello word declare v_f

DB2中的数据移动

数据移动的作用: 如果要在不同的数据库管理系统之间转移数据,数据移动通常是最实用的一种方法,因为任何一种数据库管理系统都支持常用的几种文件格式,通过这个通用的接口,就很容易实现不同系统间数据的转移. 这三个命令中,Export最简单,因为从表中向文件转移数据,通常不会出现错误,也不会有非法的数据. 在讲解命令之前,首先介绍一下文件的格式,用于DB2数据移动的文件格式有四种: 1. ASC--非定界ASCII文件,是一个ASCII字符流.数据流中的行由行定界符分隔,而行中的每一列则通过起始和结束位

利用PHPExcel将数据导出到xls格式的excel文件

在开发某地的经营许可证管理系统的时候需要将数据导出打excel文件,虽然一年前做某集团的ERP的时候用到过一次导入和导出,但是那时候太忙没时间写博客,一年过去了我也忘的差不多了,所以趁着今天将此次的使用写到博客中,作为以后开发的一个参考,免得再次使用的时候需要导出找资料,也给其他同行一个参考.作者:DragonDean,博客地址:http://www.cnblogs.com/dragondean/   什么是PHPExcel? PHPExcel 是用来操作Office Excel 文档的一个PH

解决google webmaster tool数据导出乱码问题

这是一个众所周知的seo一大利器,在使用的时候确实可以帮助我提升seo效率,应该每一个SEOer都应该去申请使用的seo基础工具.我本人也google网站管理员工具的一大爱好者,觉得这个工具确实是在工作当中帮助了我解决很多的问题,比如简单的HTML错误到复杂的网站被别人恶意攻击等等,google网站管理员工具都能够几时发现问题,并给出合理的修改意见,从而节省了不必要的时间,提高了SEO工作效率. google webmaster tool当中我个人喜欢把数据导出来分析,因为这样比较细一点,也可以