blocks|key|1233212|text|假设你的驱动在path中，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1233213|String+url+=+"jdbc:mysql://localhost/test";
Class.forName+("com.mysql.jdbc.Driver").newInstance+();
Connection+conn+=+DriverManager.getConnection+(url,+"username",+"password");|code-block|syntax|javascript|1233214|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Assuming your driver is in path,

<pre><code>String url = "jdbc:mysql://localhost/test";
Class.forName ("com.mysql.jdbc.Driver").newInstance ();
Connection conn = DriverManager.getConnection (url, "username", "password");
</code></pre>

blocks|key|1448084|text|以下是文档：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1448085|https://dev.mysql.com/doc/connector-j/en/connector-j-reference-configuration-properties.html|offset|length|1448086|基本连接字符串如下所示：|1448087|jdbc:mysql://localhost:3306/dbname|code-block|syntax|javascript|1448088|class.forName字符串是"com.mysql.jdbc.Driver"，您可以找到它(编辑:现在在同一页上)。|1448089|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|2K|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|W|8|@]|9|@$D|X|E|Y|1|Z]]|A|$]]|$1|F|3|G|5|6|7|10|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|11|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|12|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|C]]]]

Here's the documentation:

<a href="https://dev.mysql.com/doc/connector-j/en/connector-j-reference-configuration-properties.html" rel="nofollow noreferrer">https://dev.mysql.com/doc/connector-j/en/connector-j-reference-configuration-properties.html</a>

A basic connection string looks like:

<pre><code>jdbc:mysql://localhost:3306/dbname
</code></pre>

The class.forName string is "com.mysql.jdbc.Driver", which you can find (edit: now on the same page).

blocks|key|1233463|text|因为答案似乎已经回答了，所以没有太多要补充的，但我想在现有的答案上补充一件事。这是为mysql的JDBC驱动程序装入类的方式|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1233464|com.mysql.jdbc.Driver|code-block|syntax|javascript|1233465|但这现在已经被弃用了。新的驱动程序类现在是|1233466|com.mysql.cj.jdbc.Driver|1233467|此外，驱动程序是通过SPI自动注册的，通常不需要手动加载驱动程序类。|1233468|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

As the answer seems already been answered, there is not much to add but I would like to add one thing to the existing answers.
This was the way of loading class for JDBC driver for mysql 

<pre><code>com.mysql.jdbc.Driver
</code></pre>

But this is deprecated now. The new driver class is now

<pre><code>com.mysql.cj.jdbc.Driver
</code></pre>

Also the driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.

blocks|key|1233511|text|方法Class.forName()用于注册JDBC驱动程序。连接字符串用于检索到数据库的连接。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1233512|检索数据库连接的方法如下所示。理想情况下，由于您不希望创建多个到数据库的连接，因此将连接限制为一个，并重用相同的连接。因此，在处理到数据库的连接时，这里使用单例模式。|1233513|下图显示了检索连接的连接字符串：|1233514|public+class+Database+{
+++
++++private+String+URL+=+"jdbc:mysql://localhost:3306/your_db_name";+//database+url
++++private+String+username+=+"";+//database+username
++++private+String+password+=+"";+//database+password
++++private+static+Database+theDatabase+=+new+Database();+
++++private+Connection+theConnection;
++++
++++private+Database(){
++++++++try{
++++++++++++++Class.forName("com.mysql.jdbc.Driver");+//setting+classname+of+JDBC+Driver
++++++++++++++this.theConnection+=+DriverManager.getConnection(URL,+username,+password);
++++++++}+catch(Exception+ex){
++++++++++++System.out.println("Error+Connecting+to+Database:+"%2Bex);
++++++++}
++++}

++++public+static+Database+getDatabaseInstance(){
++++++++return+theDatabase;
++++}
++++
++++public+Connection+getTheConnectionObject(){
++++++++return+theConnection;
++++}
}|code-block|syntax|javascript|1233515|entityMap^0|2|F|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|T|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|U|8|@]|D|@]|E|$]]|$1|J|3|K|5|L|7|V|8|@]|D|@]|E|$M|N]]|$1|O|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|P|$]]

