Jsg +spring +hibernate config生成出问题

Question

applicationContext。xml<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
<bean id="SessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.cglib.use_reflection_optimizer">true</prop>
<prop key="hibernate.proxool.xml">proxool.xml</prop>
<prop key="hibernate.proxool.pool_alias">erp</prop>
</props>
</property>
<property name="mappingResources">
<list>
<value>com/mysystem/hibernate/Users.hbm.xml</value>
<value>com/mysystem/hibernate/Area.hbm.xml</value>
<value>com/mysystem/hibernate/City.hbm.xml</value>
<value>com/mysystem/hibernate/Hosiptal.hbm.xml</value>
<value>com/mysystem/hibernate/ChildrenMessage.hbm.xml</value>
<value>com/mysystem/hibernate/Province.hbm.xml</value>
<value>com/mysystem/hibernate/CheckResult.hbm.xml</value>
<value>com/mysystem/hibernate/Disease.hbm.xml</value>
<value>com/mysystem/hibernate/CureMessage.hbm.xml</value>
</list>
</property>
</bean>
<bean id="UsersDAO" class="com.mysystem.hibernate.dao.UsersDAO">
<property name="sessionFactory">
<ref bean="SessionFactory" />
</property>
</bean>
<bean id="ProvinceDAO" class="com.mysystem.hibernate.dao.ProvinceDAO">
<property name="sessionFactory">
<ref bean="SessionFactory" />
</property>
</bean>
<bean id="CityDAO" class="com.mysystem.hibernate.dao.CityDAO">
<property name="sessionFactory">
<ref bean="SessionFactory" />
</property>
</bean>
<bean id="AreaDAO" class="com.mysystem.hibernate.dao.AreaDAO">
<property name="sessionFactory">
<ref bean="SessionFactory" />
</property>
</bean>
<bean id="HosiptalDAO" class="com.mysystem.hibernate.dao.HosiptalDAO">
<property name="sessionFactory">
<ref bean="SessionFactory" />
</property>
</bean>
<bean id="ChildrenMessageDAO" class="com.mysystem.hibernate.dao.ChildrenMessageDAO">
<property name="sessionFactory">
<ref bean="SessionFactory" />
</property>
</bean>
<bean id="DiseaseDAO" class="com.mysystem.hibernate.dao.DiseaseDAO">
<property name="sessionFactory">
<ref bean="SessionFactory" />
</property>
</bean>
<bean id="CheckResultDAO" class="com.mysystem.hibernate.dao.CheckResultDAO">
<property name="sessionFactory">
<ref bean="SessionFactory" />
</property>
</bean>
<bean id="CureMessageDAO" class="com.mysystem.hibernate.dao.CureMessageDAO">
<property name="sessionFactory">
<ref bean="SessionFactory" />
</property>
</bean>
</beans>

Answer 1

face-config。xml<?xml version="1.0" encoding="UTF-8"?>
<faces-config version="1.2" xmlns="http://java.sun.com/xml/ns/javaee"
 xmlns:xi="http://www.w3.org/2001/XInclude"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-facesconfig_1_2.xsd">
 <managed-bean>
  <managed-bean-name>LoginBean</managed-bean-name>
  <managed-bean-class>com.mysystem.bean.LoginBean</managed-bean-class>
  <managed-bean-scope>session</managed-bean-scope>
  <managed-property>
   <property-name>userName</property-name>
   <property-class>java.lang.String</property-class>
   <value/>
  </managed-property>
  <managed-property>
   <property-name>password</property-name>
   <property-class>java.lang.String</property-class>
   <value/>
  </managed-property>
  <managed-property>
   <property-name>validateCode</property-name>
   <property-class>java.lang.String</property-class>
   <value/>
  </managed-property>
 </managed-bean>
 <navigation-rule>
  <from-view-id>/login/MyJsp.jsp</from-view-id>
 </navigation-rule>
 <application>
  <variable-resolver>org.springframework.web.jsf.DelegatingVariableResolver</variable-resolver>
  <locale-config>
   <default-locale>zh_CN</default-locale>
   <supported-locale>en</supported-locale>
   <supported-locale>es</supported-locale>
  </locale-config>
 </application>
 
