<?xml version="1.0" encoding="UTF-8"?>
<beans
xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd">
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName"
value="com.microsoft.sqlserver.jdbc.SQLServerDriver">
</property>
<property name="url"
value="jdbc:sqlserver://localhost:1433;databaseName=OfficeAppliction">
</property>
<property name="username" value="sa"></property>
<property name="password" value="ma860709"></property>
</bean>
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.SQLServerDialect
</prop>
</props>
</property>
</bean>
<bean id="userDAO" class="db.imp.userDAOImpl">
<property name="sessionFactory" ref="sessionFactory"></property>
</bean>
</beans>

解决方案 »

  1.   

    package db.imp;import java.util.List;import org.hibernate.Query;
    import org.springframework.orm.hibernate3.support.HibernateDaoSupport;import pojo.CheckType;
    import pojo.UsersInfo;
    import db.dao.userDAO;public class userDAOImpl extends HibernateDaoSupport implements userDAO { public void add(UsersInfo user) {
    this.getHibernateTemplate().save(user); } public void del(UsersInfo user) {
    // TODO Auto-generated method stub } public UsersInfo get(String id) {
    UsersInfo user=(UsersInfo)this.getHibernateTemplate().get(UsersInfo.class,id);
    return user;
    } public UsersInfo login(String userName, String userPassword) {
    String hql="from UsersInfo where userName=? and userPwd=?";
    Query query=this.getSession().createQuery(hql);
    query.setString(0, userName);
    query.setString(1, userPassword);
    UsersInfo user=(UsersInfo)query.uniqueResult();
    return user;
    } public List<UsersInfo> search() {
    // TODO Auto-generated method stub
    return null;
    } public void update(UsersInfo user) { }
      

  2.   

    就是我这样配有错吗?为什么会报我错
    Exception in thread "main" java.lang.NullPointerException
    at org.springframework.orm.hibernate3.support.HibernateDaoSupport.getSession(HibernateDaoSupport.java:140)
    at db.imp.userDAOImpl.login(userDAOImpl.java:31)
    at db.imp.userDAOImpl.main(userDAOImpl.java:52)
      

  3.   

    Query query=this.getSession().createQuery(hql); 
    获取不到  session