myservicesdao.java

本文件是设计学习的很好的书籍

package com.yuanzhen.dao;

import java.text.ParseException;
import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import com.yourcompany.struts.form.ServiceoneForm;
import com.yourcompany.struts.form.ServicetwoForm;
import com.yuanzhen.model.Serviceone;
import com.yuanzhen.model.Servicetwo;
import com.yuanzhen.model.Subjectone;
import com.yuanzhen.model.Subjecttwo;
import com.yuanzhen.model.UserkeyDAO;

public class MyServicesDAO extends UserkeyDAO implements IServicesDAO{

	public List getCheckadmin(String username, String password) {
		String hql = "from Userkey as u where u.username = '"+username+"' and u.password = '"+password+"'";
        Session session = getSession();
        Query query = session.createQuery(hql);
        return query.list(); 
	}

	public List getshebeixiao() {
		String hql = "from Subjectone";
		Session session = getSession();
		Query query = session.createQuery(hql);
		List list = query.list();
		return list;
	}

	public List getshebeikanBySearch(ServiceoneForm form, Integer begin, Integer max) throws ParseException {
		String hql = "from Serviceone as s where s.faction like '%"+form.getFaction()+"%' and s.subjectone like '%"+form.getSubjectone()+"%'" +
				"and s.model like '%"+form.getModel()+"%' and s.shijian <= '"+form.getSearchETime()+"' and s.shijian >= '"+form.getSearchBTime()+"' and s.inprice <= '"+form.getSearchEinprice()+"' and s.inprice >= '"+form.getSearchBinprice()+"' and s.suggestprice <= '"+form.getSearchEsuggestprice()+"' and s.suggestprice >= '"+form.getSearchBsuggestprice()+"' order by s.shijian desc";
        System.out.println("hql1=="+hql);
		Session session = getSession();
        Query query = session.createQuery(hql);
        query.setFirstResult(begin);
        query.setMaxResults(max);
        return query.list(); 
	}

	public Integer getshebeikanBySearchSize(ServiceoneForm form) {
		String hql = "select count(*) from Serviceone as s where s.faction like '%"+form.getFaction()+"%' and s.subjectone like '%"+form.getSubjectone()+"%'" +
				"and s.model like '%"+form.getModel()+"%' and s.shijian <= '"+form.getSearchETime()+"' and s.shijian >= '"+form.getSearchBTime()+"' and s.inprice <= '"+form.getSearchEinprice()+"' and s.inprice >= '"+form.getSearchBinprice()+"' and s.suggestprice <= '"+form.getSearchEsuggestprice()+"' and s.suggestprice >= '"+form.getSearchBsuggestprice()+"'";
		System.out.println("hql2222=="+hql);
		Session session = getSession();
		Query query = session.createQuery(hql);
		List list = query.list();
		Long l = (Long) list.get(0);
		Integer i = l.intValue();
		return i;
	}

	public int updateshebeixiao(String id, String subjectone) {
		String hql = "update Subjectone as s set s.subjectone = '"+subjectone+"' where s.id ='"+id+"'";
		Session session = getSession();
		int   updated   =   session.createQuery(hql).executeUpdate();   
        return updated;
	}

	public int delshebeixiao(String id) {
		Session   session   =   getSession(); 
        String   hql   =   "delete Subjectone as s where s.id= '"+id+"'"; 
        int   deleted   =   session.createQuery(hql).executeUpdate();   
		return deleted;
	}

	public void insertshebeixiao(Subjectone s) {
		Session session = getSession();
		session.save(s);
	}

	public int updateshebeiall(String id, String faction, String parameter, String inprice, String note, String model, String subjectone,String relation,String marking,String suggestprice,String unit) {
		String hql = "update Serviceone as s set s.faction = '"+faction+"',s.parameter = '"+parameter+"',s.inprice = '"+inprice+"',s.note = '"+note+"',s.model = '"+model+"',s.subjectone = '"+subjectone+"',s.relation = '"+relation+"',s.marking = '"+marking+"',s.suggestprice = '"+suggestprice+"',s.unit = '"+unit+"' where s.id ='"+id+"'";
		Session session = getSession();
		int   updated   =   session.createQuery(hql).executeUpdate();   
        return updated;
	}

