studentsdao.java

学生信息管理

/*
 * 创建日期 2005-7-18
 *
 */
package limq.hibernate.dao;
import java.util.*;
import limq.hibernate.dao.*;
import java.util.ArrayList;
import java.util.List;
import net.sf.hibernate.HibernateException;
import net.sf.hibernate.Query;
import net.sf.hibernate.Hibernate;
import net.sf.hibernate.Session;
import net.sf.hibernate.Criteria;
import net.sf.hibernate.expression.*;
import org.apache.log4j.BasicConfigurator;
import org.apache.log4j.Logger;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.orm.hibernate.HibernateCallback;
import org.springframework.orm.hibernate.support.HibernateDaoSupport;
import limq.hibernate.vo.*;

/**
 * @author Bluewater
 * 
 * TODO
 */
public class StudentsDao extends BaseDao implements IStudents {
    
    private Logger log = Logger.getLogger(this.getClass());
    
    public String getPasswordFromUsername(String username){
        String password=null;
        Students student=null;
        if(super.loadByKey(Students.class,"name",username)!=null)
         {student= (Students)super.loadByKey(Students.class,"name",username);  
          password =student.getPassword();
          }else System.out.println("the stu is null");
        return password;
    
    }
    
 /**   
    public Students[] getAllStudents() {
        List students = new ArrayList();
        //   students = getHibernateTemplate().find("select c from Students as c ");
        students = getHibernateTemplate().loadAll(Students.class);
        return (Students[]) students.toArray(new Students[0]);
    }

    
    public void addStudent(final Students s) {
        //  getHibernateTemplate().save(s);
        getHibernateTemplate().execute(new HibernateCallback() {
            public Object doInHibernate(Session session)
                    throws HibernateException {
                session.save(s);
                return null;
            }
        });
    }

    
    public Students[] getStuByName(final String name) {
        List result =null;
       result= getHibernateTemplate().executeFind(new HibernateCallback() {
            public Object doInHibernate(Session session)
                    throws HibernateException {

                Criteria criteria = session.createCriteria(Students.class);
                criteria.add(Expression.eq("name", name));
                java.util.List list = criteria.list();
             
                return list;
            }

        });
       return (Students[]) result.toArray(new Students[0]); 
    }

    
    public Students getStudentById(Integer id) {
        Students student = (Students) getHibernateTemplate().get(
                Students.class, id);

        return student;
    }
    
    
    public void delStudent(Students stu){
        getHibernateTemplate().delete(stu);
    }
    
    
    public void delAll(Collection entities){
        getHibernateTemplate().deleteAll(entities); 
    
    }

    
    public void delAll(Class clazz){
        List result = getHibernateTemplate().loadAll(clazz); 
        getHibernateTemplate().deleteAll(result); 
    }
    
    
    public void updateStudent(Students stu){
        getHibernateTemplate().update(stu);
    
    }
    
    
   public Students[] getStudentsByDep(String name){
    
      List list= getHibernateTemplate().find(" select s  from Students as s inner join s.department as d where d.name=?",name);
      
      return (Students[]) list.toArray(new Students[0]);
   }

    public static void main(String[] arg) throws Exception {

        BasicConfigurator.configure();
        ApplicationContext context = new ClassPathXmlApplicationContext(
                "applications.xml");
        IStudents studao = (IStudents) context.getBean("studentService");
       
        Students stu = new Students();
        stu.setName("limq");
        studao.addStudent(stu);

        Students stu2 = studao.getStudentById(new Integer(1));
        System.out.println(stu2.getName());

        Students[] stus = studao.getAllStudents();
     //   stus=studao.getStuByName("daqiang"); 
        stus=studao.getStudentsByDep("english"); 
        System.out.print("here is ok");
        System.out.println(stus.length);
        for (int i = 0; i < stus.length; i++) {
            Students student = stus[i];
            System.out.println(student.getName());

        }
      
        

    }
    **/
}