package sei.pubmgr;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import sei.SqlBean;

public class Book extends SqlBean{
    private String ID;
    private String BOOK_ID;
    
    private String BOOK_NAME;
    private String BOOK_CLASS; 
    private String BOOK_AUTHOR;
    private String BOOK_PUB;
    private String BOOK_VER;
    public  float BOOK_PRICE;
    public int BOOK_NUM;
    private String BOOK_AREA;
    private String BOOK_MEMO;

    public void setID(String ID)
    {
        this.ID=ID;
    }

    public void setBOOK_ID(String BOOK_ID)
    {
        this.BOOK_ID=getLimitLenStr(BOOK_ID,20);
    }
    public String getBOOK_ID()
    {
        if(this.BOOK_ID==null) return ""; else return this.BOOK_ID;
    }
    public void setBOOK_NAME(String BOOK_NAME)
    {
        this.BOOK_NAME=getLimitLenStr(BOOK_NAME,60);
    }
    public String getBOOK_NAME()
    {
        if(this.BOOK_NAME==null) return ""; else return this.BOOK_NAME;
    } 
    public void setBOOK_CLASS(String BOOK_CLASS)
    {
        this.BOOK_CLASS=getLimitLenStr(BOOK_CLASS,40);
    }
    public String getBOOK_CLASS()
    {
        if(this.BOOK_CLASS==null) return ""; else return this.BOOK_CLASS;
    } 
    
    public void setBOOK_AUTHOR(String BOOK_AUTHOR)
    {
        this.BOOK_AUTHOR=getLimitLenStr(BOOK_AUTHOR,40);
    }
    public String getBOOK_AUTHOR()
    {
        if(this.BOOK_AUTHOR==null) return ""; else return this.BOOK_AUTHOR;
    }
    public void setBOOK_PUB(String BOOK_PUB)
    {
        this.BOOK_PUB=getLimitLenStr(BOOK_PUB,60);
    }
    public String getBOOK_PUB()
    {
        if(this.BOOK_PUB==null) return ""; else return this.BOOK_PUB;
    }
    public void setBOOK_VER(String BOOK_VER)
    {
        this.BOOK_VER=getLimitLenStr(BOOK_VER,20);
    }
    public String getBOOK_VER()
    {
        if(this.BOOK_VER==null) return ""; else return this.BOOK_VER;
    }
    public void setBOOK_PRICE(float BOOK_PRICE)
    {
        this.BOOK_PRICE=BOOK_PRICE;
    }
    public float getBOOK_PRICE()
    {
        return BOOK_PRICE;
    }
    public  void  setBOOK_NUM(int BOOK_NUM)
    {
        this.BOOK_NUM=BOOK_NUM;
    }
    public int getBOOK_NUM()
    {
        return BOOK_NUM;
    }
    
    public void setBOOK_AREA(String BOOK_AREA)
    {
        this.BOOK_AREA=getLimitLenStr(BOOK_AREA,20);
    }
    public String getBOOK_AREA()
    {
        if(this.BOOK_AREA==null) return ""; else return this.BOOK_AREA;
    }
    public void setBOOK_MEMO(String BOOK_MEMO)
    {
        this.BOOK_MEMO=getLimitLenStr(BOOK_MEMO,20);
    }
    public String getBOOK_MEMO()
    {
        if(this.BOOK_MEMO==null) return ""; else return this.BOOK_MEMO;
    }    
    public void LoadData(String sql)
    {
        try {
             Statement stmt = con.createStatement();
             ResultSet rs = stmt.executeQuery(sql);
             if (rs.next())
             {
                setBOOK_ID(rs.getString("BOOK_ID"));
                setBOOK_NAME(rs.getString("BOOK_NAME"));
                setBOOK_CLASS(rs.getString("BOOK_CLASS"));
                setBOOK_AUTHOR(rs.getString("BOOK_AUTHOR"));
                setBOOK_PUB(rs.getString("BOOK_PUB"));
                setBOOK_VER(rs.getString("BOOK_VER"));
                setBOOK_PRICE(rs.getFloat("BOOK_PRICE"));
                setBOOK_NUM(rs.getInt("BOOK_NUM"));
                setBOOK_AREA(rs.getString("BOOK_AREA"));
                setBOOK_AREA(rs.getString("BOOK_MEMO"));
             }
             rs.close();stmt.close();
        } catch (SQLException ex) {}
    }

