【Java开源代码栏目提醒】:本文主要为网学会员提供BspCorpSplDAOImpl.java,希望对需要BspCorpSplDAOImpl.java网友有所帮助,学习一下!
package ch17.dao;
import java.util.List;
import java.util.Vector;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.Query;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import ch17.hibernate.BspCorp;
import ch17.hibernate.BspCorpSpl;
import ch17.hibernate.BspUser;
public class BspCorpSplDAOImpl extends HibernateDaoSupport implements BspCorpSplDAO {
public static final Log log = LogFactory.getLog(BspCorp.class);
@Override//根据公司ID查找认证的公司信息
public List getCerCorp(String uid) {
String sql = "SELECT {b.*} FROM bsp_corp_spl a,bsp_corp b where a.corp_id=? and a.spl=b.corp_id";
return this.getSession().createSQLQuery(sql).addEntity("b",BspCorp.class).setString(0, uid).list();
}//查找除用户ID外的所有公司信息
public List getAllCorp(String uid) {
String sql = "SELECT {b.*} FROM bsp_corp b where b.corp_id<>? ";
return this.getSession().createSQLQuery(sql).addEntity("b",BspCorp.class).setString(0, uid).list();
}
@Override//查找系统中所有公司信息
public List geCorp() {
String sql = "SELECT {b.*} FROM bsp_corp b ";
return this.getSession().createSQLQuery(sql).addEntity("b",BspCorp.class).list();
}
@Override//保存认证公司信息
public void save(BspCorpSpl transientInstance) {
log.debug("saving BspCorpSpl instance");
try {
this.getHibernateTemplate().save(transientInstance);
log.debug("save successful");
} catch (RuntimeException re) {
log.error("save failed", re);
throw re;
}
}
@Override//更新公司认证信息
public void update(BspCorpSpl transientInstance) {
log.debug("saving BspCorpSpl instance");
try {
this.getHibernateTemplate().update(transientInstance);
log.debug("save successful");
} catch (RuntimeException re) {
log.error("save failed", re);
throw re;
}
}
}
上一篇:
BspCorpSplDAO.java
下一篇:
法律专业开题报告范文