用于jdbc 连接sqlite数据库的dao层

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();

    /**

     * 保存实体

     */

    @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;

    }

    /**

     * 删除实体

     */

    @Override

    public boolean remove(Clientinfo t) {

        return remove(t.getId());

    }

    /**

     * 删除实体

     */

    @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);

    }

}