<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:aop="http://www.springframework.org/schema/aop"
	xmlns:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation="http://www.springframework.org/schema/beans 
         http://www.springframework.org/schema/beans/spring-beans-2.0.xsd
         http://www.springframework.org/schema/tx
         http://www.springframework.org/schema/tx/spring-tx-2.0.xsd
         http://www.springframework.org/schema/aop
         http://www.springframework.org/schema/aop/spring-aop-2.0.xsd">         
	<!-- 定义数据源 -->	
	<bean id="dataSource"
		class="org.apache.commons.dbcp.BasicDataSource">
		<property name="driverClassName"
			value="com.mysql.jdbc.Driver">
		</property>
		<property name="url" value="jdbc:mysql://localhost:3306/jjufriend"></property>
		<property name="username" value="root"></property>
		<property name="password" value="root"></property>
	</bean>
	
	<!-- 定义Hibernate的sessionFactory -->	
	<bean id="sessionFactory"
		class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="dataSource">
			<ref bean="dataSource" />
		</property>
		
		<!-- Hibernate  的sessionFactory的属性 -->
		
		<property name="hibernateProperties">		
			<props>
				<!-- 数据库方言 -->
				<prop key="hibernate.dialect">
					org.hibernate.dialect.SQLServerDialect
				</prop>
				<!-- 显示Hibernate持久化操作所生成的SQL语句 -->
				<prop key="hibernate.show_sql">true</prop>
				<!-- 将SQL脚本进行格式化后再输出 -->
				<prop key="hibernate.format_sql">true</prop>			
			</props>
		</property>
		<!-- 列出全部的映射文件 -->
		<property name="mappingResources">
			<list>						
				<value>com/jjufriend/student/model/Student.hbm.xml</value></list>
		</property></bean>
	
	<!-- 配置dao组件 -->
	<bean id="studentDao"
		class="com.jjufriend.student.dao.impl.StudentDaoHibernate">
		<!-- 依赖注入DAO组件所必需的SessionFactory引用 -->
		<property name="sessionFactory" ref="sessionFactory">
		</property>
	</bean>
	<!-- 配置业务逻辑组件 -->
	<bean id="mgr"
		class="com.jjufriend.student.service.impl.StudentManagerImpl">
		<property name="studentDao" ref="studentDao"></property>
	</bean>
	

package com.jjufriend.student.dao;

import java.util.List;

import com.jjufriend.student.model.Student;

public interface StudentDao {
	
	Student get(Integer id);
	
	Integer save(Student student);
	
	void update(Student student);
	
	void delete(Student student);
	
	void delete(Integer id);
	
	List<Student> findAll();
	
	Student findStudentByNameAndPass(String username,String password);
	
	Student findByName(String username);

}

package com.jjufriend.student.dao.impl;

import java.io.Serializable;
import java.util.List;

import org.hibernate.SessionFactory;
import org.springframework.orm.hibernate3.HibernateTemplate;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.jjufriend.student.dao.StudentDao;
import com.jjufriend.student.model.Student;

public class StudentDaoHibernate extends HibernateDaoSupport implements
		StudentDao,Serializable {
	private SessionFactory sessionFactory;  
	HibernateTemplate ht = this.getHibernateTemplate() ;
	


	public void delete(Student student) {
		// TODO Auto-generated method stub
		getHibernateTemplate().delete(student);

	}

	public void delete(Integer id) {
		// TODO Auto-generated method stub
		getHibernateTemplate().delete(get(id));

	}

	public List<Student> findAll() {
		// TODO Auto-generated method stub
		return (List<Student>)getHibernateTemplate().find("from Student");
		
	}

	public Student findByName(String username) {
		
		List stu =  getHibernateTemplate().find("from Student st where st.username = ?",username);
		
		if(stu != null && stu.size() >= 1){
			return (Student)stu.get(0);
		}
		
		return null;
	}

	public Student findStudentByNameAndPass(String username, String password) {
		// TODO Auto-generated method stub
		List students = null;
		try{
			
		//	HibernateTemplate temple = this.getHibernateTemplate();
System.out.println("模板类是否为NULL>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>"+ht);
			
//	取出所有		students = temple.find("from student");
						students = ht.find("from student st where st.username = " + username + " and st.password = " + password);
				
		}catch(Exception  e){
			System.out.println("查找过程中出现异常..............");
			e.printStackTrace();
		}
		if(students != null && students.size() >= 1){
			return (Student)students.get(0);
			}
		return null;
	}

	public Student get(Integer id) {
		
		return (Student)getHibernateTemplate().get(Student.class, id);
		
	}

	public Integer save(Student student) {
		return (Integer)getHibernateTemplate().save(student);
	}

	public void update(Student student) {
		// TODO Auto-generated method stub
		getHibernateTemplate().update(student);

	}

}

package com.jjufriend.student.service;

import com.jjufriend.student.model.Student;

public interface StudentManager {

	int addStudent(Student student) throws Exception;
	
	int loginValid(Student student) throws Exception;
	
	boolean validateName(String username) throws Exception;
}

package com.jjufriend.student.service.impl;

import com.jjufriend.student.dao.StudentDao;
import com.jjufriend.student.dao.impl.StudentDaoHibernate;
import com.jjufriend.student.model.Student;
import com.jjufriend.student.service.StudentManager;

public class StudentManagerImpl implements StudentManager {
	/*2009-11-12 22:44修改 出去new StudentDaoHibernate() 	*/
	private StudentDao studentDao = new StudentDaoHibernate() ;
	 
//	private ApplicationContext cxt = 
//			new FileSystemXmlApplicationContext("../webapps/JJUFriend/WEB-INF/applicationContext.xml");
//	 studentDao =(StudentDaoHibernate)cxt.getBean("studentDao");

	public void setStudentDao(StudentDao studentDao){
		
		this.studentDao = studentDao ;
	}
	

	public int addStudent(Student student) throws Exception {
		// TODO Auto-generated method stub
		try{
			studentDao.save(student);
			return student.getId();
			
		}catch(Exception e){
			e.printStackTrace();
			throw new Exception("新增用户时出现异常");
		}
		
	}

	public int loginValid(Student student) throws Exception {
		try{
			
System.out.println(studentDao);
System.out.println("是否取到页面提交的数据：Name="+student.getUsername());
			Student stu = studentDao.findStudentByNameAndPass(student.getUsername(), student.getPassword());
			if(stu != null ){
				return stu.getId();
			}
			
		}catch(Exception e){		
			System.out.println("验证用户登录时出现异常");
			e.printStackTrace();
		}
		
		// TODO Auto-generated method stub
		return -1;
	}

	public boolean validateName(String username) throws Exception {
		// TODO Auto-generated method stub
		try{
			if (studentDao.findByName(username) != null){
				return true ;
			}
			
			
		}catch(Exception e){
			System.out.println("验证用户名是否用效时出错");
			e.printStackTrace();
			
		}
		return false ; 
		
	}

}

//	private ApplicationContext cxt = 
//	new FileSystemXmlApplicationContext("../webapps/JJUFriend/WEB-INF/applicationContext.xml");
//	private StudentDao studentDao =(StudentDaoHibernate)cxt.getBean("studentDao");

private ApplicationContext cxt =  this.getApplicationContext();   
	private StudentDao studentDao = (StudentDaoHibernate)cxt.getBean("studentDao"); 

  private ApplicationContext cxt =    
 new FileSystemXmlApplicationContext("../webapps/JJUFriend/WEB-INF/applicationContext.xml");   
  private StudentDao studentDao =(StudentDaoHibernate)cxt.getBean("studentDao");