userservice.java

本代码是点歌系统的部分代码实现了部分功能

package music.service;

import javax.servlet.http.HttpSession;

import music.hibernate.HibernateUtil;
import music.hibernate.User;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

public class UserService {
	

	public void createUser(User user) {
		SessionFactory sf = new Configuration().configure().buildSessionFactory();
		Session session = sf.openSession();
		Transaction tx = session.beginTransaction();
		session.save(user);
		tx.commit();
		session.close();
	}

	public int checkUser(String userName, String UserPwd) {
		SessionFactory sf = new Configuration().configure().buildSessionFactory();
		Session session = sf.openSession();
		String str = new String();
		int UserType = 0;
		str = " from User as un where un.UserName=:stuName and un.UserPwd=:stuPassword";
		Query query = session.createQuery(str);
		query.setString("stuName", userName);
		query.setString("stuPassword", UserPwd);
		
		
		if (query.list().size() != 0)
		{
			UserType = ((User) (User) (query.list().get(0))).getUserType();
			return UserType;
		}	
		else
		{
			System.out.println("error");
			return UserType;
		}
	
	}
}