The method <code>Class.forName()</code> is used to register the JDBC driver. A connection string is used to retrieve the connection to the database.
The way to retrieve the connection to the database is shown below. Ideally since you do not want to create multiple connections to the database, limit the connections to one and re-use the same connection. Therefore use the singleton pattern here when handling connections to the database.
Shown Below shows a connection string with the retrieval of the connection:
<pre><code>public class Database {
 
 private String URL = &quot;jdbc:mysql://localhost:3306/your_db_name&quot;; //database url
 private String username = &quot;&quot;; //database username
 private String password = &quot;&quot;; //database password
 private static Database theDatabase = new Database(); 
 private Connection theConnection;
 
 private Database(){
 try{
 Class.forName(&quot;com.mysql.jdbc.Driver&quot;); //setting classname of JDBC Driver
 this.theConnection = DriverManager.getConnection(URL, username, password);
 } catch(Exception ex){
 System.out.println(&quot;Error Connecting to Database: &quot;+ex);
 }
 }

 public static Database getDatabaseInstance(){
 return theDatabase;
 }
 
 public Connection getTheConnectionObject(){
 return theConnection;
 }
}
</code></pre>

blocks|key|1448302|text|下面是我这边的一小段代码:)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1448303|所需驱动程序：|1448304|com.mysql.jdbc.Driver|code-block|syntax|javascript|1448305|下载：here+(独立于平台)|offset|length|1448306|一行中的连接字符串：|1448307|jdbc:mysql://localhost:3306/db-name?user=user_name&password=db_password&useSSL=false|1448308|示例代码：|1448309|public+static+void+testDB(){
++++try+{
++++++++Class.forName("com.mysql.jdbc.Driver");
++++}+catch+(ClassNotFoundException+e)+{
++++++++e.printStackTrace();
++++}

++++try+{
++++++++Connection+connection+=+DriverManager.getConnection(
++++++++++++++++"jdbc:mysql://localhost:3306/db-name?user=user_name&password=db_password&useSSL=false");
++++++++if+(connection+!=+null)+{
++++++++++++Statement+statement+=+connection.createStatement();
++++++++++++if+(statement+!=+null)+{
++++++++++++++++ResultSet+resultSet+=+statement.executeQuery("select+*+from+test");
++++++++++++++++if+(resultSet+!=+null)+{
++++++++++++++++++++ResultSetMetaData+meta+=+resultSet.getMetaData();
++++++++++++++++++++int+length+=+meta.getColumnCount();
++++++++++++++++++++while(resultSet.next())
++++++++++++++++++++{
++++++++++++++++++++++++for(int+i+=+1;+i+<=+length;+i%2B%2B){
++++++++++++++++++++++++++++System.out.println(meta.getColumnName(i)+%2B+":+"+%2B+resultSet.getString(meta.getColumnName(i)));
++++++++++++++++++++++++}
++++++++++++++++++++}
++++++++++++++++++++resultSet.close();
++++++++++++++++}
++++++++++++++++statement.close();
++++++++++++}
++++++++++++connection.close();
++++++++}
++++}+catch+(Throwable+throwable)+{
++++++++throwable.printStackTrace();
++++}
}|1448310|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/downloads/connector/j/^0|0|0|0|3|4|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|13|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|14|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|15|8|@]|9|@$K|16|L|17|1|18]]|A|$]]|$1|M|3|N|5|6|7|19|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|1A|8|@]|9|@]|A|$G|H]]|$1|Q|3|R|5|6|7|1B|8|@]|9|@]|A|$]]|$1|S|3|T|5|F|7|1C|8|@]|9|@]|A|$G|H]]|$1|U|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]]|V|$W|$5|X|Y|Z|A|$10|11]]]]

