[JAVA] 오라클 DB연결3

학번, 이름, 학과를 입력받아서

student 테이블에 삽입하기

#executeUpdate 

package db_test2;

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

public class JDBC_Ex3 {

	public static void main(String[] args) {
		
		Scanner scan = new Scanner(System.in);


		Connection conn;
		Statement stmt = null;
		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();
			
			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 + "')");
			
			ResultSet srs = stmt.executeQuery("select * from student");
			printData(srs, "name","id","dept");
			
			
		
			

		} catch (ClassNotFoundException e) {
			System.out.println("JDBC 드라이버 로드 오류");
		} catch (SQLException e) {
			System.out.println("DB 연결 오류");
		}
	}
	
	
	// 레코드의 각 열의 값 화면의 출력
	private static void printData(ResultSet srs, String col1, String col2, String col3)
			throws SQLException {
		while (srs.next()) {
			if (!col1.equals(""))
				System.out.print(srs.getString("stu_name"));
			if(!col2.equals(""))
				System.out.print("\t|\t" + srs.getString("stu_no"));
			if(!col3.equals(""))
				System.out.println("\t|\t" + srs.getString("stu_dept"));
			else
				System.out.println();
			
		}
	}
	
	

}