newstypeimpl.java

学校新闻发布系统

package org.news.impl;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.news.dao.INewsType;
import org.news.hsf.HibernateSessionFactory;
import org.news.pojo.NewsType;
import org.users.pojo.Users;


public class NewsTypeImpl implements INewsType {
	private Session session;
	private Transaction tx;

	public NewsType findById(Integer id) {
		session = HibernateSessionFactory.getSession();
		tx = session.beginTransaction();
		NewsType newsType = (NewsType) session.load(NewsType.class, id);
		tx.commit();
		return newsType;
	}

	public List queryAll() {
		session = HibernateSessionFactory.getSession();
		tx = session.beginTransaction();
		Query query = session.createQuery("from NewsType");
		List newsTypeList = query.list();
		tx.commit();
		return newsTypeList;
	}

	public List LoginQuery(String name, String pw) {
		session = HibernateSessionFactory.getSession();
		tx = session.beginTransaction();
		Query q=session.createQuery("from Users where username='"+name+"' and password='"+pw+"'");
		List l=q.list();
		tx.commit();
		return l;
	}

	
}