areadb.java

东奥汽车销售集团网

package com.cargo.db;

import com.cargo.model.Area;
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 Areadb extends Conn implements Keywords{
    private int t;
    private ResultSet rs;
    public int insert(Area area){
        t=insert(INSERT_INTO+"tb_area(name,resume)"+
        VALUES+"('"+area.getName()+"','"+area.getResume()+"')");
        return t;
    }
    public Collection select(){
        return this.select("");
    }
    public Collection select(String sql){
        Collection coll=new ArrayList();
        rs=getRs(SELECT+"*"+FROM+"tb_area"+sql);
        try {
            while (rs.next()) {
                Area area = new Area();
                area.setId(rs.getInt(1));
                area.setName(rs.getString(2));
                area.setResume(rs.getString(3));
                coll.add(area);
            }
        } catch (SQLException ex) {
            System.out.print(ex.getMessage());
            ex.printStackTrace();
        }
        close();
        return coll;
    }
    public int update(Area area){
        t=update(UPDATE+"tb_area"+SET+"name='"+area.getName()+"',resume='"+area.getResume()+"'"+WHERE+"id="+area.getId());
        return t;
    }
}