package com.vst.dao.hibernate;
import com.vst.dao.DiameterDao;
import com.vst.model.Diameter;
import java.sql.SQLException;
import java.util.List;
import com.vst.model.*;
import java.sql.*;
import java.util.ArrayList;
import java.util.Properties;
/**
* Created by IntelliJ IDEA.
* User: And Lilia
* Date: 12.05.2009
* Time: 17:32:04
* To change this template use File | Settings | File Templates.
*/
public class DiameterDaoImpl extends BaseDaoHibernate implements DiameterDao {
public void insert(Diameter diameter) {
saveObject(diameter);
}
public void update(Diameter diameter) {
saveObject(diameter);
}
public void delete(Diameter diameter) {
removeEntity(diameter);
}
public Diameter getDiameterById(Integer id) {
Diameter diameter=(Diameter)getObject(id);
return diameter;
}
public List getListDiameter() {
return getObjects();
}
public List getThListByDiameter(Integer id, String currentPath,Properties props) throws SQLException {
// String driverURL = "jdbc:mysql://localhost/vstbase";
//
// Connection dbConn = null;
// try {
// Class.forName("com.mysql.jdbc.Driver");
// dbConn = DriverManager.getConnection(driverURL, props);
// Statement st = dbConn.createStatement();
// ResultSet rs= st.executeQuery("select thickness.* from thickness, thicknessRealtions where thickness.thicknessId=thicknessRealtions.thicknessId and thicknessRealtions.diametrId="+id);
//
// List thList = new ArrayList();
// while (rs.next()){
// Thickness th= new Thickness();
// th.setThicknessCount((Double)rs.getDouble(2));
// th.setThicknessId((Integer)rs.getInt(1));
// thList.add(th);
// }
// rs.close();
// return thList;
// }
// catch (Exception e) {
// e.printStackTrace();
// return null;
//
// }
return null;
}
public List getListDiameter(Integer page) {
return super.getSession().createQuery("from Diameter diameter").setFirstResult(page.intValue()*15).setMaxResults(15).list();
}
@Override
Class getServiceClass() {
return Diameter.class;
}
}