package book.model;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Date;

import javax.naming.Context;
import javax.naming.InitialContext;

import db.DBUse;

import oracle.jdbc.pool.OracleDataSource;


public class BookDAO
{
    DBUse db = new DBUse();
    Connection conn;
    PreparedStatement pstmt;
    ResultSet rs;
       
    public boolean addBook(BookDTO dto)
    {
        boolean sw = false;
        String sql = \"INSERT INTO BOOK VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\";
       
        try{
            conn = db.getConnection();
            pstmt = conn.prepareStatement(sql);
                       
            pstmt.setString(1, dto.getBookcode());
            pstmt.setString(2, dto.getBookname());
            pstmt.setString(3, dto.getAuthor());
            pstmt.setString(4, dto.getTranslator());
            pstmt.setString(5, dto.getPublisher());
            pstmt.setInt(6, dto.getInput_price());
            pstmt.setInt(7, dto.getOutput_price());
            pstmt.setInt(8, dto.getDiscount_rate());
            pstmt.setInt(9, dto.getMileage());
            pstmt.setInt(10, dto.getIsbn());
            pstmt.setInt(11, dto.getBookdate());
            pstmt.setInt(12, dto.getPage());
            pstmt.setString(13, dto.getBook_type());
            pstmt.setString(14, dto.getIntroducation());
            pstmt.setString(15, dto.getContent());
            System.out.println(\"Content : \"+ dto.getContent());
            pstmt.setInt(16, dto.getBookcount());
            pstmt.setString(17, dto.getStatus());
                      
            int a = pstmt.executeUpdate();
         
            if(a > 0) sw = true;
                        
        }catch(Exception ex){
            System.out.println(\"저장실패 : \" + ex.getMessage());
        }finally{
            DBUse.close(conn, pstmt);
        }
        return sw;
    }
   
  
}
==========================================
콘솔창에 자꾸 \"ORA-01722: 수치가 부적합합니다\" 라고 떠요..ㅠㅠ
데이터 타입은 맞게 넣었는데요..퓨ㅠ