package com.vst.dao.hibernate;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Properties;
import com.mysql.jdbc.ResultSet;
import com.vst.dao.DetailDurabilityDao;
import com.vst.model.DetailDurability;
/**
* Created by IntelliJ IDEA.
* User: Администратор
* Date: 30.06.2009
* Time: 18:34:13
* To change this template use File | Settings | File Templates.
*/
public class DetailDurabilityDaoHibernate extends BaseDaoHibernate implements DetailDurabilityDao {
public void insert(DetailDurability detailDurability) {
saveObject(detailDurability);
}
public void update(DetailDurability detailDurability) {
saveObject(detailDurability);
}
public DetailDurability getDetailDurabilityById(Integer id) {
return (DetailDurability)getObject(id);
}
public List getDetailDurabilityList() {
return getObjects();
}
public List getDetailDurabilityList(Integer page) {
return super.getSession().createQuery("from DetailDurability").setFirstResult(page.intValue()*15).setMaxResults(15).list();
}
public List getDetailDurabilityListByElementId(Integer id, Properties properties) throws SQLException {
// Connection dbConn=getConnection(properties);
// Statement st = (Statement)dbConn.createStatement();
// ResultSet rs= (ResultSet) st.executeQuery("select * from detaildurability where idElement="+id);
// List plList = setValues(rs);
// rs.close();
return new ArrayList();
}
public void delete(DetailDurability detailDurability) {
removeEntity(detailDurability);
}
private List setValues(ResultSet resultSet) throws SQLException {
List list=new ArrayList();
while (resultSet.next()){
DetailDurability detailDurability=new DetailDurability();
detailDurability.setDurabilityId(Integer.valueOf(resultSet.getInt(1)));
detailDurability.setDurabilityUniqueNumber(resultSet.getString(3));
detailDurability.setDurabilityValue(Double.valueOf(resultSet.getDouble(2)));
list.add(detailDurability);
}
return list;
}
@Override
Class getServiceClass() {
return DetailDurability.class;
}
}