错误信息:
Exception in thread "main" java.lang.NoClassDefFoundError: net/sf/jsqlparser/expression/Expression
at com.github.pagehelper.dialect.AbstractDialect.<init>(AbstractDialect.java:45)
at com.github.pagehelper.dialect.AbstractHelperDialect.<init>(AbstractHelperDialect.java:52)
at com.github.pagehelper.dialect.helper.MySqlDialect.<init>(MySqlDialect.java:43)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at com.github.pagehelper.page.PageAutoDialect.initDialect(PageAutoDialect.java:146)
at com.github.pagehelper.page.PageAutoDialect.getDialect(PageAutoDialect.java:208)
at com.github.pagehelper.page.PageAutoDialect.initDelegateDialect(PageAutoDialect.java:88)
at com.github.pagehelper.PageHelper.skip(PageHelper.java:65)
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:92)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
at com.sun.proxy.$Proxy3.query(Unknown Source)
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.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.$Proxy4.queryEmpPage(Unknown Source)
at com.huanzhen.main.testMain2.main(testMain2.java:47)
Caused by: java.lang.ClassNotFoundException: net.sf.jsqlparser.expression.Expression
at java.net.URLClassLoader$1.run(Unknown Source)
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
... 22 more
实际上我们在使用MyBatis分页插件的时候,需要导入两个Jar包,分别为pagehelper-5.1.2.jar
、jsqlparser-1.0.jar
上面这个错误实际上是由于没有导入jsqlparser-1.0.jar这个包所导致的错误!我们把jsqlparser-1.0.jar这个包导入即可!(此处的版本号可忽略,建议使用上面两个版本,避免报错)
注:可点击上面的链接进入下载,若不能下载,请在评论下方留下你的邮箱,有时间会发给你!