Hibernate的增、删、改、查

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;
 }
}