如何通过网络服务将Android应用程序与mysql DB进行通信



我正在为智能购物系统制作一个Android应用程序。我想:-

  1. 制作一个可以创建有关产品信息的二维码的网络应用程序(即具有产品唯一 ID 的二维码)。所有这些信息都应该存储在MySQL中

  2. 此二维码将包含一个类似 URLhttp://localhost:8080/Mysupermarket/index.jsp/pid=1(像这样)

  3. 客户将扫描二维码并被定向到此页面,并且他应该以某种方式获取该产品在数据库中的所有详细信息存储。

4.所有这些数据都应转换为字符串,以便我的应用程序可以转换为语音

到目前为止,我做了什么?

http://codeoncloud.blogspot.in/2012/03/android-mysql-client.html

我遵循了本教程,它使用 SOAP Web 服务。但是当我在服务器上运行 web 应用程序并单击列表服务时,它抛出了此异常

java.lang.NoClassDefFoundError:
org/apache/ws/commons/schema/resolver/URIResolver
        at org.apache.axis2.deployment.ModuleDeployer.deploy(ModuleDeployer.java:128)
        at org.apache.axis2.deployment.repository.util.DeploymentFileData.deploy(DeploymentFileData.java:144)
        at org.apache.axis2.deployment.DeploymentEngine.doDeploy(DeploymentEngine.java:585)
        at org.apache.axis2.deployment.RepositoryListener.init(RepositoryListener.java:264)
        at org.apache.axis2.deployment.RepositoryListener.init2(RepositoryListener.java:66)
        at org.apache.axis2.deployment.RepositoryListener.<init>(RepositoryListener.java:61)
        at org.apache.axis2.deployment.DeploymentEngine.loadRepository(DeploymentEngine.java:152)
        at org.apache.axis2.deployment.WarBasedAxisConfigurator.getAxisConfiguration(WarBasedAxisConfigurator.java:233)
        at org.apache.axis2.context.ConfigurationContextFactory.createConfigurationContext(ConfigurationContextFactory.java:64)
        at org.apache.axis2.transport.http.AxisServlet.initConfigContext(AxisServlet.java:620)
        at org.apache.axis2.transport.http.AxisServlet.init(AxisServlet.java:471)
        at org.apache.axis2.webapp.AxisAdminServlet.init(AxisAdminServlet.java:60)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1231)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1144)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1031)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4997)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5289)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1408)
        at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1398)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
    Caused by: java.lang.ClassNotFoundException: org.apache.ws.commons.schema.resolver.URIResolver
        at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1333)
        at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1167)
        ... 24 more
    Apr 24, 2016 8:48:37 PM org.apache.catalina.core.StandardContext loadOnStartup
    SEVERE: Servlet [AxisAdminServlet] in web application [/WebApp] threw load() exception
    java.lang.ClassNotFoundException: org.apache.ws.commons.schema.resolver.URIResolver
        at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1333)
        at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1167)
        at org.apache.axis2.deployment.ModuleDeployer.deploy(ModuleDeployer.java:128)
        at org.apache.axis2.deployment.repository.util.DeploymentFileData.deploy(DeploymentFileData.java:144)
        at org.apache.axis2.deployment.DeploymentEngine.doDeploy(DeploymentEngine.java:585)
        at org.apache.axis2.deployment.RepositoryListener.init(RepositoryListener.java:264)
        at org.apache.axis2.deployment.RepositoryListener.init2(RepositoryListener.java:66)
        at org.apache.axis2.deployment.RepositoryListener.<init>(RepositoryListener.java:61)
        at org.apache.axis2.deployment.DeploymentEngine.loadRepository(DeploymentEngine.java:152)
        at org.apache.axis2.deployment.WarBasedAxisConfigurator.getAxisConfiguration(WarBasedAxisConfigurator.java:233)
        at org.apache.axis2.context.ConfigurationContextFactory.createConfigurationContext(ConfigurationContextFactory.java:64)
        at org.apache.axis2.transport.http.AxisServlet.initConfigContext(AxisServlet.java:620)
        at org.apache.axis2.transport.http.AxisServlet.init(AxisServlet.java:471)
        at org.apache.axis2.webapp.AxisAdminServlet.init(AxisAdminServlet.java:60)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1231)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1144)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1031)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4997)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5289)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1408)
        at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1398)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
    Apr 24, 2016 8:48:38 PM org.apache.catalina.startup.HostConfig deployDirectory
    INFO: Deploying web application directory C:apache-tomcat-8.0.30webappsdocs
    Apr 24, 2016 8:48:38 PM org.apache.catalina.startup.HostConfig deployDirectory
    INFO: Deployment of web application directory C:apache-tomcat-8.0.30webappsdocs has finished in 47 ms
    Apr 24, 2016 8:48:38 PM org.apache.catalina.startup.HostConfig deployDirectory
    INFO: Deploying web application directory C:apache-tomcat-8.0.30webappsexamples
    Apr 24, 2016 8:48:38 PM org.apache.catalina.core.ApplicationContext log
    INFO: ContextListener: contextInitialized()
    Apr 24, 2016 8:48:38 PM org.apache.catalina.core.ApplicationContext log
    INFO: SessionListener: contextInitialized()
    Apr 24, 2016 8:48:38 PM org.apache.catalina.startup.HostConfig deployDirectory
    INFO: Deployment of web application directory C:apache-tomcat-8.0.30webappsexamples has finished in 563 ms
    Apr 24, 2016 8:48:38 PM org.apache.catalina.startup.HostConfig deployDirectory
    INFO: Deploying web application directory C:apache-tomcat-8.0.30webappshost-manager
    Apr 24, 2016 8:48:38 PM org.apache.catalina.startup.HostConfig deployDirectory
    INFO: Deployment of web application directory C:apache-tomcat-8.0.30webappshost-manager has finished in 46 ms
    Apr 24, 2016 8:48:38 PM org.apache.catalina.startup.HostConfig deployDirectory
    INFO: Deploying web application directory C:apache-tomcat-8.0.30webappsmanager
    Apr 24, 2016 8:48:38 PM org.apache.catalina.startup.HostConfig deployDirectory
    INFO: Deployment of web application directory C:apache-tomcat-8.0.30webappsmanager has finished in 32 ms
    Apr 24, 2016 8:48:38 PM org.apache.catalina.startup.HostConfig deployDirectory
    INFO: Deploying web application directory C:apache-tomcat-8.0.30webappsROOT
    Apr 24, 2016 8:48:38 PM org.apache.catalina.startup.HostConfig deployDirectory
    INFO: Deployment of web application directory C:apache-tomcat-8.0.30webappsROOT has finished in 62 ms
    Apr 24, 2016 8:48:38 PM org.apache.coyote.AbstractProtocol start
    INFO: Starting ProtocolHandler ["http-nio-8080"]
    Apr 24, 2016 8:48:38 PM org.apache.coyote.AbstractProtocol start
    INFO: Starting ProtocolHandler ["ajp-nio-8009"]
    Apr 24, 2016 8:48:38 PM org.apache.catalina.startup.Catalina start
    INFO: Server startup in 4629 ms
    [INFO] Clustering has been disabled
    [WARN] Unable to instantiate deployer org.apache.axis2.deployment.ServiceDeployer; see debug logs for more details
    Apr 24, 2016 8:48:42 PM org.apache.catalina.core.ApplicationContext log
    SEVERE: StandardWrapper.Throwable
    java.lang.NoClassDefFoundError: org/apache/ws/commons/schema/resolver/URIResolver
        at org.apache.axis2.deployment.ModuleDeployer.deploy(ModuleDeployer.java:128)
        at org.apache.axis2.deployment.repository.util.DeploymentFileData.deploy(DeploymentFileData.java:144)
        at org.apache.axis2.deployment.DeploymentEngine.doDeploy(DeploymentEngine.java:585)
        at org.apache.axis2.deployment.RepositoryListener.init(RepositoryListener.java:264)
        at org.apache.axis2.deployment.RepositoryListener.init2(RepositoryListener.java:66)
        at org.apache.axis2.deployment.RepositoryListener.<init>(RepositoryListener.java:61)
        at org.apache.axis2.deployment.DeploymentEngine.loadRepository(DeploymentEngine.java:152)
        at org.apache.axis2.deployment.WarBasedAxisConfigurator.getAxisConfiguration(WarBasedAxisConfigurator.java:233)
        at org.apache.axis2.context.ConfigurationContextFactory.createConfigurationContext(ConfigurationContextFactory.java:64)
        at org.apache.axis2.transport.http.AxisServlet.initConfigContext(AxisServlet.java:620)
        at org.apache.axis2.transport.http.AxisServlet.init(AxisServlet.java:471)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1231)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1144)
        at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:817)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:135)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:521)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1096)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:674)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Unknown Source)
    Caused by: java.lang.ClassNotFoundException: org.apache.ws.commons.schema.resolver.URIResolver
        at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1333)
        at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1167)
        ... 30 more
    Apr 24, 2016 8:48:42 PM org.apache.catalina.core.StandardWrapperValve invoke
    SEVERE: Allocate exception for servlet AxisServlet
    java.lang.ClassNotFoundException: org.apache.ws.commons.schema.resolver.URIResolver
        at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1333)
        at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1167)
        at org.apache.axis2.deployment.ModuleDeployer.deploy(ModuleDeployer.java:128)
        at org.apache.axis2.deployment.repository.util.DeploymentFileData.deploy(DeploymentFileData.java:144)
        at org.apache.axis2.deployment.DeploymentEngine.doDeploy(DeploymentEngine.java:585)
        at org.apache.axis2.deployment.RepositoryListener.init(RepositoryListener.java:264)
        at org.apache.axis2.deployment.RepositoryListener.init2(RepositoryListener.java:66)
        at org.apache.axis2.deployment.RepositoryListener.<init>(RepositoryListener.java:61)
        at org.apache.axis2.deployment.DeploymentEngine.loadRepository(DeploymentEngine.java:152)
        at org.apache.axis2.deployment.WarBasedAxisConfigurator.getAxisConfiguration(WarBasedAxisConfigurator.java:233)
        at org.apache.axis2.context.ConfigurationContextFactory.createConfigurationContext(ConfigurationContextFactory.java:64)
        at org.apache.axis2.transport.http.AxisServlet.initConfigContext(AxisServlet.java:620)
        at org.apache.axis2.transport.http.AxisServlet.init(AxisServlet.java:471)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1231)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1144)
        at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:817)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:135)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:521)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1096)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:674)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Unknown Source)

我该如何解决?另外,请推荐一些有关如何将Android应用程序连接到Web服务的好教程。他们中的大多数都在使用PHP。我想使用Java。

提前致谢

此错误

看起来像构建路径问题。必须向应用程序添加依赖项;正确的依赖关系是;

    <dependency>
        <groupId>org.apache.ws.commons.schema</groupId>
        <artifactId>XmlSchema</artifactId>
        <version>1.3.2</version>
    </dependency>

最新更新