package com.cargo.db;

import com.cargo.model.Car;
import java.sql.ResultSet;
import java.util.Collection;
import java.sql.SQLException;
import java.util.ArrayList;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: MR</p>
 * @author BWM
 * @version 1.0
 */

public class Cardb extends Conn implements Keywords {
    private int t;
    private ResultSet rs;
    public Cardb() {
    }

    public Collection select() {
        return this.select("");
    }

    public Collection select(String sql) {
        Collection coll = new ArrayList();
        rs = getRs(SELECT + "*" + FROM + "tb_car" + sql);
        try {
            while (rs.next()) {
                Car car = new Car();
                car.setId(rs.getInt(1));
                car.setShopsign(rs.getString(2));
                car.setChauffeur(rs.getString(3));
                car.setArea(rs.getString(4));
                car.setTel(rs.getString(5));
                car.setResume(rs.getString(6));
                coll.add(car);
            }
        } catch (SQLException ex) {
            System.out.print(ex.getMessage());
            ex.printStackTrace();
        }
        close();
        return coll;
    }

    public int insert(Car car) {
        t = insert(INSERT_INTO + "tb_car(shopsign,chauffeur,area,tel,resume)" +
                   VALUES + "('" + car.getShopsign() + "','" + car.getChauffeur() +
                   "','" + car.getArea() + "','" + car.getTel() + "','" +
                   car.getResume() + "')");
        return t;
    }
    public int update(Car car) {
        t = update(UPDATE + "tb_car" + SET + "shopsign='" + car.getShopsign() +
                   "',chauffeur='" + car.getChauffeur() + "',area='" +
                   car.getArea() + "',tel='" + car.getTel() + "',resume='" +
                   car.getResume() + "'" + WHERE + "id=" + car.getId());
        return t;
    }

}