jdbc javaを使用してテーブルを追加する

1948 ワード

package kr.or.didt.basic;

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 JdbcTest04 {

	public static void main(String[] args) {

		Scanner scan = new Scanner(System.in);
		
		Connection conn = null;
		Statement stmt = null;
		try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
			
			conn = DriverManager.getConnection(
					"jdbc:oracle:thin:@localhost:1521:xe",
					"JSG99","java");
			
			System.out.println("계좌번호 정보 추가하기");
			System.out.println("계좌번호 : ");
			String bankNo = scan.next();
			
			System.out.println("은행명 : ");
			String bankName =  scan.next();
			
			System.out.println("예금주명 : ");
			String bankUser =  scan.next();
			
			String sql = "insert into bankinfo(bank_no, bank_name, bank_user_name, bank_date)"
                         + "values('" + bankNo + "', '"+bankName + "','" + bankUser +"', sysdate)";
			
            stmt = conn.createStatement();
			
			//select문을 실행할 때는   executeQuery()메서드를 사용하고
			
			//insert, update, delete문과 같이 select문이 아닌 쿼리문을
			//           실행할 때는 executeUpdate()메서드를 사용한다.
			
			//executeUpdate()메서드의 반환값은 작업에 성공한 레코드 수를 반환한다.
			int cnt = stmt.executeUpdate(sql);
			
			System.out.println("반환값 : " + cnt);
			
			if(cnt > 0){
				System.out.println("insert 성공~");
			}else{
				System.out.println("insert 실패!");
			}
			       
                         
		} catch (SQLException e) {
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}finally{
			
			if(stmt != null) try {stmt.close();} catch (SQLException e2) {}
			if(conn != null) try {conn.close();} catch (SQLException e2) {}
	  }
	}

}