package zichan;

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

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class CateModel {
    String cateid;
    String catename;
    String subcateid;
    String subcatename;
    DBConnt dbc;
    Connection conn;

    public CateModel() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    public CateModel(String a, String b, String c, String d) {
        cateid = a;
        catename = b;
        subcateid = c;
        subcatename = d;
    }

    public void SetAll(String b, String d) {
        catename = b;
        subcatename = d;
    }

    public String getCateId() {
        return cateid;
    }

    public String getCateName() {
        return catename;
    }

    public String getSubCateId() {
        return subcateid;
    }

    public String getSubCateName() {
        return subcatename;
    }

    public void insert() {
        dbc = new DBConnt();
        conn = dbc.getConnection();
        try {
            PreparedStatement pstmt =
                    conn.prepareStatement("insert into CATEGORY (CATEID,CATENAME,SUBCATEID,SUBCATENAME) values (?, ?, ?, ?)");
            pstmt.setInt(1, Integer.parseInt(cateid));
            pstmt.setString(2, catename);
            pstmt.setInt(3, Integer.parseInt(subcateid));
            pstmt.setString(4, subcatename);
            pstmt.execute();
            conn.commit();
            conn.close();
        } catch (java.sql.SQLException s) {
            s.printStackTrace();
        }
    }

    public void select() {
        dbc = new DBConnt();
        conn = dbc.getConnection();
        try {
            String sql = "SELECT CATEID,rtrim(CATENAME),SUBCATEID,rtrim(SUBCATENAME) FROM category where subcateid = " +
                         Integer.parseInt(subcateid);
            Statement stmt = conn.createStatement();
            ResultSet rset = stmt.executeQuery(sql);
            while (rset.next()) {
                cateid = rset.getString(1);
                catename = rset.getString(2);
                subcatename = rset.getString(4);
            }
            conn.commit();
            rset.close();
            stmt.close();
            conn.close();
        } catch (java.sql.SQLException s) {
            System.out.println("exception: " + s.getMessage());
        }
    }

    public void update() {
        dbc = new DBConnt();
        conn = dbc.getConnection();
        try {
            PreparedStatement pstmt =
                    conn.prepareStatement(
                    "update category set CATENAME = ?,SUBCATENAME = ? where cateid = " +
                    Integer.parseInt(cateid) + " and subcateid = " +
                    Integer.parseInt(subcateid));
            pstmt.setString(1, catename);
            pstmt.setString(2, subcatename);
            pstmt.execute();
            conn.commit();
            conn.close();
        } catch (java.sql.SQLException s) {
            System.out.println("exception: " + s.getMessage());
        }
    }

    public void delete() {
        dbc = new DBConnt();
        conn = dbc.getConnection();
        try {
            PreparedStatement pstmt =
                    conn.prepareStatement("delete category where cateid = " +
                                          Integer.parseInt(cateid) +
                                          " and subcateid = " +
                                          Integer.parseInt(subcateid));
            pstmt.execute();
            conn.commit();
            cateid = null;
            catename = null;
            subcateid = null;
            subcatename = null;
            conn.close();
        } catch (java.sql.SQLException s) {
            System.out.println("exception: " + s.getMessage());
        }

    }

    private void jbInit() throws Exception {
    }
}