package com.cargo.db;

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

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

public class Userdb extends Conn implements Keywords {
    private int t;
    private ResultSet rs;
    public int insert(User user) {
        t = insert(INSERT_INTO +
                   "tb_user(id,name,password,age,sex,tel,email,area,address)" +
                   VALUES + "('" + user.getUserid() + "','" + user.getName() +
                   "','" + user.getPassword() + "'," + user.getAge() + "," +
                   user.getSex() + "," + user.getTel() + ",'" + user.getEmail() +
                   "','" + user.getArea() + "','" + user.getAddress() + "')");
        return t;
    }

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

    public Collection select(String sql) {
        Collection coll = new ArrayList();
        rs = getRs(SELECT + "*" + FROM + "tb_user" + sql);
        try {
            while (rs.next()) {
                User user = new User();
                user.setUserid(rs.getString(1));
                user.setName(rs.getString(2));
                user.setPassword(rs.getString(3));
                user.setAge(rs.getInt(4));
                user.setSex(rs.getInt(5));
                user.setTel(rs.getString(6));
                user.setEmail(rs.getString(7));
                user.setArea(rs.getString(8));
                user.setAddress(rs.getString(9));
                coll.add(user);
            }
        } catch (SQLException ex) {
            System.out.println(sql);
            System.out.println(ex.getMessage());
        } finally {
            close();
            return coll;
        }
    }

    public int update(User user) {
        t = update(UPDATE + "tb_user" + SET + "name='" + user.getName() +
                   "',password='" + user.getPassword() + "',age=" + user.getAge() +
                   ",sex=" + user.getSex() +
                   ",tel=" + user.getTel() + ",email='" + user.getEmail() +
                   "',area='" + user.getArea() + "',address='" +
                   user.getAddress() + "'" + WHERE + "id='" + user.getUserid()+"'");
        return t;
    }
}