Day11-1 intelliJ 랑 MySQL 연결하기

File - Project Structure - +

 

 

외부 라이브러리 가져오기 

 

1. JAR파일 사용

JAVA - C - Program Files(x86) - MySQL - Connector J 8.0 - .jar파일

 

2. Maven사용

From Maven - mysql connector검색

3. pom.xml

 

https://mvnrepository.com/search?q=connector+j 

Maven Repository: connector j

pom.xml에 복사해서 넣기

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>org.example</groupId>
    <artifactId>javaBasic</artifactId>
    <version>1.0-SNAPSHOT</version>

    <properties>
        <maven.compiler.source>19</maven.compiler.source>
        <maven.compiler.target>19</maven.compiler.target>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    </properties>
    <dependencies>
        <dependency>
            <groupId>com.mysql</groupId>
            <artifactId>mysql-connector-j</artifactId>
            <version>8.0.32</version>
        </dependency>
    </dependencies>

</project>

 

 

MySQL 연결하기

 

package day0126;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class Ex01Connection {
    public static void main(String[] args) {
        // 연결한 주소
        String address = "jdbc:mysql://localhost/basic";
        String username = "root";
        String password = "1111";
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            Connection connection = DriverManager.getConnection(address, username, password);

            System.out.println("MySql 연결 성공!!!");

            connection.close();
        } catch (ClassNotFoundException | SQLException e){
            e.printStackTrace();
        }
    }
}