	public int delshebeiall(String id) {
		Session   session   =   getSession(); 
        String   hql   =   "delete Serviceone as s where s.id= '"+id+"'"; 
        int   deleted   =   session.createQuery(hql).executeUpdate();   
		return deleted;
	}

	public void insertshebeiall(Serviceone s) {
		Session session = getSession();
		session.save(s);
	}

	public List getcailiaoxiao() {
		String hql = "from Subjecttwo";
		Session session = getSession();
		Query query = session.createQuery(hql);
		List list = query.list();
		return list;
	}

	public List getcailiaokanBySearch(ServicetwoForm form, Integer begin, Integer max) throws ParseException {
		String hql = "from Servicetwo as s where s.faction like '%"+form.getFaction()+"%' and s.subjecttwo like '%"+form.getSubjecttwo()+"%'" +
				"and s.model like '%"+form.getModel()+"%' and s.shijian <= '"+form.getSearchETime()+"' and s.shijian >= '"+form.getSearchBTime()+"' and s.inprice <= '"+form.getSearchEinprice()+"' and s.inprice >= '"+form.getSearchBinprice()+"' and s.suggestprice <= '"+form.getSearchEsuggestprice()+"' and s.suggestprice >= '"+form.getSearchBsuggestprice()+"' order by s.shijian desc";
        System.out.println("hql33333333=="+hql);
        Session session = getSession();
        Query query = session.createQuery(hql);
        query.setFirstResult(begin);
        query.setMaxResults(max);
        return query.list(); 
	}

	public Integer getcailiaokanBySearchSize(ServicetwoForm form) {
		String hql = "select count(*) from Servicetwo as s where s.faction like '%"+form.getFaction()+"%' and s.subjecttwo like '%"+form.getSubjecttwo()+"%'" +
				"and s.model like '%"+form.getModel()+"%' and s.shijian <= '"+form.getSearchETime()+"' and s.shijian >= '"+form.getSearchBTime()+"' and s.inprice <= '"+form.getSearchEinprice()+"' and s.inprice >= '"+form.getSearchBinprice()+"' and s.suggestprice <= '"+form.getSearchEsuggestprice()+"' and s.suggestprice >= '"+form.getSearchBsuggestprice()+"'";
        System.out.println("hql4444444=="+hql);
        Session session = getSession();
        Query query = session.createQuery(hql);
        List list = query.list();
        Long l = (Long) list.get(0);
        Integer i = l.intValue();
        return i;
	}

	public int updatecailiaoxiao(String id, String subjecttwo) {
		String hql = "update Subjecttwo as s set s.subjecttwo = '"+subjecttwo+"' where s.id ='"+id+"'";
		Session session = getSession();
		int   updated   =   session.createQuery(hql).executeUpdate();   
        return updated;
	}

	public int delcailiaoxiao(String id) {
		Session   session   =   getSession(); 
        String   hql   =   "delete Subjecttwo as s where s.id= '"+id+"'"; 
        int   deleted   =   session.createQuery(hql).executeUpdate();   
		return deleted;
	}

	public void insertcailiaoxiao(Subjecttwo s) {
		Session session = getSession();
		session.save(s);
	}

	public int updatecailiaoall(String id, String faction, String parameter, String inprice, String note, String model, String subjecttwo,String relation,String marking,String suggestprice,String unit) {
		String hql = "update Servicetwo as s set s.faction = '"+faction+"',s.parameter = '"+parameter+"',s.inprice = '"+inprice+"',s.note = '"+note+"',s.model = '"+model+"',s.subjecttwo = '"+subjecttwo+"',s.relation = '"+relation+"',s.marking = '"+marking+"',s.suggestprice = '"+suggestprice+"',s.unit = '"+unit+"' where s.id ='"+id+"'";
		Session session = getSession();
		int   updated   =   session.createQuery(hql).executeUpdate();   
        return updated;
	}

	public int delcailiaoall(String id) {
		Session   session   =   getSession(); 
        String   hql   =   "delete Servicetwo as s where s.id= '"+id+"'"; 
        int   deleted   =   session.createQuery(hql).executeUpdate();   
		return deleted;
	}

	public void insertcailiaoall(Servicetwo s) {
		Session session = getSession();
		session.save(s);
	}

}