mysql 샘플 테이블 + 쿼리 연습 문제

-
http://java-school.net/jdbc/SQL-SELECT-Statement CREATE TABLE DEPT (     DEPTNO DECIMAL ( 2 ),     DNAME VARCHAR ( 14 ),     LOC VARCHAR ( 13 ),     CONSTRAINT PK_DEPT PRIMARY KEY ( DEPTNO ) ); CREATE TABLE EMP (     EMPNO DECIMAL ( 4 ),     ENAME VARCHAR ( 10 ),     JOB VARCHAR ( 9 ),     MGR DECIMAL ( 4 ),     HIREDATE DATE ,     SAL DECIMAL ( 7 , 2 ),     COMM DECIMAL ( 7 , 2 ),     DEPTNO DECIMAL ( 2 ),     CONSTRAINT PK_EMP PRIMARY KEY ( EMPNO ),     CONSTRAINT FK_DEPTNO FOREIGN KEY ( DEPTNO ) REFERENCES DEPT ( DEPTNO ) ); CREATE TABLE SALGRADE (     GRADE TINYINT ,     LOSAL SMALLINT ,     HISAL SMALLINT ); INSE...

MySQL 이클립스 DB연동

-

MySQL다운로드(위에꺼)
http://dev.mysql.com/downloads/installer/
->
Choosing a Setup Type = Server Only
Type and Networking = (Config type) server machine
->
mysql-connector-java-5.1.40-bin.jar 다운
https://dev.mysql.com/downloads/connector/j/
zip파일 다운후 압축해제
->
mysql-connector-java-5.1.40-bin.jar 파일을
C:\Program Files\Java\jdk1.8.0_111\lib 경로에 추가
->
이클립스에서 java소스 작성

package testTomcat;

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

 public class DbTest {
 public static void main(String[] args) {
String drive="com.mysql.jdbc.Driver";
String url="jdbc:mysql://localhost:3306/testdb";
String id="root";
String pw="1234";
Connection conn;

try{
Class.forName(drive); // DB와 연동하기 위해 DriverManager에 등록한다.
conn=DriverManager.getConnection(url,id,pw); // DriverManager 객체로부터 Connection 객체를 얻어온다.
System.out.println("DB연동 성공");
}catch(Exception e){
e.printStackTrace();
}
}
}

->
해당 프로젝트 우클릭 - build path - library 탭 - add external jar - mysql-connector-java-5.1.40-bin.jar 추가하고 - 확인
->
클래스 실행