자바입니다.

테스트입니다.!

package dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import dbconn.DBConn;
import dto.ClientDTO;


public class ClientDAO extends DBConn{
	
	//DB TABLE 생성
	
	public void createC_DB() throws SQLException, ClassNotFoundException {
		
		
		String url = "jdbc:oracle:thin:@localhost:1522/orcl";
		String sql = "INSERT INTO EMPLOYEETABLE(" + "EMPLOYEE_NUM, " + "NAME, " + "PHONE_NUM, " + "POSITION, " + "SEX"

				+ ") VALUES(?,?,?,?,?)";

		Class.forName("oracle.jdbc.driver.OracleDriver");
		Connection con = DriverManager.getConnection(url, "SCOTT", "tiger");
	}
	
	//회원정보 불러오기 > list에 담기
	public List<ClientDTO> getAllInfo() {
		List<ClientDTO> list = new ArrayList<ClientDTO>();
		try {
			getConn();
			String sql = "SELECT C_CLIENTNUM,C_NAME ,C_PHONENUM ,C_AGE, C_SEX ,C_ADDRESS,C_HEIGHT,C_WEIGHT ,C_REGISTRATIONDATE ,C_EXPIRATIONDATE ,C_IFPT,C_LEFTPTCNT FROM CLIENT ORDER BY C_CLIENTNUM";
			pstmt = conn.prepareStatement(sql);
			rs = pstmt.executeQuery();
			while(rs.next()) {
				ClientDTO vo = new ClientDTO(rs.getInt(1), rs.getString(2), rs.getString(3), rs.getInt(4), rs.getString(5), rs.getString(6),rs.getInt(7),rs.getInt(8),rs.getDate(9),rs.getDate(10),rs.getInt(11),rs.getInt(12));
				list.add(vo);
			}			
		}catch(Exception e) {}
		finally {setDBClose();}
		return list;
	}
	
	//회원 간단정보 조회 >> 생각해보니까 이건 필요 없을수도 있을것같아 위에꺼에서 빼오면 됨.
	public List<ClientDTO> getBriefInfo(){
		List<ClientDTO> list = new ArrayList<ClientDTO>();
		try {
			getConn();
			String sql = "SELECT C_CLIENTNUM,C_NAME ,C_PHONENUM FROM CLIENT ORDER BY C_CLIENTNUM";
			pstmt = conn.prepareStatement(sql);
			rs = pstmt.executeQuery();
			while(rs.next()) {
				ClientDTO vo = new ClientDTO(rs.getInt(1), rs.getString(2), rs.getString(3));
				list.add(vo);
			}			
		}catch(Exception e) {}
		finally {setDBClose();}
		return list;
	}
	
	//회원 상세정보 조회 getAllInfo() 한다음에 원하는 정보만 쏙쏙 출력해야지..?이거혹시 번거로운 작업인가?
//	public List<ClientDTO> getDetailInfo(){
//	}
	
	
	//회원 검색
//	public void getSearch() {
//		if(searchWord.getText().equals("")) {//검색어가 없을때
//			JOptionPane.showMessageDialog(this, "검색어를 입력하세요..");
//		}else {//검색어가 있을때
//			MemberDAO dao = new MemberDAO();
//			List<MemberVO> list = dao.getSearchRecord(searchWord.getText().trim());
//			if(list.size()<=0) {//검색레코드가 없을때
//				JOptionPane.showMessageDialog(this, "검색결과가 없습니다...");
//			}else {//검색레코드가 있을때
//				model.setNumRows(0);//jtable에 있는 레코드 지우기
//				for(MemberVO vo: list) {
//					Object data[] = {
//							vo.getNum(), vo.getUsername(), vo.getAddr(),
//							vo.getTel()
//					};
//					model.addRow(data);
//				}
//			}
//		}		
//	}
	
	 
	//회원상태 출력 (이용중 ,만료)
	//헬스장등록 메소드(1개월,3개월,6개월,1년)
	//피티등록 메소드(횟수)
	
	//회원 추가
	
	public void setInsert() {
		
		String name = "";
		String phoneNum = "";
		int age = 0;
		String sex = "";
		String address = "";
		double height =0.0;
		double weight= 0.0;
		int ifpt =0;
		
		try {
			getConn();
			String sql = "INSERT INTO CLIENT("
					//+ " C_CLIENTNUM," --자동 추가  
					+ "C_NAME ,"
					+ "C_PHONENUM ,"
					+ "C_AGE,"
					+ " C_SEX ,"
					+ "C_ADDRESS,"
					+ "C_HEIGHT,"
					+ "C_WEIGHT ,"
					//+ "C_REGISTRATIONDATE ,"--자동 추가 
					//+ "C_EXPIRATIONDATE ,"  --자동 추rk
					+ "C_IFPT,"
					//+ "C_LEFTPTCNT " --자동추
					+ ") VALUES (?,?,?,?,?,?,?,?)";//Statement에서 지원해
			PreparedStatement st = conn.prepareStatement(sql);// 미리 시퀄문 준비한다음 실행만 할수 있도록한다.!
			//rs = pstmt.executeQuery();
			st.setString(1, name);
			st.setString(2, phoneNum);
			st.setInt(3, age);
			st.setString(4, sex);
			st.setString(5, address);
			st.setDouble(6, height);
			st.setDouble(7, weight);
			st.setInt(8, ifpt);
			
			int result = st.executeUpdate();//excuteUpdate : Insert, Update, Delete 같은 조작을 위한 커   
			System.out.println(result);
			
		}catch(Exception e) {}
		finally {setDBClose();}
	}
	
//	public void setInsert() {
//		
//		
//	}
	
	//회원 수정
	public void setUpdate() {
		
	}
	
	//회원 삭제
	public void setDelete() {
		
	}
	

	
}

ㅎ