mysql连接不上,急!! 10C

八�� 16, 2018 9:49:01 上午 org.apache.catalina.loader.WebappClassLoaderBase checkStateForResourceLoading
信息: Illegal access: this web application instance has been stopped already. Could not load [com.alibaba.druid.pool.DruidDataSource]. The following stack trace is thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access.
java.lang.IllegalStateException: Illegal access: this web application instance has been stopped already. Could not load [com.alibaba.druid.pool.DruidDataSource]. The following stack trace is thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access.
at org.apache.catalina.loader.WebappClassLoaderBase.checkStateForResourceLoading(WebappClassLoaderBase.java:1359)
at org.apache.catalina.loader.WebappClassLoaderBase.checkStateForClassLoading(WebappClassLoaderBase.java:1347)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1206)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1167)
at org.apache.logging.log4j.util.LoaderUtil.loadClass(LoaderUtil.java:139)
at org.apache.logging.log4j.core.impl.ThrowableProxy.loadClass(ThrowableProxy.java:548)
at org.apache.logging.log4j.core.impl.ThrowableProxy.toExtendedStackTrace(ThrowableProxy.java:660)
at org.apache.logging.log4j.core.impl.ThrowableProxy.(ThrowableProxy.java:163)
at org.apache.logging.log4j.core.impl.ThrowableProxy.(ThrowableProxy.java:140)
at org.apache.logging.log4j.core.impl.ThrowableProxy.(ThrowableProxy.java:121)
at org.apache.logging.log4j.core.impl.Log4jLogEvent.getThrownProxy(Log4jLogEvent.java:555)
at org.apache.logging.log4j.core.pattern.ExtendedThrowablePatternConverter.format(ExtendedThrowablePatternConverter.java:61)
at org.apache.logging.log4j.core.pattern.PatternFormatter.format(PatternFormatter.java:38)
at org.apache.logging.log4j.core.layout.PatternLayout$PatternSerializer.toSerializable(PatternLayout.java:294)
at org.apache.logging.log4j.core.layout.PatternLayout.toText(PatternLayout.java:195)
at org.apache.logging.log4j.core.layout.PatternLayout.encode(PatternLayout.java:180)
at org.apache.logging.log4j.core.layout.PatternLayout.encode(PatternLayout.java:57)
at org.apache.logging.log4j.core.appender.AbstractOutputStreamAppender.directEncodeEvent(AbstractOutputStreamAppender.java:176)
at org.apache.logging.log4j.core.appender.AbstractOutputStreamAppender.tryAppend(AbstractOutputStreamAppender.java:169)
at org.apache.logging.log4j.core.appender.AbstractOutputStreamAppender.append(AbstractOutputStreamAppender.java:160)
at org.apache.logging.log4j.core.config.AppenderControl.tryCallAppender(AppenderControl.java:156)
at org.apache.logging.log4j.core.config.AppenderControl.callAppender0(AppenderControl.java:129)
at org.apache.logging.log4j.core.config.AppenderControl.callAppenderPreventRecursion(AppenderControl.java:120)
at org.apache.logging.log4j.core.config.AppenderControl.callAppender(AppenderControl.java:84)
at org.apache.logging.log4j.core.config.LoggerConfig.callAppenders(LoggerConfig.java:447)
at org.apache.logging.log4j.core.config.LoggerConfig.processLogEvent(LoggerConfig.java:432)
at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:416)
at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:402)
at org.apache.logging.log4j.core.config.AwaitCompletionReliabilityStrategy.log(AwaitCompletionReliabilityStrategy.java:63)
at org.apache.logging.log4j.core.Logger.logMessage(Logger.java:146)
at org.apache.logging.log4j.spi.AbstractLogger.logMessageSafely(AbstractLogger.java:2091)
at org.apache.logging.log4j.spi.AbstractLogger.logMessage(AbstractLogger.java:2011)
at org.apache.logging.log4j.spi.AbstractLogger.logIfEnabled(AbstractLogger.java:1884)
at org.apache.logging.slf4j.Log4jLogger.error(Log4jLogger.java:309)
at org.activiti.engine.impl.jobexecutor.AcquireJobsRunnableImpl.run(AcquireJobsRunnableImpl.java:77)
at java.lang.Thread.run(Thread.java:745)

