데베

package dbConn;

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

public static void main(String[] args) {

Connection cn = connecting();
Scanner sc = new Scanner(System.in);
Statement st = null;

try {
st = cn.createStatement();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

showData(st);

while(true)
{
int sel = 0;
System.out.println("리스트보기(1), 입력(2), 삭제(3), 수정(4), 종료(5)");
sel = sc.nextInt();
if(sel == 0)
{
break;
}
switch (sel) {
case 1:
showData(st);
break;
case 2:
insertData(st);
break;

case 3:
deleteData(st);
break;
case 4:
editData(st);
break;

default:
break;
}
}
System.out.println("종료되었습니다.");
}

private static void editData(Statement st) {
// TODO Auto-generated method stub

}

private static void deleteData(Statement st) {
// TODO Auto-generated method stub

}

private static void insertData(Statement st) {
// TODO Auto-generated method stub

}

private static void showData(Statement st) {
String sql="";

sql ="select * from member";
try {
ResultSet rs=st.executeQuery(sql);
while(rs.next())
{
int num = rs.getInt(1);
String name = rs.getString("name");
String age = rs.getString(3);
String blood = rs.getString(4);
String height = rs.getString(5);
String job = rs.getString(6);

System.out.println(
"번호 : " +num +
" 이름 : " +name +
" 나이 : " +age +
" 혈액형 : " +blood +
" 키 : "+height +
" 직업 : "+job
);
}
} catch (SQLException e) {

e.printStackTrace();
}
}

private static Connection connecting() {

String url = "jdbc:oracle:thin:@127.0.0.1:1521:xe";
String id="system";
String pwd="oracle";
Connection cn = null;
boolean check=true;

try {
Class.forName("oracle.jdbc.driver.OracleDriver");
check=true;
} catch (ClassNotFoundException e) {
System.out.println("오라클 드라이버 적재를 실패하였습니다.");
e.printStackTrace();
check=false;
}
if(check)
{
System.out.println("오라클 드라이버 적재를 성공하였습니다.");

}

try {
cn = DriverManager.getConnection(url, id, pwd);
check = true;
} catch (SQLException e) {
check = false;
System.out.println("오라클 데이터 베이스 연결을 실패");
e.printStackTrace();
}
if(check)
{
System.out.println("오라클 데이터 베이스 연결를 성공하였습니다.");

}
return cn;
}

}