package com.dao;
import java.util.List;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.pojos.TbParameterEditor;
public class TbParameterDao extends HibernateDaoSupport {
/**
*
* 保存参数名称
*
* 参数parameterEditor
*
* 如果result为1,保存成功,为0保存失败
*/
public int saveParamterName(TbParameterEditor parameterEditor) {
int result = 0;
Session session = null;
Transaction tran = null;
session = getSession();// HibernateSessionFactory.getSession();
// //自己创建的session类
try {
tran = session.beginTransaction();
session.save(parameterEditor);
tran.commit();
session.close();
} catch (Exception e) {
e.printStackTrace();
}
return result;
}
/*
* 查询、按参数名称查询
*/
public List<TbParameterEditor> searchParameterName(String parameterName) {
String sqlString;// ="from TbParameterEditor where parameterName='"+parameterName+"'";
if (parameterName == "") {
sqlString = "from TbParameterEditor";
} else {
sqlString = "from TbParameterEditor where parameterName='"
+ parameterName + "'";
}
List<TbParameterEditor> list = getHibernateTemplate().find(sqlString);
return list;
}
/*
* 根据id查询
*/
public TbParameterEditor queryParameter(int id) {
String sqlString = "from TbParameterEditor where ID=" + id;
List list = getHibernateTemplate().find(sqlString);
TbParameterEditor tbParameterEditor = (TbParameterEditor) list.get(0);
return tbParameterEditor;
}
/**
* 修改参数
*
* @param id
* @return
*/
public TbParameterEditor updateParameter(int id, String parameterName,
String parameter1, String parameter2, String parameter3,
String parameter4, String parameter5, String parameter6,
String parameter7, String parameter8, String parameter9,
String parameter10,String explains) {
String sqlString="from TbParameterEditor where ID=" + id;
/*String sqlString = "update TbParameterEditor set parameterName='"
+ parameterName + "'parameter1='" + parameter1
+ "'parameter2='" + parameter2 + "'parameter3='" + parameter3
+ "'parameter4='" + parameter4 + "'parameter5='" + parameter5
+ "'parameter6='" + parameter6 + "'parameter7='" + parameter7
+ "'parameter8='" + parameter8 + "'parameter9='" + parameter9
+ "'parameter10='" + parameter10 + "'where id=" + id;*/
List list=getHibernateTemplate().find(sqlString);
TbParameterEditor tbParameterEditor=(TbParameterEditor) list.get(0);
System.out.println("oooooooooooooooooooooooooooooooooooooooooo");
tbParameterEditor.setParameterName(parameterName);
tbParameterEditor.setParameter1(parameter1);
tbParameterEditor.setParameter2(parameter2);
tbParameterEditor.setParameter3(parameter3);
tbParameterEditor.setParameter4(parameter4);
tbParameterEditor.setParameter5(parameter5);
tbParameterEditor.setParameter6(parameter6);
tbParameterEditor.setParameter7(parameter7);
tbParameterEditor.setParameter8(parameter8);
tbParameterEditor.setParameter9(parameter9);
tbParameterEditor.setParameter10(parameter10);
tbParameterEditor.setExplains(explains);
getHibernateTemplate().update(tbParameterEditor);
System.out.println(tbParameterEditor.getParameterName());
Session session = null;
Transaction tran = null;
session = getSession();// HibernateSessionFactory.getSession();
// //自己创建的session类
try {
tran = session.beginTransaction();
session.save(tbParameterEditor);
tran.commit();
session.close();
} catch (Exception e) {
e.printStackTrace();
}
return tbParameterEditor;
}
public int deleteParameter(int id){
int result=0;
String sqlString="from TbParameterEditor where ID=" + id;
List list=getHibernateTemplate().find(sqlString);
TbParameterEditor tbParameterEditor=(TbParameterEditor) list.get(0);
Session session = null;
Transaction tran = null;
session = getSession();// HibernateSessionFactory.getSession();
//自己创建的session类
try {
tran = session.beginTransaction();
session.delete(tbParameterEditor);
tran.commit();
session.close();
} catch (Exception e) {
e.printStackTrace();
}
return result;
}
}