mysql에서 연결을 만드는 방법

<code class="python">import mysql.connector</code>

<code class="java">import java.sql.*;</code>

<code class="python">connection = mysql.connector.connect(
    host="localhost",
    user="root",
    password="my_password",
    database="my_database"
)</code>

<code class="java">// 使用 JDBC 创建连接对象
Connection connection = DriverManager.getConnection(
    "jdbc:mysql://localhost:3306/my_database",
    "root",
    "my_password"
);</code>

<code class="python">cursor = connection.cursor()</code>

<code class="java">Statement statement = connection.createStatement();</code>

<code class="python">cursor.execute("SELECT * FROM my_table")</code>

<code class="java">ResultSet resultSet = statement.executeQuery("SELECT * FROM my_table");</code>

<code class="python">for row in cursor.fetchall():
    print(row)</code>

<code class="java">while (resultSet.next()) {
    System.out.println(resultSet.getInt("id"));
}</code>

<code class="python">cursor.close()
connection.close()</code>

<code class="java">statement.close();
connection.close();</code>