[ERROR] [2018-08-16 09:49:01] [Class=org.activiti.engine.impl.jobexecutor.AcquireJobsRunnableImpl | Method=run | Line=77] | exception during job acquisition: Could not open JDBC Connection for transaction; nested exception is com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Aug 16 09:48:53 CST 2018
org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Aug 16 09:48:53 CST 2018
at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:245) ~[spring-jdbc-4.1.5.RELEASE.jar:4.1.5.RELEASE]
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373) ~[spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE]
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130) ~[spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE]
at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45) ~[activiti-spring-5.22.0.jar:5.22.0]
at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31) ~[activiti-engine-5.22.0.jar:5.22.0]
at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40) ~[activiti-engine-5.22.0.jar:5.22.0]
at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35) ~[activiti-engine-5.22.0.jar:5.22.0]
at org.activiti.engine.impl.jobexecutor.AcquireJobsRunnableImpl.run(AcquireJobsRunnableImpl.java:54) [activiti-engine-5.22.0.jar:5.22.0]
at java.lang.Thread.run(Thread.java:745) [?:1.8.0_40]
Caused by: com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed at Thu Aug 16 09:48:53 CST 2018
at com.alibaba.druid.pool.DruidDataSource.getConnectionInternal(DruidDataSource.java:1340) ~[druid-1.1.5.jar:1.1.5]
at com.alibaba.druid.pool.DruidDataSource.getConnectionDirect(DruidDataSource.java:1241) ~[druid-1.1.5.jar:1.1.5]
at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:4619) ~[druid-1.1.5.jar:1.1.5]
at com.alibaba.druid.filter.FilterAdapter.dataSource_getConnection(FilterAdapter.java:2745) ~[druid-1.1.5.jar:1.1.5]
at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:4615) ~[druid-1.1.5.jar:1.1.5]
at com.alibaba.druid.filter.stat.StatFilter.dataSource_getConnection(StatFilter.java:680) ~[druid-1.1.5.jar:1.1.5]
at com.alibaba.druid.filter.FilterChainImpl.dataSource_connect(FilterChainImpl.java:4615) ~[druid-1.1.5.jar:1.1.5]
at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1219) ~[druid-1.1.5.jar:1.1.5]
at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1211) ~[druid-1.1.5.jar:1.1.5]
at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:105) ~[druid-1.1.5.jar:1.1.5]
at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:204) ~[spring-jdbc-4.1.5.RELEASE.jar:4.1.5.RELEASE]
... 8 more

11个回答

this web application instance has been stopped already你是不是开启了自动加载?手动重启tomcat看下看看,如果不行,贴日志

应该是取不到数据源 ,先检查配置文件,然后cmd试试本地能不能连上数据库,数据库版本或者jdbc相关的jar的版本都有可能导致这个问题

本地都能连上数据库,昨天还好好的,今天启动这个项目就成这样了,tomcat也重新删除在添加,还是这有

zhaoxuyang1997
zxy97 厉害厉害,阿里巴巴的
大约一年之前 回复

Could not open JDBC Connection for transaction; nested exception is com.alibaba.druid.pool.DataSourceClosedException: dataSource already closed
看下为什么jdbc连接关闭了,是不是你自己关闭了然后又去访问,或者连接配置不对,没有打开。

qq_42986290
qq_42986290 this web application instance has been stopped already你是不是开启了自动加载?手动重启tomcat看下看看,如果不行,贴日志
大约一年之前 回复
weixin_38660131
weixin_38660131 本地都能连上数据库,昨天还好好的,今天启动这个项目就成这样了,tomcat也重新删除在添加,还是这有
大约一年之前 回复

https://blog.csdn.net/wwrzyy/article/details/78036542?fps=1&locationNum=8
看看这篇文字跟你的问题是一样的。。他写的比较详细,我就不多说了
原因是:因为在定时器中手动获取了 DataSource,然后使用后关闭了或者用完后长期不再用被连接池自动关闭
记得给悬赏。3Q

你连的是本地的mysql数据库还是远程的?然后看一下mysql的服务有开吗?在任务管理器里面查看——》服务

本地是ssh跳转链接的吗?Bitvise SSH Client用这个软件映射就可了

他报的非法路径啊。你看看你的路径配的有没有问题

DruidDataSource是不是在这里面配的 数据库连接 仔细检查一下

应该是tomcat的问题,tomcat中的插件没有运行起来,如果重启tomcat不好使的话就换一个版本的tomcat试试

