如何为 Jetbrains PHPStorm 和 WebStorm 配置 DB Navigator
我需要在 Mac(雪豹)中的 PHPStorm 的 DB Navigator 插件中建立连接。它询问我实现 java.sql.Driver 类的库的路径。我只是不知道它在哪里。有什么建议吗?
I need to set up a connection in the DB Navigator plugin for PHPStorm in a mac (snow leopard). It asks me for the route of a library that implements the java.sql.Driver class. I just don't have any idea of where is it. Any advice?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(6)
可用选项卡
http://www.mysql.com/downloads/connector/j/
Available-Tab
http://www.mysql.com/downloads/connector/j/
只需确保在主机名之前添加 jdbc:mysql:// 即可。这解决了我的问题。
Just make sure you added jdbc:mysql:// before hostname. That solved my problem.
首先,您不需要安装第三方 DB Navigator 插件,因为 PhpStorm 中的数据库功能是开箱即用的,请参阅
工具
|数据源
。添加新的数据源,将允许选择数据库和驱动程序,并自动下载所需的数据库驱动程序。
First of all, you don't need to install third-party DB Navigator plug-in, as database functionality is available in PhpStorm out of the box, see
Tools
|Data Sources
.Add new data source, it will allow to choose the database and the driver, and will download the required database drivers automatically.
在此处安装解压的 MySQL Connector J 文件 >
c:\Program Files\MySQL\MySQL Connector J
并且需要我们>
mysql-connector-java-5.1.28-bin.jar
复制到>
c:\Documents and Settings[YOUR_COMP].WebIde70\config\jdbc-drivers\
在 MySQL 数据库连接中选择
驱动>> MySQL>>单击加号并选择
还需要数据库支持插件打开! (设置 >> IDE 设置 >> 插件)
ps 实际上适用于 PHPStorm 7
Installed unpacked MySQL Connector J files here >
c:\Program Files\MySQL\MySQL Connector J
And there need to us >
mysql-connector-java-5.1.28-bin.jar
Copy to >
c:\Documents and Settings[YOUR_COMP].WebIde70\config\jdbc-drivers\
In MySQL Database connection choose
Drivers >> MySQL >> click on PLUS and select
Also need Database Support plug-in turn ON! (Settings >> IDE Settings >> Plugins)
p.s. Actually for PHPStorm 7
下载 mysql-connector-java-5.1.18-bin.jar 文件并设置该 jar 文件的驱动程序库路径。
然后Intellij idea会自动加载Driver,即com.mysql.jdbc.Driver。
然后将 URL 设置为 jdbc:mysql://localhost:3306/
最后输入有效的用户名和密码。
Download mysql-connector-java-5.1.18-bin.jar file and set Driver Library path for that jar file.
Then the Intellij idea will automatically load the Driver which is com.mysql.jdbc.Driver.
Then set URL as jdbc:mysql://localhost:3306/
Finally enter valid user name and a password.
看这张图就清楚了。我希望它可以对你有一点帮助。
此图片下方有一个驱动程序文件丢失错误,单击此将为您下载所需的驱动程序。
数据库:您的数据库名称。
Clearly view this picture. I hope it may help you a little bit.
There is a driver files missing error at below of this image, click this it will download required driver for you.
Database: your database name.