Here is a little code from my side :)
needed driver:
<pre><code>com.mysql.jdbc.Driver
</code></pre>
download: <a href="https://dev.mysql.com/downloads/connector/j/" rel="nofollow noreferrer">here</a> (Platform Independent)
connection string in one line:
<pre><code>jdbc:mysql://localhost:3306/db-name?user=user_name&amp;password=db_password&amp;useSSL=false
</code></pre>
example code:
<pre><code>public static void testDB(){
 try {
 Class.forName(&quot;com.mysql.jdbc.Driver&quot;);
 } catch (ClassNotFoundException e) {
 e.printStackTrace();
 }

 try {
 Connection connection = DriverManager.getConnection(
 &quot;jdbc:mysql://localhost:3306/db-name?user=user_name&amp;password=db_password&amp;useSSL=false&quot;);
 if (connection != null) {
 Statement statement = connection.createStatement();
 if (statement != null) {
 ResultSet resultSet = statement.executeQuery(&quot;select * from test&quot;);
 if (resultSet != null) {
 ResultSetMetaData meta = resultSet.getMetaData();
 int length = meta.getColumnCount();
 while(resultSet.next())
 {
 for(int i = 1; i &lt;= length; i++){
 System.out.println(meta.getColumnName(i) + &quot;: &quot; + resultSet.getString(meta.getColumnName(i)));
 }
 }
 resultSet.close();
 }
 statement.close();
 }
 connection.close();
 }
 } catch (Throwable throwable) {
 throwable.printStackTrace();
 }
}
</code></pre>

blocks|key|1233342|text|String+url+=+"jdbc:mysql://localhost:3306/dbname";
String+user+=+"user";
String+pass+=+"pass";
Class.forName+("com.mysql.jdbc.Driver").newInstance+();
Connection+conn+=+DriverManager.getConnection+(url,+user,+pass);|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1233343|3306是mysql的默认端口。|unstyled|offset|length|style|CODE|1233344|如果您使用的是Java7，那么甚至不需要添加JDBC4.1中添加的Class.forName("com.mysql.jdbc.Driver").newInstance+();+statement.Automatic资源管理(ARM)。|1233345|用于连接到MySQL服务器的JDBC+URL的一般格式如下所示，方括号()中的项是可选的：|1233346|jdbc:mysql://[host1][:port1][,[host2][:port2]]...[/[database]]+»
[?propertyName1=propertyValue1[&propertyName2=propertyValue2]...]|1233347|entityMap^0|0|0|4|0|X|1I|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|T|8|@$G|U|H|V|I|J]]|9|@]|A|$]]|$1|K|3|L|5|F|7|W|8|@$G|X|H|Y|I|J]]|9|@]|A|$]]|$1|M|3|N|5|F|7|Z|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|10|8|@]|9|@]|A|$B|C]]|$1|Q|3|-4|5|F|7|11|8|@]|9|@]|A|$]]]|R|$]]

<pre><code>String url = "jdbc:mysql://localhost:3306/dbname";
String user = "user";
String pass = "pass";
Class.forName ("com.mysql.jdbc.Driver").newInstance ();
Connection conn = DriverManager.getConnection (url, user, pass);
</code></pre>

<code>3306</code> is the default port for mysql.

If you are using Java 7 then there is no need to even add the <code>Class.forName("com.mysql.jdbc.Driver").newInstance ();</code> statement.Automatic Resource Management (ARM) is added in JDBC 4.1 which comes by default in Java 7.

The general format for a JDBC URL for connecting to a MySQL server is as follows, with items in square brackets ([ ]) being optional:

<pre><code>jdbc:mysql://[host1][:port1][,[host2][:port2]]...[/[database]] »
[?propertyName1=propertyValue1[&amp;propertyName2=propertyValue2]...]
</code></pre>

blocks|key|1448177|text|协议//主机?属性|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1448178|如果您没有任何属性忽略它，那么它将如下所示|1448179|jdbc:mysql://127.0.0.1:3306/test|1448180|jdbc:mysql是协议127.0.0.1:是主机，3306是端口号test是数据库|1448181|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

protocol//[hosts][/database][?properties]

If you don't have any properties ignore it then it will be like 

jdbc:mysql://127.0.0.1:3306/test 

jdbc:mysql is the protocol
127.0.0.1: is the host and 3306 is the port number
test is the database

I am new to JDBC and I am trying to make a connection to a MySQL database.
I am using Connector/J driver, but I cant find the JDBC connection string for my <code>Class.forName()</code> method.

What is the MySQL JDBC driver connection string?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我是JDBC的新手，我正在尝试建立到MySQL数据库的连接。我正在使用连接器/J驱动程序，但是我找不到我的Class.forName()方法的JDBC连接字符串。

问MySQL驱动程序连接字符串是什么？
EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL驱动程序连接字符串是什么？EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL驱动程序连接字符串是什么？
EN