package com.jht.navigate;
import java.util.List;
/**
* @author chmin<br>
* @time 2016年1月23日 上午9:39:49<br>
*/
public class ClientInfoDao implements IBaseDao<Clientinfo> {
/**
* 方便使用dao
*/
public static ClientInfoDao dao = new ClientInfoDao();
/**
* 保存實(shí)體
*/
@Override
public boolean add(Clientinfo t) {
String sql = 'insert into tb_clientinfo values (?,?,?,?,?)';
Object[] parameters = new Object[]{t.getKhdm(), t.getCmpyname(), t.getPhone(), t.getAddr()};
return DaoHandle.insert(sql, parameters) == 1 ? true : false;
}
/**
* 刪除實(shí)體
*/
@Override
public boolean remove(Clientinfo t) {
return remove(t.getId());
}
/**
* 刪除實(shí)體
*/
@Override
public boolean remove(int id) {
String sql = 'delete from tb_wxnavinfo where khdm = (select khdm from tb_clientinfo where id = ?)';
Object[] parameters = new Object[]{id};
DaoHandle.executeUpdate(sql, parameters);
sql = 'delete from tb_clientinfo where id = ?';
return DaoHandle.executeUpdate(sql, parameters) == 1 ? true : false;
}
/**
* 更新
*/
@Override
public boolean update(Clientinfo t) {
String sql = 'update tb_clientinfo khdm = ?, cmpyname = ?, phone = ?, addr = ? where id = ?';
Object[] parameters = new Object[]{t.getKhdm(), t.getCmpyname(), t.getPhone(), t.getAddr(), t.getId()};
return DaoHandle.executeUpdate(sql, parameters) == 1 ? true : false;
}
@Override
public boolean addOrUpdate(Clientinfo t) {
if (getObjectByName(t.getKhdm()) == null) {
return add(t);
} else {
return update(t);
}
}
@Override
public Clientinfo getObjectById(int id) {
String sql = 'select * from tb_clientinfo where id = ?';
Object[] parameters = new Object[]{id};
return getObject(sql, parameters);
}
@Override
public Clientinfo getObject(String sql, Object[] parameters) {
List<Clientinfo> list = DaoHandle.select(sql, parameters, Clientinfo.class);
return list == null ? null : list.get(0);
}
@Override
public Clientinfo getObjectByName(String khdm) {
String sql = 'select * from tb_clientinfo where khdm = ?';
Object[] parameters = new Object[]{khdm};
return getObject(sql, parameters);
}
@Override
public List<Clientinfo> getObjectsByName(String khdm) {
String sql = 'select * from tb_clientinfo where khdm = ?';
Object[] parameters = new Object[]{khdm};
return getObjects(sql, parameters);
}
@Override
public List<Clientinfo> getObjects() {
String sql = 'select * from tb_clientinfo order by id desc';
Object[] parameters = new Object[]{};
return getObjects(sql, parameters);
}
@Override
public List<Clientinfo> getObjects(String sql, Object[] parameters) {
return DaoHandle.select(sql, parameters, Clientinfo.class);
}
}
