studentservice.java

在线考试功能

package com.onlinestudy.service;

import java.sql.SQLException;
import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;




import com.onlinestudy.domain.Classes;
import com.onlinestudy.domain.EncryptUtil;
import com.onlinestudy.domain.Students;

public class StudentService extends HibernateDaoSupport {
	ListForPage listForPage;
	//学生登录
	public boolean login(Students students){
		String name = students.getName();
		String password = EncryptUtil.toMessageDigest(students.getPassword());
		List list = this.getHibernateTemplate().find("from Students  where name='"+name+"' and password='"+password+"' and ispass='是'");
		System.out.println(name+password);
		if(list.size()!=0){
			return true;
		}else{
			return false;	
		}
	}
	
	//增加班级
	public boolean addClasses(Classes classes){
		this.getHibernateTemplate().save(classes);
		return true;
	}
	
	public boolean updateClasses(Classes classes){
		this.getHibernateTemplate().update(classes);
		return true;
	}
	//删除班级
	public boolean deleteClasses(final int id){

	//	this.getHibernateTemplate().delete(this.getHibernateTemplate().load(Classes.class, id));//此处用load()方法出错，待解决
		this.getHibernateTemplate().delete(this.getHibernateTemplate().get(Classes.class,new Integer(id)));
		return true;
	}
	//查询班级
	public List selectClasses(){
		List list = this.getHibernateTemplate().find("from Classes");
		return list;
	}
	
	//按ID号查询班级
	public Classes selectClassesById(int id){
		Classes c = (Classes)this.getHibernateTemplate().get(Classes.class, id);
		return c;
	}
	
	//增加学生
	public boolean addStudent(Students students){
		this.getHibernateTemplate().save(students);
		return true;
	}
	//分页查询学生
	public List selectStudentForPage(String hql,int offset,int length){
		List list = listForPage.getListForPage(hql, offset, length);
		return list;
	}
	//查询单条学生信息
	public Students selectStudentById(int id){
		List list = this.getHibernateTemplate().find("from Students where id="+id);
		Students students = new Students();
		for(int i = 0 ; i < list.size(); i++){
			students = (Students)list.get(i);
		}
		
		return students;
	}

	//查询全部学生记录
	public int selectAllStudent(String hql){
		List list = this.getHibernateTemplate().find(hql);
		int count = list.size();
		return count;
	}
	//修改学生
	public boolean updateStudent(Students students){
		this.getHibernateTemplate().update(students);
		return true;
	}
	
	public boolean deleteStudent(Students students){
		this.getHibernateTemplate().delete(students);
		return true;
	}
	
	//按ID号批量删除
	public boolean deleteStudentBatch(final String[] array){
		
		this.getHibernateTemplate().execute(new HibernateCallback(){
			
			public Object doInHibernate(Session session)
					throws HibernateException, SQLException {
				int id;
				
				for(int i = 0; i < array.length; i++){					
					id = Integer.parseInt(array[i]);
					Students students = new Students();
					students.setId(id);
					session.delete(students);
					System.out.println(id);
					session.close();
				}
				return null;
			}
			
			
		});
		
		return true;
	}

	public void setListForPage(ListForPage listForPage) {
		this.listForPage = listForPage;
	}
	
}