songservice.java

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

package music.service;

import java.util.ArrayList;
import java.util.List;

import music.hibernate.Song;

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


public class SongService {
	/**
	 * 插入一条音频记录
	 * @param music
	 */
	public void insertSong(Song song)
	{
		SessionFactory sf = new Configuration().configure().buildSessionFactory();
		Session session = sf.openSession();		
		Transaction tx = session.beginTransaction();	
		session.save(song);
		tx.commit();
		session.close();	
	}
	
	/**
	 * 列出音频记录的种类
	 * @return
	 */
	public List listSongType() {
		SessionFactory sf = new Configuration().configure().buildSessionFactory();
		Session session = sf.openSession();

		String str = new String();
		str = "from SongType type";
		Query query = session.createQuery(str);
		List list = new ArrayList();
		list = query.list();
		return list;
	}
	
    /**
     * 列出所有音频记录
     * @return
     */
	public List listSong() {
		SessionFactory sf = new Configuration().configure().buildSessionFactory();
		Session session = sf.openSession();
				
		String str = "select song from Song song";
		Query query = session.createQuery(str);
		List list = query.list();
				
		session.flush();
		
		return list;
		
	}
	/**
	 * 根据用户需求得音频记录
	 * @param firstnum
	 * @param maxnum
	 * @return
	 */
	public List listCustomSong(int firstnum,int maxnum) {
		SessionFactory sf = new Configuration().configure().buildSessionFactory();
		Session session = sf.openSession();
		Transaction tx = session.beginTransaction();
			Query query = session.createQuery("from Song");
			query.setFirstResult(firstnum);                               
			query.setMaxResults(maxnum);
			List list = query.list();	
			tx.commit();
			session.close();
		return list;
	}

	
	/**
	 * 得到一条音频记录
	 * @param id
	 * @return
	 */
	public Song getOneSong(String ID){
		SessionFactory sf = new Configuration().configure().buildSessionFactory();
		Session session = sf.openSession();
		
		Transaction tx = session.beginTransaction();	

	
		Song song = (Song)session.get(Song.class, ID);
		tx.commit();
		session.close();
		return song;
	}
	
	/**
	 * 修改音频记录
	 * @param music
	 */
	public void updateSong(Song song){
		SessionFactory sf = new Configuration().configure().buildSessionFactory();
		Session session = sf.openSession();
		Transaction tx = session.beginTransaction();	
		session.update(song);
		tx.commit();
		session.flush();
//		session.close();
	}	
	

	/**
	 * 删除单个歌曲！
	 */
	public void delSong(Song song){
		SessionFactory sf = new Configuration().configure().buildSessionFactory();
		Session session = sf.openSession();
		Transaction tx = session.beginTransaction();	
		session.delete(song);
		tx.commit();
		session.flush();

	}

}