citydao.java

一个oa系统

package com.oa.db;

import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

//import com.oa.myutil.struts.HibernateSessionFactory;  

public class CityDAO extends HibernateDaoSupport{
	public List query(){
		List list = null;
		try {
	        list=this.getHibernateTemplate().find("from City");
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	    	return list;
    }
	
	
	public String findColumnById(String parecid){//通过id查询
		List list = null;
		String city = "";
		try {
			list = this.getHibernateTemplate().find("from City where cityid=?",parecid);
			if(list!=null&&list.size()!=0){
				City vo = (City)list.get(0);
				city = vo.getCityname();
			}
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return city;
	}

}