共11条数据 1 尾页
Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
(急)mySQL连接不上?
调试程序时出现了下面的问题:(MySQL服务是启动了的)rnrnrnWarning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'localhost' (10061) in D:\MYOA\webroot\liuyanban\index.php on line 2rnrnWarning: mysql_select_db() [function.mysql-select-db]: Access denied for user: 'ODBC@localhost' (Using password: NO) in D:\MYOA\webroot\liuyanban\index.php on line 3rnrnWarning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in D:\MYOA\webroot\liuyanban\index.php on line 3rnrnWarning: mysql_query() [function.mysql-query]: Access denied for user: 'ODBC@localhost' (Using password: NO) in D:\MYOA\webroot\liuyanban\index.php on line 4rnrnWarning: mysql_query() [function.mysql-query]: A link to the server could not be established in D:\MYOA\webroot\liuyanban\index.php on line 4rnrnWarning: mysql_query() [function.mysql-query]: Access denied for user: 'ODBC@localhost' (Using password: NO) in D:\MYOA\webroot\liuyanban\index.php on line 6rnrnWarning: mysql_query() [function.mysql-query]: A link to the server could not be established in D:\MYOA\webroot\liuyanban\index.php on line 6rnrnWarning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in D:\MYOA\webroot\liuyanban\index.php on line 7rn
mysql 连接不上?
我的mysql 为什么连接不上呀?rn是我连本机器 本机IP:192。168。1。54rn user:rootrn pwd:空rn rn它提示我的错误代码1130:连接数据库失败,没有连接数据库的权限rn这是为什么呀?
连接不上MySql
用管理员身份运行PowerShell bash sudo service mysql status, 可以看到服务器状态已停止 sudo service mysql start
连接不上mysql
[root bin]#./mysqlrnERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
连接不上MySQL!!!!!!!!!
我的操作系统是WINDOWS 2K P,WEB服务器是APACHE+PHP+MySQL。以前使用一切正常,可是最近用APACHE调用PHP却连接不上MySQL服务器了,而用MySQL自带的客户端软件(mysql.exe)却可以正常使用,请问各位大虾如何解决???
MySQL连接不上
电脑还原后重装MySQL,重装时步骤可能和以前不太一样(端口变成了8089),数据库安装算是成功吧,MySQL数据库显示正常。但用以前的程序改端口连接不上了,不知什么原因,希望各路高手为我解题。rn[code=Java]The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.rn at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)rn at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)rn at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)rn at java.lang.reflect.Constructor.newInstance(Constructor.java:513)rn at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)rn at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)rn at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2209)rn at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:776)rn at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:46)rn at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)rn at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)rn at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)rn at java.lang.reflect.Constructor.newInstance(Constructor.java:513)rn at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)rn at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352)rn at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:284)rn at java.sql.DriverManager.getConnection(DriverManager.java:582)rn at java.sql.DriverManager.getConnection(DriverManager.java:154)rn at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:174)rn at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:165)rn at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:149)rn at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:119)rn at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:82)rn at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)rn ... 26 morernCaused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure[/code]
mysql连接不上
mysql连接不上,日志中的错误信息:Can't open and lock privilege tables: Table 'mysql.host' doesn't exist,网上查了下可以将老的数据权限表复制到当前的数据目录,不过老的被删除了啊,请教各位有还有什么办法么,难道只能重装了?
求助:mysql在。net下连接不上。急~~~~
环境:rn mysql版本是:mysql-noinstall-5.1.3-alpha-win32rn odbc的版本是:mysql-connector-odbc-5.0.0-alpha-win32.msirn 用mysqlcc数据库中建立一个数据库com,里面有个test表rn过程:rn 1,在odbc中建立mysql的连接:datasourcename:myodbcrn server:localhostrn user:rootrn database:comrn 测试连接成功rnrn 2,在.net中建立数据库连接:rn 使用数据库连接里面选择:myodbcrn 输入登陆服务器信息中:用户名:root 密码:(为空)rn 测试连接:成功rnrn 3,在服务器资源管理里面:rn 数据库:选择刚刚建好的数据库连接rn 连接上,点击表的checkbox的方框,没发现表rnrn怎么回事啊?感觉好像odbc没有连上数据库rnrn很急啊,求解决方案rn
navicat连接不上mysql
我这有2个Mysql,一开始把mysql启动了,把端口占用了,其实应该启动mysql80 解决:百度搜索2059 https://blog.csdn.net/kwy15732621629/article/details/80059416 原因:8.0版本太高了 ...
为什么连接不上MYSQL
第一次写PHP 即遇到困惑 郁闷rnrn以上程序运行时一片空白 什么都没有rn其他一般的PHP程序可以运行的rnrn发生了什么事??
Linux下连接不上MySQL
我用的是MySQL3.23.55,也装了Connector/J3.0,运行时tomcat显示”Server configuration denies access to data source”,可我已经把Connector中的jar文件放到了Tomcat下的/common/lib的下面,也执行了“grant all privileges on guest.* to root@localhost identified by [password];”,为什么呢?哪位能够指点迷津。
远程连接mySQL连接不上!
现象:在自己电脑可以连上,在自己电脑的虚拟机里面也可以连接上,但是程序拷贝到其他电脑上连接就连接不上,不知道问题出在哪里了,请高手指教:
PHP连接不上mysql
rnrn应该没什么问题吧,可是怎么一直报错,ACCESS DENIEDrnrn";rn$amount_sql = "SELECT MAX(PATH_ID) FROM pathwayrn LIMIT 1;";rn$result_amount = mysql_query($amount_sql);rn$pathway_array = mysql_fetch_assoc($result_amount);rn$pathway_amount = $pathway_array['PATH_ID'];rn?>rn下面为报错的内容!rnWarning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\xampp\htdocs\pathway\colon bacillus system.php on line 36rnrnWarning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\xampp\htdocs\pathway\colon bacillus system.php on line 36rnrnWarning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\pathway\colon bacillus system.php on line 37
mysql一直连接不上
我昨天写的php还可以对mysql进行操作,今天重启电脑以后就一直显示unable to connectrn
hive连接不上mysql
请问hive连接mysql出现这个错误 是什么原因?rn[img=https://img-bbs.csdn.net/upload/201704/13/1492074653_934022.jpg][/img]
局域网连接不上mysql
我用Navicat连接局域网的mysql,出现错误:Host:192.168.1.240 is not allowed to connect to this mysql serverrn192.168.1.240 进入客户端,修改了mysql数据库中user表的user=root的host为%,还是不行。在我的电脑上telnet 192.168.1.240 3306 出现了一下错误:192.168.1.188 is not allowed to connect to this mysql serverrn失去了跟主机的联系。rnrnrn请问高手这个改怎么解决。我现在用Navicat连不上这个数据库了
phpmyadmin连接不上mysql
环境:windows2003+IIS6+mysql6+phpmyadmin10.1rnrnmysql已经安装好,并能在命令行下正常登录使用;rnrn rn显示有内容rnrn rn显示成功;rnrnrnrn但phpmyadmin出现以下结果:rn____________________________________________________________________rn欢迎使用 phpMyAdmin 2.10.1rnrnphpMyAdmin 试图连接到 MySQL 服务器,但服务器拒绝连接。您应该检查 config.inc.php 中的主机、用户名和密码,并且确定这些信息与 MySQL 服务器的管理员所给出的信息一致。rnrn错误rnMySQL 返回: rnrn#1045 - Access denied for user 'root'@'localhost' (using password: NO) rn____________________________________________________________________rnrn但config.inc.php我已经设置完了,填写都应该是正确的。rnrnrn rnrnrn
MySQL外网连接不上
遇到如上问题,一直以为是root帐号没有远程访问的权限。 可是修改了user表里面的root的Host为%并没有暖用。 找了很久原因,用netstat -tunlp命令看了下监听的端口情况 发现: tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN      8954/mysqld
php连接不上mysql
使用下面语句测试,结果浏览器什么也不显示rnrn';rnif(mysqli_connect_errno())rnrn echo "连接失败";rnrnrnelsern echo "连接成功";rn$link->close();rn?>rnrn
eclpise连接不上mysql
七月 25, 2017 5:33:54 下午 org.apache.tomcat.util.digester.SetPropertiesRule beginn警告: [SetPropertiesRule]Server/Service/Engine/Host/Context Setting property 'source' to 'org.eclipse.jst.jee.server:1' did not find a matching property.n七月 25, 2017 5:33:54 下午 org.apache.catalina.startup.VersionLoggerListener logn信息: Server version: Apache Tomcat/9.0.0.M21n七月 25, 2017 5:33:54 下午 org.apache.catalina.startup.VersionLoggerListener logn信息: Server built: May 4 2017 22:42:36 UTCn七月 25, 2017 5:33:54 下午 org.apache.catalina.startup.VersionLoggerListener logn信息: Server number: 9.0.0.0n七月 25, 2017 5:33:54 下午 org.apache.catalina.startup.VersionLoggerListener logn信息: OS Name: Windows 10n七月 25, 2017 5:33:54 下午 org.apache.catalina.startup.VersionLoggerListener logn信息: OS Version: 10.0n七月 25, 2017 5:33:54 下午 org.apache.catalina.startup.VersionLoggerListener logn信息: Architecture: x86n七月 25, 2017 5:33:54 下午 org.apache.catalina.startup.VersionLoggerListener logn信息: Java Home: C:\Program Files\Java\jre1.8.0_131n七月 25, 2017 5:33:54 下午 org.apache.catalina.startup.VersionLoggerListener logn信息: JVM Version: 1.8.0_131-b11n七月 25, 2017 5:33:54 下午 org.apache.catalina.startup.VersionLoggerListener logn信息: JVM Vendor: Oracle Corporationn七月 25, 2017 5:33:54 下午 org.apache.catalina.startup.VersionLoggerListener logn信息: CATALINA_BASE: E:\Java 项目\.metadata\.plugins\org.eclipse.wst.server.core\tmp0n七月 25, 2017 5:33:54 下午 org.apache.catalina.startup.VersionLoggerListener logn信息: CATALINA_HOME: F:\java web\apache-tomcat-9.0.0.M21n七月 25, 2017 5:33:54 下午 org.apache.catalina.startup.VersionLoggerListener logn信息: Command line argument: -Dcatalina.base=E:\Java 项目\.metadata\.plugins\org.eclipse.wst.server.core\tmp0n七月 25, 2017 5:33:54 下午 org.apache.catalina.startup.VersionLoggerListener logn信息: Command line argument: -Dcatalina.home=F:\java web\apache-tomcat-9.0.0.M21n七月 25, 2017 5:33:54 下午 org.apache.catalina.startup.VersionLoggerListener logn信息: Command line argument: -Dwtp.deploy=E:\Java 项目\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebappsn七月 25, 2017 5:33:54 下午 org.apache.catalina.startup.VersionLoggerListener logn信息: Command line argument: -Djava.endorsed.dirs=F:\java web\apache-tomcat-9.0.0.M21\endorsedn七月 25, 2017 5:33:54 下午 org.apache.catalina.startup.VersionLoggerListener logn信息: Command line argument: -Dfile.encoding=UTF-8n七月 25, 2017 5:33:54 下午 org.apache.catalina.core.AprLifecycleListener lifecycleEventn信息: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: [C:\Program Files\Java\jre1.8.0_131\bin;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:/Program Files/Java/jre1.8.0_131/bin/client;C:/Program Files/Java/jre1.8.0_131/bin;C:/Program Files/Java/jre1.8.0_131/lib/i386;C:\ProgramData\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files\Intel\OpenCL SDK\3.0\bin\x86;C:\Program Files\Windows Kits\8.1\Windows Performance Toolkit\;C:\Program Files\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files\Microsoft SDKs\TypeScript\1.0\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\MySQL\MySQL Server 5.7\bin;C:\Program Files\Java\jdk1.8.0_131\bin;C:\Program Files\Java\jdk1.8.0_131\jre\bin;F:\eclipse;;.]n七月 25, 2017 5:33:54 下午 org.apache.coyote.AbstractProtocol initn信息: Initializing ProtocolHandler ["http-nio-8181"]n七月 25, 2017 5:33:55 下午 org.apache.tomcat.util.net.NioSelectorPool getSharedSelectorn信息: Using a shared selector for servlet write/readn七月 25, 2017 5:33:55 下午 org.apache.coyote.AbstractProtocol initn信息: Initializing ProtocolHandler ["ajp-nio-8009"]n七月 25, 2017 5:33:55 下午 org.apache.tomcat.util.net.NioSelectorPool getSharedSelectorn信息: Using a shared selector for servlet write/readn七月 25, 2017 5:33:55 下午 org.apache.catalina.startup.Catalina loadn信息: Initialization processed in 1874 msn七月 25, 2017 5:33:55 下午 org.apache.catalina.core.StandardService startInternaln信息: Starting service [Catalina]n七月 25, 2017 5:33:55 下午 org.apache.catalina.core.StandardEngine startInternaln信息: Starting Servlet Engine: Apache Tomcat/9.0.0.M21n七月 25, 2017 5:33:55 下午 org.apache.coyote.AbstractProtocol startn信息: Starting ProtocolHandler ["http-nio-8181"]n七月 25, 2017 5:33:55 下午 org.apache.coyote.AbstractProtocol startn信息: Starting ProtocolHandler ["ajp-nio-8009"]n七月 25, 2017 5:33:55 下午 org.apache.catalina.startup.Catalina startn信息: Server startup in 920 msnjava.lang.ClassNotFoundException: com.mysql.jdbc.Drivern at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1275)n at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1109)n at org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:123)n at org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:60)n at java.lang.Class.forName0(Native Method)n at java.lang.Class.forName(Unknown Source)n at org.apache.jsp.AddBook_jsp._jspService(AddBook_jsp.java:137)n at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)n at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)n at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:443)n at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385)n at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329)n at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)n at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)n at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)n at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)n at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:475)n at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)n at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)n at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)n at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)n at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)n at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:498)n at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)n at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:796)n at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1366)n at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)n at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)n at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)n at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)n at java.lang.Thread.run(Unknown Source)n
python2 连接不上MySQL
import MySQLdbrnimport osrnimport sysrnreload(sys)rnsys.setdefaultencoding('utf-8')rnrnconn=MySQLdb.connect(host="127.0.0.1",port=3306,user="root",passwd="697090",db="traffic",charset="utf8")rnrnrnOperationalError Traceback (most recent call last)rn in ()rn 1 rn----> 2 conn=MySQLdb.connect(host="127.0.0.1",port=3306,user="root",passwd="697090",db="traffic",charset="utf8")rnrnD:\softsetup\Anaconda2\lib\site-packages\MySQLdb\__init__.pyc in Connect(*args, **kwargs)rn 79 """Factory function for connections.Connection."""rn 80 from MySQLdb.connections import Connectionrn---> 81 return Connection(*args, **kwargs)rn 82 rn 83 connect = Connection = ConnectrnrnD:\softsetup\Anaconda2\lib\site-packages\MySQLdb\connections.pyc in __init__(self, *args, **kwargs)rn 191 autocommit = kwargs2.pop('autocommit', False)rn 192 rn--> 193 super(Connection, self).__init__(*args, **kwargs2)rn 194 self.cursorclass = cursorclassrn 195 self.encoders = dict([ (k, v) for k, v in conv.items()rnrnOperationalError: (1251, 'Client does not support authentication protocol requested by server; consider upgrading MySQL client')rn
本机的mysql连接不上?
本机的mysql数据库已建好,服务也开了,可是用下面的代码连接却失败,请问是什么原因?rn rn Class.forName("com.mysql.jdbc.Driver");rn Connection con1=DriverManager.getConnection("jdbc:mysql://localhost:3306/cel","root","");rnrn运行时抛出这个异常:java.sql.SQLException: Communication link failure: Bad handshakernrnrn
MySQL总是连接不上
MySQL 4.1.13+win2003+apache2+php rn 数据库总是出现连接不上的,运行SHOW STATUS语句 Connections 的值一直在增加,max_Connections已经改到最大了,mysql错误提示:mysql服务器挂起,wait timeout值为3600!rn请问有没有遇到同样情况的朋友,请达人赐教!
连接Mysql数据库连接不上?
On Error GoTo err1rn Dim GConn As ADODB.Connectionrn Set GConn = New ADODB.Connectionrn Dim lRs As ADODB.Recordset '数据库记录集对象rn Set lRs = New ADODB.Recordsetrn rn GConn.CursorLocation = adUseClientrn GConn.ConnectionString = "DRIVER=MySQL ODBC 3.51 Driver;SERVER=localhost; DATABASE=test;UID=root;PWD=123456; OPTION=3"rnrn GConn.Openrnrn MsgBox "连接成功"rn exit subrnErr1rn MsgBox "连接失败"rnrnrn会出现 [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序rnrn请问是否是我安装的mysql中,没有安装它的直接连接数据库的驱动程序rn我在ODBC中,想添加一个ODBC,但确实没有发现它有任何带有mysql之类的字符串rn请问如何解决这个问题?谢谢!
为什么连接不上mysql
异常信息 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'add, cq, czzhzh, Dac, dqrq, hm, jgm, jxbz, jyrq, khrq, kzz, qxr, qxrrcye, sjyrq,' at line 1rnrnrn 表结构:rn [code=Java]rn DROP TABLE IF EXISTS `dlxmxdjb`;rn CREATE TABLE `dlxmxdjb` (rn `zh` varchar(30) NOT NULL DEFAULT '' COMMENT '子分户账户',rn `czzhzh` varchar(30) CHARACTER SET gbk NOT NULL DEFAULT '' COMMENT '财政专户帐号',rn `sjzh` varchar(30) CHARACTER SET gbk NOT NULL DEFAULT '' COMMENT '上级账户',rn `jgm` varchar(20) CHARACTER SET gbk NOT NULL DEFAULT '' COMMENT '所属机构码',rn `hm` varchar(100) CHARACTER SET gbk NOT NULL DEFAULT '' COMMENT '户名',rn `add` varchar(100) CHARACTER SET gbk NOT NULL DEFAULT '' COMMENT '地址',rn `ye` decimal(16,2) NOT NULL DEFAULT '0.00' COMMENT '余额',rn `zrye` decimal(16,2) NOT NULL DEFAULT '0.00' COMMENT '昨日余额',rn `qxrrcye` decimal(16,2) NOT NULL DEFAULT '0.00' COMMENT '起息日日初余额',rn `zjlb` char(2) CHARACTER SET gbk NOT NULL DEFAULT '' COMMENT '开户证件类别',rn `zjh` varchar(20) CHARACTER SET gbk NOT NULL DEFAULT '' COMMENT '开户证件号',rn `khrq` date DEFAULT NULL COMMENT '开户日期',rn `xhrq` date DEFAULT NULL COMMENT '销户日期',rn `jyrq` date DEFAULT NULL COMMENT '交易日期',rn `qxr` date DEFAULT NULL COMMENT '起息日',rn `jxbz` char(2) CHARACTER SET gbk NOT NULL DEFAULT '' COMMENT '计息标志',rn `zhnll` decimal(16,2) NOT NULL DEFAULT '0.00' COMMENT '账户年利率',rn `cq` char(2) CHARACTER SET gbk NOT NULL DEFAULT '' COMMENT '账户存期',rn `dqrq` date DEFAULT NULL COMMENT '到期日期',rn `sjyye` decimal(16,2) NOT NULL DEFAULT '0.00' COMMENT '上次交易余额',rn `sjyrq` date DEFAULT NULL COMMENT '上次交易日期',rn `kzz` char(100) CHARACTER SET gbk NOT NULL DEFAULT '' COMMENT '帐号控制字',rn `Dac` varchar(100) CHARACTER SET gbk NOT NULL DEFAULT ' ' COMMENT 'DAC',rn PRIMARY KEY (`zh`),rn UNIQUE KEY `Pindex_dlxmxdjb` (`zh`)rn ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='利息明细登记表';rn [/code]rnrn 网上查了一下 有一个和我出现了一样的错误 是因为字段中有MySQL的关键字 我找不到是哪一个
MyEclipse连接不上MySQL?
[img=https://img-bbs.csdn.net/upload/201408/28/1409225509_517978.jpg][/img]rnrn做bbs项目的时候 MyEclipse连接不上数据库,各位大神,麻烦帮我看看这是什么原因?
Mysql连接不上数据库问题
今天连接Mysql数据库的时候出现一个问题,现在把解决方法拿出来,避免以后出现同样的问题,也为遇到同样问题的伙伴提供一个思路。 问题如下:   解决方法是进入mysql的mysql库中的user表,修改Host字段为%即可。当然,记得重启一下mysql服务。          ...
MYSQL连接不上(LINUX)
[root@test bin]# mysql -u root -h 192.168.0.100 -prnEnter password: ******rnERROR 1130: Host 'test.*****.net' is not allowed to connect to this MySQL serverrnrn其中MYSQL在192.168.0.100 上已经安装好了,并且已经启动了
连接不上mysql的原因
我用的是windows2000 professional,mysql可以正常运行,但php就是连接不上。显示rnWarning: mysql_pconnect(): Can't create TCP/IP socket (10106) rn用telnet hostname 3306 显示connection to host lose(遗失到主机的连接),这说明mysql没有运行在3306端口上,请问这是什么原因,应如何解决?
MySQL 8.0 连接不上
问题 最近使用数据库操作比较多,使用了JetBrain 家的 DataGrip 去连接数据库,但发现无论如何连接不上,但之前在 IDEA 里是没有问题的。 经过排查后,原因在于没有指定时区,MySQL 8时区参数是必选的,没有时区会连接不了。 解决方法 解决方法是添加一个参数 serverTimeZone=UTC JDBC URL 为 jdbc:mysql://192.168.200.238:33...
asp连接mysql连接不上,
[code=VBScript]dim connrnrnif not isObject(conn) then openconnrnsub openconn ()rn rn const uname = "root"rn const pwd = "771025gao"rn const serverip = "localhost"rn const dbase = "xwgg" '用户名跟密码我用那个管理登录上了rn dim connstrrn On Error Resume Nextrn connstr="driver=mysql odbc 3.51 driver;database="&dbase&";server="&serverip&";uid="&uname&";password="&pwd&""rn '无需配置dsnrn rn set conn = server.createobject("adodb.connection")rn conn.open strconnectionrn If Err Thenrn Err.Clearrn Set Conn = Nothingrn Response.Write "数据库连接出错,请检查Conn.asp文件中的数据库参数设置。" & connstrrn Response.Endrn End If rnend sub[/code]rnmysql数据库是5.0.4rnodbc 是从这下的http://dev.mysql.com/downloads/connector/odbc/3.51.html#win32,就是这个Windows ZIP/Setup.EXE (x86)下下来安装的,rn可就是连不上,应该怎样弄呢
Mysql连接问题127.0.0.1连接不上
MySQL said: Can't connect to MySQL server on '127.0.0.1' (61)rnrnMysql安装版,命令行可以连接。用客户端localhost可以连接,但是127.0.0.1连接不上,请问是我哪里配置有问题吗?rn
JSP 连接Mysql 一直连接不上
我用的是eclipse-jee-galileo-SR1-win32 tomca6.0 Mysql5.1 下载下来的驱动是mysql-connector-java-5.1.10-bin.jar 我将它放在了D:\目录下并写进了系统变量calsspath 还把它放进了eclipse工作区的 项目\WebContent\WEB-INF\lib中 tomcat安装目录下的lib中也放进去了 但是程序运行结果一直是:rnrnHTTP Status 404 - rnrn--------------------------------------------------------------------------------rnrntype Status reportrnrnmessage rnrndescription The requested resource () is not available.rnrnrn--------------------------------------------------------------------------------rnrnApache Tomcat/6.0.20rnrn程序如下:rnrn<%@ page language="java" contentType="text/html; charset=gb2312"rn pageEncoding="gb2312"%>rn<%@ page import="java.util.*" %>rn<%@ page import="java.sql.*" %>rnrnrnrnrn rn 创建数据库rnrnrn<%rn Connection conn= null;rn Statement stmt = null;rn String sql = null;rn ResultSet rs = null;rn int ret;rn tryrn rn Class.forName("com.mysql.jdbc.Driver");rn String strCon = "jdbc:mysql://localhost:3306/";rn conn = DriverManager.getConnection(strCon,"root","1234");rn rn stmt = conn.createStatement();rn sql = "create database JspSamples";rn ret = stmt.executeUpdate(sql);rn sql = "use JspSamples";rn ret = stmt.executeUpdate(sql);rn sql = " CREATE TABLE customers(" +rn " Id int(6) unsigned NOT NULL auto_increment," +rn " Name varchar(20) default NULL," +rn " addTime timestamp NULL default NULL," +rn " Tel varchar(15) default NULL," +rn " Email varchar(20) default NULL," +rn " PRIMARY KEY (Id)" +rn " )";rn ret = stmt.executeUpdate(sql);rn rn rn catch(ClassNotFoundException e)rn e.printStackTrace();rn out.println(" 无法找到数据库驱动");rn rn catch(SQLException e1)rn e1.printStackTrace();rn out.println(" 数据库操作失败");rn rn rn out.println(" 新建数据库JspSample成功");rn DatabaseMetaData meta = conn.getMetaData();rn out.println(" ");rn out.println("连接字:" + meta.getURL());rn out.println(" ");rn out.println("数据库产品:" + meta.getDatabaseProductName());rn out.println(" ");rn out.println("数据库版本:" + meta.getDatabaseProductVersion());rn out.println(" ");rn out.println("驱动程序:" + meta.getDriverName());rn out.println(" ");rn out.println("驱动程序版本:" + meta.getDriverVersion());rn rn stmt.close();rn conn.close();rn%>rnrnrn
连接不上mysql,找不到mysql解决办法
长时间不用mysql 发现不能正常启动msyq,服务项也找到不到了。 问题原因: cclear Dism++ 等清理软件清理了。 报错: ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061) 解决办法 1.管理员运行cmd,cd到mysql根目录 2、cmd管理员执行
Apache mysql php配置连接不上mysql
Apache mysql php配置连接不上mysql怎么回事,不管我怎么改都连不上,我是菜鸟,请求帮助rnrn我装的是mysql5.3.17rnapache2.2.11rnphp5.3.0rnapache可以运行PHP测试也正常,就是连接数据库出了问题rnrn附部分配置信息rnPHP配置5.3的和以前的不一样了吗???rnrn[dba]rn;dba.default_handler=rnrn; Local Variables:rn; tab-width: 4rn; End:rn[PHP_BZ2]rnextension=php_bz2.dllrn[PHP_CURL]rnextension=php_curl.dllrn[PHP_GD2]rnextension=php_gd2.dllrn[PHP_GETTEXT]rnextension=php_gettext.dllrn[PHP_IMAP]rnextension=php_imap.dllrn[PHP_MBSTRING]rnextension=php_mbstring.dllrn[PHP_MYSQL]rnextension=php_mysql.dllrn[PHP_MYSQLI]rnextension=php_mysqli.dllrn[PHP_OPENSSL]rnextension=php_openssl.dllrn[PHP_PDO_MYSQL]rnextension=php_pdo_mysql.dllrn[PHP_PDO_ODBC]rnextension=php_pdo_odbc.dllrn[PHP_PDO_SQLITE]rnextension=php_pdo_sqlite.dllrn[PHP_PGSQL]rnextension=php_pgsql.dllrn[PHP_SOAP]rnextension=php_soap.dllrn[PHP_SOCKETS]rnextension=php_sockets.dllrn[PHP_SQLITE3]rnextension=php_sqlite3.dllrn[PHP_TIDY]rnextension=php_tidy.dllrn[PHP_XMLRPC]rnextension=php_xmlrpc.dllrn[PHP_EXIF]rnextension=php_exif.dllrnrnAPACHE的配置信息rn#BEGIN PHP INSTALLER EDITS - REMOVE ONLY ON UNINSTALLrnPHPIniDir "C:/PHP/"rnLoadModule php5_module "C:/PHP/php5apache2_2.dll"rn#END PHP INSTALLER EDITS - REMOVE ONLY ON UNINSTALLrnPHP5.3安装程序自己干添加上去的
ADO连接不上,急……
我使用visual C++ 6.0于SQL Server2000新建一个MFC工程(班级管理系统),在连接数据库时写下如下代码:rn[code=C/C++]//stdfax.hrn#import "C:\Program Files\Common Files\System\ado\msado15.dll"rnno_namespace rename("EOF","adoEOF")[/code]rn[code=C/C++]//banjiguanlixitong.hrnpublic:rn _connectionPtr m_pAppConn;rn CString m_AppConnString;rn BOOL m_bConnected;[/code]rn[code=C/C++]//banjiguanlixitong.cpprnCBanjikaoqinApp::CBanjikaoqinApp()rnrn // TODO: add construction code here,rn // Place all significant initialization in InitInstancern /////////////////////////////////rn //////////////fkha;lhfljkakjgrn m_AppConnString=_T("Driver=SQL Server;Server=127.0.0.1;") rn _T("Database=master;Uid=sa;pwd=;");rn m_bConnected=FALSE;rnrnrnrn/////////////////////////////////////////////////////////////////////////////rn// The one and only CBanjikaoqinApp objectrnrnCBanjikaoqinApp theApp;rnrn/////////////////////////////////////////////////////////////////////////////rn// CBanjikaoqinApp initializationrnrnBOOL CBanjikaoqinApp::InitInstance()rnrn AfxEnableControlContainer();rnrn // Standard initializationrn // If you are not using these features and wish to reduce the sizern // of your final executable, you should remove from the followingrn // the specific initialization routines you do not need.rn HRESULT hRes;rn tryrn rn hRes=theApp.m_pAppConn.CreateInstance(_T("ADODB.Connection")); rn m_pAppConn->ConnectionTimeout=8;rn hRes=m_pAppConn->Open(_bstr_t((LPCTSTR) m_AppConnString),rn _T(""),_T(""),adModeUnknown);rn if(SUCCEEDED(hRes))rn m_bConnected=TRUE;rnrn rn catch(_com_error e)rn rn CString errermessage;rn errormessage.Format(_T("连接数据库失败:%s"),e.ErrorMessage());rn AfxMessageBox(errormessage);rn return FALSE;rn [/code]
急!IIS连接不上
win2000下,本来是无法启动IIS,重装IIS后IIS连接不上了
TSocketConnection连接不上(急)
三层结构,在本机上调试连接没有问题,服务器上就不行,rn而且一执行到 Socket1.Connected := True就没有反应: rnsocket1.Host := sHost;rntryrnSocket1.Connected := True;rnexceptrn到底什么原因?是否要设置什么?有开Socket Server~~
Navicat连接不上Linux服务器上的MySQL。
1.首选你Linux服务器上要装配好了MySQL数据库。   2.在Linux服务区上登入到MySQL数据库的命令行。   3.输入use mysql 切换到MySQL数据库.  4.输入:  grant all privileges on *.* to root@"%" identified by "密码"; 这相当于是给IP-xxx.xxx.xxx.xxx赋予了所
为什么VC连接不上MYSQL,请看看,急...
为什么VC连接不上MYSQL,请看看,急...rnrn我下载了一个MYSQL.ZIP版rn解压缩后,命令安装rnD:\MySQL\MySQL Server 5.0\bin>mysqld-nt -installrnD:\MySQL\MySQL Server 5.0\bin>net start mysqlrnrnVC代码如下:rnCString MyConString =_T("Provider=MySQLProv;Data Source=mysql;User Id=root;Password=;" );rn::CoInitialize(NULL);rn_ConnectionPtr m_CMConnect;rnm_CMConnect.CreateInstance(__uuidof(Connection));rnm_CMConnect->Open((_bstr_t)MyConString,"","",-1);rnrnrn编译没有问题,运行报错说如下:rninline HRESULT Connection15::Open ( _bstr_t ConnectionString, _bstr_t UserID, _bstr_t Password, long Options ) rn HRESULT _hr = raw_Open(ConnectionString, UserID, Password, Options);rn if (FAILED(_hr)) _com_issue_errorex(_hr, this, __uuidof(this));rn return _hr;rnrn这里有错误.....rnrn谢谢:)
相关热词 c++和c#哪个就业率高 c# 批量动态创建控件 c# 模块和程序集的区别 c# gmap 截图 c# 验证码图片生成类 c# 再次尝试 连接失败 c#开发编写规范 c# 压缩图片好麻烦 c#计算数组中的平均值 c#获取路由参数