【Java开源代码栏目提醒】:本文主要为网学会员提供BspMySplContactDAOImpl.java,希望对需要BspMySplContactDAOImpl.java网友有所帮助,学习一下!
package ch17.dao;
import java.util.List;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import ch17.hibernate.BspCorp;
import ch17.hibernate.BspMySplContact;
import ch17.hibernate.BspUser;
public class BspMySplContactDAOImpl extends HibernateDaoSupport implements BspMySplContactDAO {
public static final Log log = LogFactory.getLog(BspMySplContactDAOImpl.class);
@Override//根据公司ID和用户ID查找用户信息
public List getMyContact(String uid) {
String sql = "SELECT distinct a.corp_Id FROM bsp_my_spl_contact a where a.my_id=? ";
return this.getSession().createSQLQuery(sql).setString(0, uid).list();
}//根据我的ID查找我的联系人
public List getInqContact(String uid) {
String sql = "SELECT distinct a.CONT_ID FROM bsp_my_spl_contact a where a.my_id=? ";
return this.getSession().createSQLQuery(sql).setString(0, uid).list();
}//根据用户ID查找用户信息
public List getUser(String cid,String unbr) {
String sql = "SELECT {a.*} FROM bsp_my_spl_contact a where a.my_id='"+unbr+"' and corp_id='"+cid+"' ";
try{
return this.getHibernateTemplate().getSessionFactory().openSession().createSQLQuery(sql).addEntity("a",BspMySplContact.class).list();
}catch(Exception ex){
ex.printStackTrace();
}
return null;
}
@Override//保存联系人信息
public void save(BspMySplContact transientInstance) {
log.debug("saving BspMySplContact instance");
try {
this.getHibernateTemplate().save(transientInstance);
log.debug("save successful");
} catch (RuntimeException re) {
log.error("save failed", re);
throw re;
}
}
@Override
public void update(BspMySplContact transientInstance) {
log.debug("saving BspMySplContact instance");
try {
this.getHibernateTemplate().update(transientInstance);
log.debug("save successful");
} catch (RuntimeException re) {
log.error("save failed", re);
throw re;
}
}
}
上一篇:
BspMySplContactDAO.java
下一篇:
多年来只想说一句,我不怪你