以上就是给各位分享萨克斯-ExpatParser$ParseException,其中也会对萨克斯十大名曲播放进行解释,同时本文还将给你拓展'按转换顺序排序(c.name使用gbk)',net.sf.j
以上就是给各位分享萨克斯-ExpatParser $ ParseException,其中也会对萨克斯十大名曲播放进行解释,同时本文还将给你拓展'按转换顺序排序(c.name使用gbk)',net.sf.jsqlparser.parser.ParseException:遇到意外的令牌:“(”“(”、android点滴1:SAXParseException、com.github.pagehelper.PageException: 处理排序失败: net.sf.jsqlparser.JSQLParserException、com.parse.ParseException的实例源码等相关知识,如果能碰巧解决你现在面临的问题,别忘了关注本站,现在开始吧!
本文目录一览:- 萨克斯-ExpatParser $ ParseException(萨克斯十大名曲播放)
- '按转换顺序排序(c.name使用gbk)',net.sf.jsqlparser.parser.ParseException:遇到意外的令牌:“(”“(”
- android点滴1:SAXParseException
- com.github.pagehelper.PageException: 处理排序失败: net.sf.jsqlparser.JSQLParserException
- com.parse.ParseException的实例源码
萨克斯-ExpatParser $ ParseException(萨克斯十大名曲播放)
我正在制作一个读取XML Internet的Android应用程序。此应用程序使用SAX解析XML。这是我的解析部分代码:
public LectorSAX(String url){
try{
SAXParserFactory spf=SAXParserFactory.newInstance();
SAXParser sp = spf.newSAXParser();
DefaultHandler lxmlr=new LibraryXMLReader() ;
sp.parse(url,lxmlr);
nodo=((LibraryXMLReader)lxmlr).getNodoActual();
}catch(ParserConfigurationException e){
System.err.println("Error de parseo en LectorSAX.java: "+e);
}catch(SAXException e){
System.err.println("Error de sax LectorSAX.java: " + e);
} catch (IOException e){
System.err.println("Error de io LectorSAX.java: " + e);
}
}
问题是发生SAXException。异常消息如下:
org.apache.harmony.xml.ExpatParser $ ParseException:在第4行,第42列:格式不正确(无效的令牌)
但是,如果我将相同的代码放在普通的Java SE应用程序中,则不会发生此异常,并且一切正常。
为什么相同的代码在Java SE应用程序(而不是Android)中可以正常工作?另一方面,如何解决问题呢?
谢谢您的帮助。
问候。
'按转换顺序排序(c.name使用gbk)',net.sf.jsqlparser.parser.ParseException:遇到意外的令牌:“(”“(”
如何解决''按转换顺序排序(c.name使用gbk)'',net.sf.jsqlparser.parser.ParseException:遇到意外的令牌:“(”“(”?
`select c.* from card_card c left join card_user_collection uc on c.id = uc.card_id
WHERE uc.user_id = ?
order by convert (c.name using gbk) asc;`
它给了我一个警告,并说:
optimize this sql to a count sql has exception,sql:"select c.* from card_card c left join card_user_collection uc on c.id = uc.card_id
WHERE uc.user_id = ?
order by convert (c.name using gbk) asc",exception:
net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "("
at line 3,column 26.
Was expecting one of:
"&"
"&&"
","
"::"
";"
"<<"
">>"
"AND"
"ASC"
"COLLATE"
"DESC"
"EXCEPT"
"FOR"
"INTERSECT"
"MINUS"
"NULLS"
"ORDER"
"UNION"
"["
"^"
"|"
<EOF>
MysqL版本“使用EditLine包装器用于Linux(x86_64)的MysqL Ver 14.14 distrib 5.7.26”
这让我很头疼了很长时间,如果您遇到这个问题,希望能得到您的帮助。
非常感谢您。
解决方法
暂无找到可以解决该程序问题的有效方法,小编努力寻找整理中!
如果你已经找到好的解决方法,欢迎将解决方案带上本链接一起发送给小编。
小编邮箱:dio#foxmail.com (将#修改为@)
android点滴1:SAXParseException
The processing instruction target matching "[xX][mM][lL]" is not allowed.
Exception:org.xml.sax.SAXParseException: The processing instruction target matching "[xX][mM][lL]" is not allowed.
这个异常解释为:xml文件不能被解析,一般出现这样的问题在于xml格式上,并且问题多出现在xml文件的头部。如果出现这个错误,是因为头部有空行,有可能你的xml文件不是在第一行开始或者xml的开头“<?xml ...."前有空格!
com.github.pagehelper.PageException: 处理排序失败: net.sf.jsqlparser.JSQLParserException
com.github.pagehelper.PageException: 处理排序失败: net.sf.jsqlparser.JSQLParserException
net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "DELAYED" "DELAYED"
at line 3, column 19.
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: com.github.pagehelper.PageException: 处理排序失败: net.sf.jsqlparser.JSQLParserException
### The error may exist in cn/com/chinatelecom/ecms/dao/dev22/NetageGetBoonMapper.xml
### The error may involve cn.com.chinatelecom.ecms.dao.dev22.NetageGetBoonMapper.selectNetageGetBoonList_COUNT
### The error occurred while handling results
### SQL: select count(0) from (select ID,PHONENUMBER,GETTIME,BOONID,BOONNAME,BOONSTATE,GEARID,GEARNAME, PRIZETYPE,DELAYED,USEDTYPE,PRIZECOUNT,PRIZETIME from T_NETAGE_GETBOON WHERE TO_CHAR(GETTIME,''YYYY-MM-DD HH24:MI:SS'') >= ? AND TO_CHAR(GETTIME,''YYYY-MM-DD HH24:MI:SS'') <= ?) tmp_count
### Cause: com.github.pagehelper.PageException: 处理排序失败: net.sf.jsqlparser.JSQLParserException
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
at com.sun.proxy.$Proxy55.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230)
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:139)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
at com.sun.proxy.$Proxy350.selectNetageGetBoonList(Unknown Source)
at cn.com.chinatelecom.ecms.service.impl.DedicatedCustomerServiceImpl.lambda$1(DedicatedCustomerServiceImpl.java:206)
at cn.com.chinatelecom.ecms.service.impl.DedicatedCustomerServiceImpl$$Lambda$202/1537737921.doSelect(Unknown Source)
at com.github.pagehelper.Page.doSelectPage(Page.java:348)
at cn.com.chinatelecom.ecms.service.impl.DedicatedCustomerServiceImpl.selectnetageGetBoonList(DedicatedCustomerServiceImpl.java:206)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:93)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
at com.sun.proxy.$Proxy353.selectnetageGetBoonList(Unknown Source)
at cn.com.chinatelecom.ecms.controller.customer.DedicatedCustomerController.initNetageGetBoonList(DedicatedCustomerController.java:114)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:215)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:142)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:998)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:901)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:875)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.session.ConcurrentSessionFilter.doFilter(ConcurrentSessionFilter.java:155)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:66)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.session.web.http.SessionRepositoryFilter.doFilterInternal(SessionRepositoryFilter.java:147)
at org.springframework.session.web.http.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:81)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: com.github.pagehelper.PageException: 处理排序失败: net.sf.jsqlparser.JSQLParserException
### The error may exist in cn/com/chinatelecom/ecms/dao/dev22/NetageGetBoonMapper.xml
### The error may involve cn.com.chinatelecom.ecms.dao.dev22.NetageGetBoonMapper.selectNetageGetBoonList_COUNT
### The error occurred while handling results
### SQL: select count(0) from (select ID,PHONENUMBER,GETTIME,BOONID,BOONNAME,BOONSTATE,GEARID,GEARNAME, PRIZETYPE,DELAYED,USEDTYPE,PRIZECOUNT,PRIZETIME from T_NETAGE_GETBOON WHERE TO_CHAR(GETTIME,''YYYY-MM-DD HH24:MI:SS'') >= ? AND TO_CHAR(GETTIME,''YYYY-MM-DD HH24:MI:SS'') <= ?) tmp_count
### Cause: com.github.pagehelper.PageException: 处理排序失败: net.sf.jsqlparser.JSQLParserException
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:150)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)
... 108 common frames omitted
Caused by: com.github.pagehelper.PageException: 处理排序失败: net.sf.jsqlparser.JSQLParserException
at com.github.pagehelper.parser.OrderByParser.converToOrderBySql(OrderByParser.java:64)
at com.github.pagehelper.dialect.AbstractHelperDialect.getPageSql(AbstractHelperDialect.java:173)
at com.github.pagehelper.PageHelper.getPageSql(PageHelper.java:98)
at com.github.pagehelper.util.ExecutorUtil.pageQuery(ExecutorUtil.java:168)
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:104)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
at com.sun.proxy.$Proxy483.query(Unknown Source)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
... 114 common frames omitted
Caused by: net.sf.jsqlparser.JSQLParserException: null
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:55)
at com.github.pagehelper.parser.OrderByParser.converToOrderBySql(OrderByParser.java:52)
... 121 common frames omitted
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "DELAYED" "DELAYED"
at line 3, column 19.
Was expecting one of:
"("
"*"
"+"
"-"
":"
"?"
"@"
"@@"
"ACTION"
"ANY"
"CASCADE"
"CASE"
"CAST"
"COLUMN"
"COMMIT"
"DO"
"DOUBLE"
"ENABLE"
"END"
"EXTRACT"
"FIRST"
"FOLLOWING"
"GROUP_CONCAT"
"IF"
"INDEX"
"INSERT"
"INTERVAL"
"KEY"
"LAST"
"LEFT"
"MATERIALIZED"
"NO"
"NULL"
"NULLS"
"OPEN"
"OVER"
"PARTITION"
"PERCENT"
"PRECISION"
"PRIMARY"
"PRIOR"
"RANGE"
"REPLACE"
"RIGHT"
"ROW"
"ROWS"
"SEPARATOR"
"SET"
"SIBLINGS"
"TABLE"
"TEMP"
"TEMPORARY"
"TRUNCATE"
"UNSIGNED"
"VALUE"
"VALUES"
"XML"
"{d"
"{fn"
"{t"
"{ts"
"~"
<K_DATETIMELITERAL>
<K_TIME_KEY_EXPR>
<S_CHAR_LITERAL>
<S_DOUBLE>
<S_HEX>
<S_IDENTIFIER>
<S_LONG>
<S_QUOTED_IDENTIFIER>
at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:18047)
at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:17900)
at net.sf.jsqlparser.parser.CCJSqlParser.SelectItem(CCJSqlParser.java:3528)
at net.sf.jsqlparser.parser.CCJSqlParser.SelectItemsList(CCJSqlParser.java:3368)
at net.sf.jsqlparser.parser.CCJSqlParser.PlainSelect(CCJSqlParser.java:2930)
at net.sf.jsqlparser.parser.CCJSqlParser.SetOperationList(CCJSqlParser.java:3107)
at net.sf.jsqlparser.parser.CCJSqlParser.SelectBody(CCJSqlParser.java:2824)
at net.sf.jsqlparser.parser.CCJSqlParser.Select(CCJSqlParser.java:2817)
at net.sf.jsqlparser.parser.CCJSqlParser.SingleStatement(CCJSqlParser.java:133)
at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:81)
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:53)
... 122 common frames omitted
com.github.pagehelper.PageException: 处理排序失败: net.sf.jsqlparser.JSQLParserException
net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "DELAYED" "DELAYED" at line 3, column 19.
由于 DELAYED 是关键字,是 DELAYED 这个关键字引起的异常,两种解决方法:
1. 一般就只需要将这个关键字 去掉 不进行获取,就不报异常,
2. 可这个 DELAYED 字段,是需要进行获取出列值的表字段,
这时,就不在 serviceImpl.java 里面进行传递 排序,,直接在 sql 里面写死,就可以了,异常就解决了
代码如下:
serviceImpl.java
Page<NetageGetBoon> page = PageHelper.startPage(pageInfo.getPageNo(), pageInfo.getPageSize(), true)
.doSelectPage(() -> netageGetBoonMapper.selectByExampleOfCon(example));
// .setOrderBy("GETTIME DESC").doSelectPage(() -> netageGetBoonMapper.selectByExample(example));
pageInfo.setCount((int) page.getTotal());
return new ArrayList<>(page.getResult());
Mapper.xml
<sql id="Base_Column_List" >
ID, PHONENUMBER, GETTIME, BOONID, BOONNAME, BOONSTATE, GEARID, GEARNAME, PRIZETYPE,
DELAYED, REMARK, USEDTYPE, PRIZECOUNT, PRIZETIME
</sql>
<select id="selectByExample" resultMap="BaseResultMap" parameterType="cn.com.chinatelecom.ecms.pojo.dev22.NetageGetBoonExample" >
<!--
WARNING - @mbggenerated
This element is automatically generated by MyBatis Generator, do not modify.
-->
select
<if test="distinct" >
distinct
</if>
<include refid="Base_Column_List" />
from T_NETAGE_GETBOON
<if test="_parameter != null" >
<include refid="Example_Where_Clause" />
</if>
<!-- <if test="orderByClause != null" >
order by ${orderByClause}
</if> -->
order by GETTIME DESC
</select>
com.parse.ParseException的实例源码
private void cadastrarUsuario() { //Cria objeto usuario ParseUser usuario = new ParseUser(); usuario.setUsername(textoUsuario.getText().toString()); usuario.setEmail(textoEmail.getText().toString()); usuario.setPassword(textoSenha.getText().toString()); //salva dados do usuario usuario.signUpInBackground(new SignUpCallback() { @Override public void done(ParseException e) { if (e == null) {//sucesso ao salvar Toast.makeText(CadastroActivity.this,"Cadastro feito com sucesso!",Toast.LENGTH_LONG).show(); abrirLoginUsuario(); } else {//erro ao salvar ParseErros parseErros = new ParseErros(); String erro = parseErros.getErro(e.getCode()); Toast.makeText(CadastroActivity.this,erro,Toast.LENGTH_LONG).show(); } } }); }
private void verificarLogin(String usuario,String senha) { ParseUser.logInInBackground(usuario,senha,new LogInCallback() { @Override public void done(ParseUser user,ParseException e) { if (e == null) {//sucesso no login Toast.makeText(LoginActivity.this,"Login realizado com sucesso!!",Toast.LENGTH_LONG).show(); abrirAreaPrincipal(); } else {//erro ao logar ParseErros parseErros = new ParseErros(); String erro = parseErros.getErro(e.getCode()); Toast.makeText(LoginActivity.this,Toast.LENGTH_LONG).show(); } } }); }
private void localQuery(){ ParseQuery<Kid> lQuery = ParseQuery.getQuery(Kid.class).fromLocalDatastore(); lQuery.orderByAscending("createdAt"); lQuery.findInBackground(new FindCallback<Kid>() { @Override public void done(List<Kid> list,ParseException e) { if (e == null) { kidArrayList.clear(); kidArrayList.addAll(list); fillHashMap(); adapter = new AddAttendanceAdapter(AddAttendance.this,kidArrayList,activityMap); listView.setAdapter(adapter); listView.invalidate(); } } }); }
private void saveMethod(){ //will save the data if(dateText.getText().toString().equals("") || dateText.getText().toString().equals(" ") || dateText.getText() == null){ //but before saving we will make sure that date is there Toast.makeText(getApplicationContext(),"Attendance date is required",Toast.LENGTH_SHORT).show(); // Snackbar.make(findViewById(R.id.activity_add_attendance),// "Attendance date is required",Snackbar.LENGTH_SHORT).show(); }else{ List<String> kidsIds = new ArrayList<>(); for (int i = 0; i < adapter.map.size() ; i++) { if (adapter.map.get(kidArrayList.get(i))){ kidsIds.add(kidArrayList.get(i).getobjectId()); } } attendance.setDate(dateText.getText().toString()); attendance.setKidsIds(kidsIds); attendance.saveInBackground(new SaveCallback() { @Override public void done(ParseException e) { if (e == null){ Toast.makeText(getApplicationContext(),"Saved successfully.",Toast.LENGTH_LONG).show(); end(); } } }); } }
private void logIn() { prefs = getSharedPreferences("prefFile",0); String userName = prefs.getString("userName",null); String password = prefs.getString("password",null); user.logInInBackground(userName,password,new LogInCallback() { @Override public void done(ParseUser parseUser,@Nullable ParseException e) { if (e == null){ toaster("Login successful!","l"); }else { toaster("Failed to connect!","l"); } } }); }
private void localQuery(){ ParseQuery<Kid> query = ParseQuery.getQuery(Kid.class).fromLocalDatastore(); query.orderByAscending("createdAt"); query.findInBackground(new FindCallback<Kid>() { @Override public void done(List<Kid> list,@Nullable ParseException e) { if (e == null && list.size()!=0) { kidArrayList.clear(); kidArrayList.addAll(list); applyAttendancetoKids(); adapter.notifyDataSetChanged(); listView.invalidate(); } } }); }
private void serverQuery() { ParseQuery<Kid> query = ParseQuery.getQuery(Kid.class); query.orderByAscending("createdAt"); query.findInBackground(new FindCallback<Kid>() { @Override public void done(List<Kid> list,@Nullable ParseException e) { if (e == null){ kidArrayList.clear(); kidArrayList.addAll(list); Kid.pinAllInBackground(kidArrayList); applyAttendancetoKids(); adapter.notifyDataSetChanged(); listView.invalidate(); }else if(checkConnection()){ toaster("Error getting data from Server\nWorking offline!","l"); } } }); }
public void autoLogin(){ if (checkConnection()){ String userName = prefs.getString("userName",@Nullable ParseException e) { if (e == null){ isLoggedIn = true; splash(1500); Snackbar.make(findViewById(R.id.activity_splash),"Login successful..",Snackbar.LENGTH_LONG).show(); } } }); }else { isLoggedIn = false; splash(4000); Snackbar.make(findViewById(R.id.activity_splash),"You are offline,Working on local data",Snackbar.LENGTH_LONG).show();} }
private void incrementNumberOfVisits(){ int i; if(myKid.getNumberOfVisits() == null){ i = 0; }else{ i = Integer.parseInt(myKid.getNumberOfVisits());} i++; myKid.setNumberOfVisits(String.valueOf(i)); myKid.saveInBackground(new SaveCallback() { @Override public void done(ParseException e) { if (e == null){ Toast.makeText(getApplicationContext(),"Saved successfully",Toast.LENGTH_LONG).show(); }else { Toast.makeText(getApplicationContext(),"Error calculating the number of visits!",Toast.LENGTH_LONG).show(); } } }); }
@Kroll.method public void start() { setState(STATE_RUNNING); // App opens analytics ParseAnalytics.trackAppOpenedInBackground(TiApplication.getAppRootOrCurrentActivity().getIntent()); ParseInstallation.getCurrentInstallation().put("androidId",getAndroidId()); ParseInstallation.getCurrentInstallation().saveInBackground(new SaveCallback() { public void done(ParseException e) { if (e != null) { Log.e(TAG,"Installation initialization Failed: " + e.getMessage()); } // fire event try { JSONObject pnData = new JSONObject(); pnData.put("objectId",getobjectId()); pnData.put("installationId",getCurrentInstallationId()); KrollDict data = new KrollDict(pnData); module.fireEvent("installationId",data); } catch (JSONException e1) { Log.e(TAG,"InstallationId event Failed: " + e1.getMessage()); } } }); }
@Override public List<Anime> getAnimeListByUrl(String url) { ArrayList<Anime> animeList = new ArrayList<>(); ParseQuery<AnimeRecord> query = AnimeRecord.getQuery(); try { List<AnimeRecord> animeRecords = query.whereContains("url",url).find(); for (AnimeRecord record : animeRecords) { Anime anime = AnimeRecord.toAnime(record); if (anime != null) animeList.add(anime); } } catch (ParseException e) { WriteLog.appendLogException(TAG,"getAnimeListByUrl(" + url + ") Failed",e); } return animeList; }
@Override public List<Anime> getAnimeListByTitle(String title) { ArrayList<Anime> animeList = new ArrayList<>(); ParseQuery<AnimeRecord> query = AnimeRecord.getQuery(); try { List<AnimeRecord> animeRecords = query.whereContains("title",title).find(); for (AnimeRecord record : animeRecords) { Anime anime = AnimeRecord.toAnime(record); if (anime != null) animeList.add(anime); } } catch (ParseException e) { WriteLog.appendLogException(TAG,"getAnimeListByTitle(" + title + ") Failed",e); } return animeList; }
public void getContactInfos(List<String> usernames,final EMValueCallBack<List<EaseUser>> callback) { ParseQuery<ParSEObject> pQuery = ParseQuery.getQuery(CONfig_TABLE_NAME); pQuery.whereContainedIn(CONfig_USERNAME,usernames); pQuery.findInBackground(new FindCallback<ParSEObject>() { @Override public void done(List<ParSEObject> arg0,ParseException arg1) { if (arg0 != null) { List<EaseUser> mList = new ArrayList<EaseUser>(); for (ParSEObject pObject : arg0) { EaseUser user = new EaseUser(pObject.getString(CONfig_USERNAME)); ParseFile parseFile = pObject.getParseFile(CONfig_AVATAR); if (parseFile != null) { user.setAvatar(parseFile.getUrl()); } user.setNick(pObject.getString(CONfig_NICK)); EaseCommonUtils.setUserInitialLetter(user); mList.add(user); } callback.onSuccess(mList); } else { callback.onError(arg1.getCode(),arg1.getMessage()); } } }); }
private void signUp(){ ParseUser user = new ParseUser(); user.setUsername(USER_NAME); user.setPassword(PASSWORD); user.setEmail(EMAIL); user.signUpInBackground(new SignUpCallback() { public void done(ParseException e) { if (e == null) { login(); Toast.makeText(getApplicationContext(),"Login cadasTrado com sucesso",Toast.LENGTH_SHORT).show(); }else{ Toast.makeText(getApplicationContext(),"Erro ao cadastrar login",Toast.LENGTH_SHORT).show(); } } }); }
public static void setUpParse(Context context) { Parse.enableLocalDatastore(context); Parse.initialize(context,"SUA_APPLICATION_ID","SUA CLIENT_KEY"); ParseInstallation.getCurrentInstallation().saveInBackground(); ParseUser.enableAutomaticUser(); ParseACL defaultACL = new ParseACL(); defaultACL.setPublicReadAccess(true); defaultACL.setPublicWriteAccess(true); ParsePush.subscribeInBackground(Constants.CHANNEL,new SaveCallback() { @Override public void done(ParseException error) { if (error == null) { Log.i(Constants.TAG,"Successfully subscribed to Parse!"); }else{ Log.i(Constants.TAG,"Error subscribed to Parse!"); } } }); }
public static void retreiveprofile(String username,final Context context) { ParseQuery<ParSEObject> query= ParseQuery.getQuery("Profile"); query.whereEqualTo("user",username); query.getFirstInBackground(new GetCallback<ParSEObject>() { @Override public void done(ParSEObject parSEObject,ParseException e) { if(parSEObject!=null && e==null) { ParseFile file = (ParseFile) parSEObject.get("image"); String url = "http://wwww.webianks.com"; if (file != null) { url = file.getUrl().toString(); } MainActivity.retriveProfileCallback(context,url); }else{ //canntretrivee file } } }); }
public static void retreivetimelineprofile(String username,ParseException e) { if(parSEObject!=null && e==null) { ParseFile file = (ParseFile) parSEObject.get("image"); String url = "http://wwww.webianks.com"; if (file != null) { url = file.getUrl().toString(); } Profile.retriveTimelineProfileCallback(context,url); }else{ //canntretrivee file } } }); }
private void runUpdate(final Event event,ArrayList<String> locations,String tag) { Log.d("FAC",tag); for (String location : locations) { String venue = event.getVenue(); venue = venue.replaceAll("\n"," "); event.setVenue(venue); if (venue.toLowerCase().contains(location)) { event.setFacultyTag(tag); event.saveInBackground(new SaveCallback() { @Override public void done(ParseException e) { Log.e("Saved:",event.getType()); } }); break; } } }
@Override public void login(String username,String password) { //Make sure parse is initialized in the Application class of the main app ParseUser.logInInBackground(username,new LogInCallback() { @Override public void done(ParseUser user,ParseException e) { if (e == null){ //User exist and authenticated,send user to Welcome.class EventBus.getDefault().post(new LoginCallbackEvent(true,null)); } else { EventBus.getDefault().post(new LoginCallbackEvent(false,e.getMessage())); } } }); }
private void verifyOrganization(){ final String enteredText = orgName.getText().toString().trim(); final RefreshingDialog rd = new RefreshingDialog(this); rd.createRefreshingDialog(); ParseQuery<Organization> query = ParseQuery.getQuery(Organization.class); query.whereEqualTo("name",enteredText); query.findInBackground(new FindCallback<Organization>() { @Override public void done(List<Organization> objects,ParseException e) { if(objects.isEmpty()){//new group createGroupAlert(enteredText); rd.stop(); }else{ joinGroupAlert(objects.get(0)); rd.stop(); } } }); }
private void userAcceptedGroup(Object org){ if(org instanceof String){ final Organization newOrg = new Organization((String)org); newOrg.saveInBackground(new SaveCallback() { @Override public void done(ParseException e) { if(e == null){ //save worked saveAndContinue(newOrg); }else{ Toast.makeText(CreateOrganization.this,"Error creating organization,please try again",Toast.LENGTH_SHORT).show(); } } }); }else{ saveAndContinue((Organization)org); } }
private void loadData() { ParseQuery<UserInfo> query = ParseQuery.getQuery(UserInfo.class); query.orderByDescending("score").setLimit(10); query.findInBackground(new FindCallback<UserInfo>() { @Override public void done(List<UserInfo> objects,ParseException e) { list.addAll(objects); runOnUiThread(new Runnable() { @Override public void run() { adapter.notifyDataSetChanged(); } }); } }); }
private void requestSessionToken(String authorizationCode) { HashMap<String,Object> params = new HashMap<>(); params.put("authorizationCode",authorizationCode); ParseCloud.callFunctionInBackground("requestSessionToken",params,new FunctionCallback<String>() { @Override public void done(String sessionToken,ParseException e) { if (e == null) { Log.d("cloud","Got back: " + sessionToken); becomeUser(sessionToken); } else { Toast.makeText(LoginActivity.this,"Login Failed",Toast.LENGTH_LONG).show(); Log.d("error",e.toString()); } } }); }
public <T> Observable<T> callFunctionForList(@NonNull String functionName,@NonNull Map<String,?> params) { Log.d(TAG,"Calling function: " + functionName + ",with params: " + params); return Observable.create(new ParseRequest<List<T>,T>("Exception while calling method " + functionName) { @NonNull @Override protected List<T> networkCall() throws ParseException { return ParseCloud.callFunction(functionName,params); } @Override protected void publishResult(@NonNull Subscriber<? super T> subscriber,@NonNull List<T> results) { for (T result : results) { subscriber.onNext(result); } } }); }
public Observable<ParseUser> signUp(@NonNull String userName,@NonNull String password,"Running sign up"); return Observable.create(new SimpleParseRequest<ParseUser>("Exception while calling signUp") { @NonNull @Override protected ParseUser networkCall() throws ParseException { final ParseUser user = new ParseUser(); user.setUsername(userName); user.setPassword(password); for (Map.Entry<String,?> param : params.entrySet()) { user.put(param.getKey(),param.getValue()); } user.signUp(); return user; } }); }
@Override public void call(Subscriber<? super T> subscriber) { if (!mCallCompleted) { synchronized (this) { if (!mCallCompleted) { try { mResult = networkCall(); } catch (ParseException e) { mParseException = e; } mCallCompleted = true; } } } if (mResult != null) { publishResult(subscriber,mResult); } else if (mParseException != null) { publishError(subscriber,mParseException); return; } // As we might not have a result for example where the return type is void,onCompleted needs to occur outside of the result // if statement. subscriber.onCompleted(); }
@Override public void onCreate() { super.onCreate(); Parse.enableLocalDatastore(this); Parse.initialize(this,"b6M7rAxtdYoUgGMgGkzmYmpDWiN2T6M8c2RTJ5Zg","Xsqyd44kUtgiOMMvwP8gyVjmdZLvXLxuynmGqqNX"); ParsePush.subscribeInBackground("Apro_2016",new SaveCallback() { @Override public void done(ParseException e) { Log.e(TAG,"Successfully subscribed to Parse!"); } }); Log.d(TAG,"not rgtd."); }
public void getContactInfos(List<String> usernames,arg1.getMessage()); } } }); }
public void localTeamList() { // Query backend ParseQuery<ParSEObject> query = ParseQuery.getQuery("T" + teamNumber); query.fromLocalDatastore().findInBackground(new FindCallback<ParSEObject>() { @Override public void done(List<ParSEObject> list,ParseException e) { // No exception,query successful if (e == null) { teams.clear(); Collections.reverse(list); for (ParSEObject object : list) { if (object.getString("team").equals("")) continue; Team team = new Team(object.getString("team"),object.getString("region"),object.getString("school"),object.getString("teamName"),object.getobjectId()); teams.add(team); } } adapter.notifyDataSetChanged(); refresh.setRefreshing(false); } }); }
public void getNodes(final Callback<List<Node>> cb) { if (nodes == null) { getNodeRelation() .getQuery() .orderByAscending(KEY_ORDER) .findInBackground(new FindCallback<Node>() { @Override public void done(List<Node> objects,ParseException e) { if (e != null) { cb.error(new Error(e.getMessage(),e.getCode())); e.printstacktrace(); } else { nodes = objects; cb.done(nodes); } } }); } else { cb.done(nodes); } }
public Bitmap getPic(){ ParseFile picFile=null; if(parseEntry!=null){ if(parseEntry.getParseFile("ProfilePic")!=null){ picFile = parseEntry.getParseFile("ProfilePic"); }; } if(picFile == null){ return null; } try { byte[] image = picFile.getData(); Bitmap pic = BitmapFactory.decodeByteArray(image,image.length); return pic; } catch (ParseException e) { e.printstacktrace(); return null; } }
public void showFavorites() { ParseQuery<Trainer> query = ParseQuery.getQuery("Trainer"); query.include("favorited_by"); query.whereEqualTo("favorited_by",SimpleUser.currentUserObject); query.findInBackground(new FindCallback<Trainer>() { public void done(List<Trainer> trainers,ParseException e) { hideProgressWheel(); if (e == null) { Log.d("DEBUG","Retrieved " + trainers.size() + " trainers"); refreshFragment(trainers); } else { Log.d("DEBUG","Error: " + e.getMessage()); } } }); }
public void autorization(){ ParseUser.logInInBackground(entLogin.getText().toString(),entPassword.getText().toString(),new LogInCallback(){ public void done(ParseUser user,ParseException e) { if (user != null) { loginok(); } else { Toast toast = Toast.makeText(getApplicationContext(),"Incorect login or password",duration); toast.show(); // Signup Failed. Look at the ParseException to see what happened. } } }); }
public void addCommentTask(){ ParseQuery<ParSEObject> query = ParseQuery.getQuery("BullshITBankDB"); query.whereEqualTo("phone",Phone); query.getFirstInBackground(new GetCallback<ParSEObject>() { @Override public void done(ParSEObject parSEObject,ParseException e) { Log.d("TAG","Done Loading Detail!"); String NewComment = AddComment.getText().toString(); List<String> CommentsList = parSEObject.getList("comments"); if(CommentsList==null){ CommentsList = new ArrayList<String>(); } CommentsList.add(NewComment+"["+GUID+"]"); parSEObject.put("comments",CommentsList); parSEObject.saveInBackground(); loadDetail(); } }); }
public void addCommentTask(String Number,final String Comment,final String GUID){ ParseQuery<ParSEObject> query = ParseQuery.getQuery("BullshITBankDB"); query.whereEqualTo("phone",Number); query.getFirstInBackground(new GetCallback<ParSEObject>() { @Override public void done(ParSEObject parSEObject,"Done Loading Detail!"); List<String> CommentsList = parSEObject.getList("comments"); if(CommentsList==null){ CommentsList = new ArrayList<String>(); } CommentsList.add(Comment+"["+GUID+"]"); parSEObject.put("comments",CommentsList); parSEObject.saveInBackground(); } }); }
public void addBullshITBank(final String NewNumber){ if(NewNumber.length()<6){ Toast.makeText(mContext,getResources().getString(R.string.too_short),Toast.LENGTH_LONG).show(); }else{ ParseQuery<ParSEObject> query = ParseQuery.getQuery("BullshITBankDB"); query.whereStartsWith("phone",NewNumber); query.findInBackground(new FindCallback<ParSEObject>() { @Override public void done(List<ParSEObject> parSEObjects,ParseException e) { if (parSEObjects.size() > 0) { Toast.makeText(mContext,getResources().getString(R.string.duplicate),Toast.LENGTH_LONG).show(); } else { FragmentManager fragmentManager = getSupportFragmentManager(); DialogFragment ConfirmDialog = AddNewConfirmDialog.newInstance(NewNumber,GUID); ConfirmDialog.show(fragmentManager,"confirmdialog"); } } }); } }
public void setUsersImagetoParse(String username,final File image){ ParseQuery<ParseUser> query = ParseUser.getQuery(); query.whereEqualTo("username",username); query.getFirstInBackground(new GetCallback<ParseUser>() { public void done(ParseUser UsersClass,ParseException e) { if (UsersClass == null) { Log.d("score","no success setUsersImagetoParse"); } else { //success UsersClass.put("ProfilePic",image); UsersClass.saveInBackground(); pullParseAndSetotherUsersDatainBackground(); } } }); }
public static void getMatches(final ActionDataCallbacks callbacks) { ParseQuery<ParSEObject> query = new ParseQuery<ParSEObject>(TABLE_NAME); query.whereEqualTo(COLUMN_BY_USER,ParseUser.getCurrentUser().getobjectId()); query.whereEqualTo(COLUMN_TYPE,TYPE_MATCHED); query.orderByDescending(COLUMN_UPDATED_AT); query.findInBackground(new FindCallback<ParSEObject>() { @Override public void done(List<ParSEObject> list,ParseException e) { if(e == null) { List<String> ids = new ArrayList<String>(); for(ParSEObject object : list) { ids.add(object.getString(COLUMN_TO_USER)); } if(callbacks != null) { callbacks.onFetchedMatches(ids); } } } }); }
private void getFacebookInfo() { Bundle parameters = new Bundle(); parameters.putString("fields","picture,first_name,id"); new GraphRequest(Accesstoken.getCurrentAccesstoken(),"/me",parameters,HttpMethod.GET,new GraphRequest.Callback() { @Override public void onCompleted(GraphResponse graphResponse) { JSONObject user = graphResponse.getJSONObject(); ParseUser currentUser = ParseUser.getCurrentUser(); currentUser.put("firstName",user.optString("first_name")); currentUser.put("facebookId",user.optString("id")); currentUser.put("pictureURL",user.optJSONObject("picture").optJSONObject("data").optString("url")); currentUser.saveInBackground(new SaveCallback() { @Override public void done(ParseException e) { if(e == null) { Log.i(TAG,"User saved"); setResult(RESULT_OK); finish(); } } }); } }).executeAsync(); }
/** * This is where the bulk of our work is done. This function is * called in a background thread and should generate a new set of * data to be published by the loader. */ @Override @SuppressWarnings("unchecked") public List<T> loadInBackground() { if (mParseQuery == null) { return Collections.emptyList(); } try { return mForceLoadEverything ? findAll(mParseQuery) : loadobjects(mPagetoLoad); } catch (ParseException e) { if (BuildConfig.DEBUG) { Log.w(TAG,"Load interrupted with ParseException " + e.getCode() + ": " + e.getMessage()); } return Collections.emptyList(); } }
关于萨克斯-ExpatParser $ ParseException和萨克斯十大名曲播放的问题就给大家分享到这里,感谢你花时间阅读本站内容,更多关于'按转换顺序排序(c.name使用gbk)',net.sf.jsqlparser.parser.ParseException:遇到意外的令牌:“(”“(”、android点滴1:SAXParseException、com.github.pagehelper.PageException: 处理排序失败: net.sf.jsqlparser.JSQLParserException、com.parse.ParseException的实例源码等相关知识的信息别忘了在本站进行查找喔。
本文标签: