[JAVA] 오라클 DB연결 4

package db_test2;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;

public class JDBC_Ex4 {

	static Scanner scan = new Scanner(System.in);
	static Connection conn;
	static Statement stmt = null;


	public static void main(String[] args) {
		
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			String db_url = "jdbc:oracle:thin:@localhost:1521:xe";
			String db_id = "SYSTEM";
			String db_pw = "test1234";
			conn = DriverManager.getConnection(db_url, db_id, db_pw);
			System.out.println("DB 연결 완료");
			
			
			stmt = conn.createStatement();
			
			
			int choice = 0;
			
			while (choice != 4) {

				System.out.print("추가(1), 삭제(2), 수정(3), 종료(4) >> ");
				choice = scan.nextInt();

				switch (choice) {
				case 1:
					add();
					break;
				case 2:
					delete();
					break;
				case 3:
					update();
					break;
				case 4:
					System.out.println("프로그램을 종료합니다.");
					break;
				default:
					System.out.println("숫자를 잘못입력하였습니다.");
					break;
				} // switch
						
	
			}
		} catch (ClassNotFoundException e) {
			System.out.println("JDBC 드라이버 로드 오류");
		} catch (SQLException e) {
			System.out.println("DB 연결 오류");
		}
	}
	
	
	
	private static void add() {
		
		try {
			System.out.print("학생의 학번 입력 : ");
			String stuNum = scan.next();
			System.out.print("학생의 이름 입력 : ");
			String name = scan.next();
			System.out.print("학생의 학과 입력 : ");
			String stuDept = scan.next();
			
			stmt.executeUpdate("INSERT INTO STUDENT(STU_NO,STU_NAME,STU_DEPT) "
								+ "VALUES ('" + stuNum + "','" + name + "','" + stuDept + "')");
			
		} catch (SQLException e) {
			e.printStackTrace();
		}		
	}


	private static void delete() {
		try {
			System.out.print("삭제할 학번 입력 >> ");
			String delid = scan.next();
			stmt.executeUpdate("delete from student where stu_no = '" + delid + "'");
		} catch (SQLException e) {
			System.out.println("DB 연결 오류");
		}			
	}


	private static void update() {

		try {
			System.out.print("수정할 학번 입력 >> ");
			String number = scan.next();
			System.out.print("학생의 신장(height) 입력 >> ");
			String height = scan.next();
			
			stmt.executeUpdate("update student set stu_height = '" + height + "' " + "where stu_no = '" + number + "'");
		} catch (SQLException e) {
			System.out.println("DB 연결 오류");
		}
		
	}

	
	

}