</faces-config>proxool。xml<?xml version="1.0" encoding="UTF-8"?>  
<!-- the proxool configuration can be embedded within your own application's.   
    Anything outside the "proxool" tag is ignored. -->  
  
<proxool>  
    <alias>erp</alias>  
    <driver-url>jdbc:mysql://localhost:3306/childrenill</driver-url>       
    <driver-class>com.mysql.jdbc.Driver</driver-class>  
    <driver-properties>  
        <property name="user" value="root" />  
        <property name="password" value="root" />  
    </driver-properties>  
    <minimum-connection-count>2</minimum-connection-count>  
    <maximum-connection-count>20</maximum-connection-count>  
    <maximum-connection-lifetime>180000</maximum-connection-lifetime> <!-- 5 hours -->  
    <house-keeping-test-sql>values(current TimeStamp)</house-keeping-test-sql>  
    <statistics>1m,15m,1d</statistics>  
    <statistics-log-level>INFO</statistics-log-level>  
    <fatal-sql-exception>Connection is closed,SQLSTATE=08003,Error opening socket. SQLSTATE=08S01,SQLSTATE=08S01</fatal-sql-exception>  
    <fatal-sql-exception-wrapper-class>org.logicalcobwebs.proxool.FatalRuntimeException</fatal-sql-exception-wrapper-class>  
    <verbose>false</verbose>  
</proxool>  

Answer 2

web。xml<?xml version="1.0" encoding="UTF-8"?>  
<web-app xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="2.5" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee   http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">    
     
  <context-param>  
    <param-name>contextConfigLocaition</param-name>  
    <param-value>/WEB-INF/applicationContext.xml</param-value>  
  </context-param>  
  <listener>  
    <listener-class>  
      org.springframework.web.context.ContextLoaderListener   
    </listener-class>  
  </listener>  
  <context-param>  
    <param-name>javax.faces.CONFIG_FILES</param-name>  
    <param-value>/WEB-INF/faces-config.xml</param-value>  
  </context-param>  
  <servlet>  
    <servlet-name>Faces Servlet</servlet-name>  
    <servlet-class>javax.faces.webapp.FacesServlet</servlet-class>  
    <load-on-startup>0</load-on-startup>  
  </servlet>  
  <servlet-mapping>  
    <servlet-name>Faces Servlet</servlet-name>  
    <url-pattern>*.faces</url-pattern>  
  </servlet-mapping>  
  <welcome-file-list>  
    <welcome-file>index.faces</welcome-file>  
  </welcome-file-list>  
</web-app>  页面的调用
LoginBean。java/**
 * 
 */
package com.mysystem.bean;import java.util.List;import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.FileSystemXmlApplicationContext;import com.mysystem.hibernate.HibernateSessionFactory;
import com.mysystem.hibernate.Users;
import com.mysystem.hibernate.dao.UsersDAO;/**
 * @author Administrator
 * 
 */
public class LoginBean {
private java.lang.String userName;
private java.lang.String password;
private java.lang.String validateCode;

// ApplicationContext ac = new FileSystemXmlApplicationContext("E:/workSoft/apache-tomcat-//6.0.18/webapps/childill/WEB-INF/classes/applicationContext.xml");
public LoginBean() {
} @SuppressWarnings("unchecked")
public String login() throws Exception {
try {
Session session = HibernateSessionFactory.getSessionFactory().getCurrentSession();
String hql=" from Users user where userName=? and password=?";
Query query =session.createQuery(hql);//出错的地方，执行到//HIbernateSessionFactory了
query.setString(0, getUserName());
query.setString(1,getPassword());
List list =query.list();
if (list != null)
return "sucess";
else
return "failture";
} catch (Exception e) {
throw e;
}
} public java.lang.String getUserName() {
return userName;
} public void setUserName(java.lang.String userName) {
this.userName = userName;
} public java.lang.String getPassword() {
return password;
} public void setPassword(java.lang.String password) {
this.password = password;
} public java.lang.String getValidateCode() {
return validateCode;
} public void setValidateCode(java.lang.String validateCode) {
this.validateCode = validateCode;
}
}