    public int Insert(String userid) throws Exception
    {
        
        int Count=-1,n=0;
        
        try {
             Statement stmt = con.createStatement();
             ResultSet rs = stmt.executeQuery("select count(*) as k from T_BOOK where BOOK_ID='"+BOOK_ID+"'");
             if (rs.next())
                 n=rs.getInt(1);
             rs.close();
             stmt.close();
        } catch (SQLException ex) {}
        if(n>0)
        {
            Count=-2;
         }else
         {
        
              PreparedStatement pstmt=null;
              try{
                  pstmt=con.prepareStatement("insert into T_BOOK (BOOK_ID,BOOK_NAME,BOOK_CLASS,BOOK_AUTHOR,BOOK_PUB,BOOK_VER,BOOK_PRICE,BOOK_NUM,BOOK_SUM,BOOK_AREA,BOOK_MEMO) values(?,?,?,?,?,?,?,?,?,?,?)");
                  pstmt.setString(1,getBOOK_ID());
                  pstmt.setString(2,getBOOK_NAME());
                  pstmt.setString(3,getBOOK_CLASS());
                  pstmt.setString(4,getBOOK_AUTHOR());
                  pstmt.setString(5,getBOOK_PUB());
                  pstmt.setString(6,getBOOK_VER());
                  pstmt.setFloat(7,getBOOK_PRICE());
                  pstmt.setInt(8,getBOOK_NUM());
                  pstmt.setFloat(9,getBOOK_NUM()*getBOOK_PRICE());
                  pstmt.setString(10,getBOOK_AREA());
                  pstmt.setString(11,getBOOK_MEMO());
                  Count=pstmt.executeUpdate();
              }catch(Exception ex){ Count=-1; }
       }
        CloseDataBase();
        return Count;
    }

    public int  Update(String userid)
    {
        
        if (ID.equals("")) {CloseDataBase();return -9;}
        int Count=-1,n=0;

        if (!ID.equals(BOOK_ID)){
            try {
                Statement stmt = con.createStatement();
                ResultSet rs = stmt.executeQuery("select count(*) as v from T_BookInfo where BOOK_ID='"+BOOK_ID+"'");
                if (rs.next()) n=rs.getInt(1);
                rs.close();
                stmt.close();
            } catch (SQLException ex) {}
            if (n>0){CloseDataBase();return Count=-2;}
        }        
        
        PreparedStatement pstmt=null;
        try{
            pstmt=con.prepareStatement("update T_BOOK set BOOK_ID=?,BOOK_NAME=?,BOOK_CLASS=?,BOOK_AUTHOR=?,BOOK_PUB=?,BOOK_VER=?,BOOK_PRICE=?,BOOK_NUM=?,BOOK_SUM=?,BOOK_AREA=?,BOOK_MEMO=? where BOOK_ID='"+ID+"'");
                  pstmt.setString(1,getBOOK_ID());
                  pstmt.setString(2,getBOOK_NAME());
                  pstmt.setString(3,getBOOK_CLASS());
                  pstmt.setString(4,getBOOK_AUTHOR());
                  pstmt.setString(5,getBOOK_PUB());
                  pstmt.setString(6,getBOOK_VER());
                  pstmt.setFloat(7,getBOOK_PRICE());
                  pstmt.setInt(8,getBOOK_NUM());
                  pstmt.setFloat(9,getBOOK_PRICE()*getBOOK_NUM());
                  pstmt.setString(10,getBOOK_AREA());
                  pstmt.setString(11,getBOOK_MEMO());
                  Count=pstmt.executeUpdate();
        }catch(Exception ex){ Count=-1; }
        CloseDataBase();
        return Count;
    }
}