MySQL - JAVA, DB 연결하기

자바파일 - lib - 붙여넣기

mysql을 실행시켜놓고 데이터베이스 연결하기. 컴파일, 실행!

JDBCExampleToMysql.java

0.00MB

ConnectionTest.java

0.00MB

import java.sql.*;

public class JDBCExampleToMysql {
	public static void main(String[] args) {
		if(args.length < 1) {
			System.err.println("Usage : ");
			System.err.println("java JDBCExample <db server hostname>");
			System.exit(1);
		}
		
		String serverName = args[0];
		
		try {
			Class.forName("com.mysql.jdbc.Driver");
			String url = "jdbc:mysql://" + serverName + ":3306/sample";
			Connection MySQLcon = DriverManager.getConnection(url, "root", "1234");
			Statement stmt = MySQLcon.createStatement();
			ResultSet rs = stmt.executeQuery("SELECT * FROM TB_ADDRESS");
			
			while(rs.next()) {
				System.out.println("");
				System.out.println("Name	: " + rs.getString(1));
				System.out.println("Address	: " + rs.getString(2));
				System.out.println("Phone	: " + rs.getString(3));
			}
		} catch(SQLException e) {
			e.printStackTrace();
		}
		catch(ClassNotFoundException e) {
			e.printStackTrace();
		}
	}
}

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

public class ConnectionTest {
	public static void main(String[] args) {
		Connection conn = null;
		
		try {
			Class.forName("com.mysql.jdbc.Driver");
			
			String url = "jdbc:mysql://localhost/dev";
			
			conn = DriverManager.getConnection(url, "user", "password");
			System.out.println("연결 성공");
		}
		
		catch(ClassNotFoundException e) {
			System.out.println("드라이버 로딩 실패");
		}
		catch(SQLException e) {
			System.out.println("에러: " + e);
		}
		finally {
			try {
				if (conn != null && !conn.isClosed()) {
					conn.close();
				}
			}
			catch(SQLException e) {
				e.printStackTrace();
			}
		}
	}
}

javac JDBCExampleToMysql.java

java JDBCExampleToMysql