Hibernate的增删改查

package com.lzb.exam.service.impl;

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

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

import com.lzb.exam.pojos.Question;
import com.lzb.exam.pojos.Student;
import com.lzb.exam.service.QuestionService;

public class QuestionServiceImpl implements QuestionService {
 
 public void addQuestion(Question question) {
  Configuration config = new Configuration();
  config.configure();
  SessionFactory sessionFactory = config.buildSessionFactory();
  Session session = sessionFactory.openSession();
  Transaction trans = session.beginTransaction();
  session.save(question);
  trans.commit();
  session.close();
 }
 
 public List<Question> getAllQuestions() {
  
  List<Question> list = new ArrayList<Question>();
  
  Configuration config = new Configuration();
  config.configure();
  SessionFactory sessionFactory = config.buildSessionFactory();
  Session session = sessionFactory.openSession();
  Transaction trans = session.beginTransaction();
  Query query = session.createQuery("from Question");
  list = query.list();   
  return list   ;
 }
 
 public Question getQuestionById(int id) {

  Configuration  config = new Configuration();
  config.configure();
  SessionFactory sessionFactory = config.buildSessionFactory();
  Session session = sessionFactory.openSession();
  Transaction trans = session.beginTransaction();
  Question question = (Question)session.get(Question.class, id);
  trans.commit();
  session.close();
  return question;
 }
 public List<Question> getQuestionsByTitle(String questionTitle) {
  List<Question> list = new ArrayList<Question>();
  Configuration config = new Configuration();
  config.configure();
  SessionFactory sessionFactory = config.buildSessionFactory();
  Session  session = sessionFactory.openSession();
  Transaction trans = session.beginTransaction();
  String sql = "from Student where name like ?";
  Query query = session.createQuery(sql);
  query.setString(0, questionTitle+"%");
  list = query.list();
  trans.commit();
  session.close();  
  return list;
 }
 public void removeQuestionById(int id) {
  System.out.println("要删除的考生是:"+id+"哈哈哈"); 
  Configuration config = new Configuration();
  config.configure();
  SessionFactory sessionFactory = config.buildSessionFactory();
  Session session = sessionFactory.openSession();
  Transaction trans = session.beginTransaction();
  Question question = (Question)session.get(Question.class, id);
  session.delete(question);
  trans.commit();
  session.close();
 }
 public void updateQuestion(Question question) {
  Configuration config = new Configuration();
  config.configure();
  SessionFactory sessionFactory = config.buildSessionFactory();
  Session  session = sessionFactory.openSession();
  Transaction trans = session.beginTransaction();
  session.update(question);
  trans.commit();
  session.close(); 
  
  
 }
 
 
 
}