[JAVA] JDBC 연결 (MySQL)

---

JDBC 연결 (MySQL)

 

● MySQL Connector 다운로드

https://dev.mysql.com/downloads/connector/j/ 접속 > Archives > OS : Platform Independent

 

● 프로젝트에 lib 추가

 Project 

     ㄴ  src 

          ㄴ  main 

               ㄴ  webapp 

                    ㄴ  WEB-INF 

                         ㄴ  lib 

                              ㄴ  mysql-connector-java-8.0.26.jar 

 

● JDBC 연결

public class DBConn {
	
	String driver = "com.mysql.cj.jdbc.Driver";
	String url = "jdbc:mysql://localhost:3306/git";
	String user = "hong";
	String pw = "1111";
	
	Connection conn;

	public DBConn() {
		try {
			Class.forName(driver);
			conn = DriverManager.getConnection(url, user, pw);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	public Connection getConnection() {
		return conn;
	}
}