package hibernate;
public class Useinfo {
?? private String username;
?? private String userpass;
public String getUsername() {
?return username;
}
public void setUsername(String username) {
?this.username = username;
}
public String getUserpass() {
?return userpass;
}
public void setUserpass(String userpass) {
?this.userpass = userpass;
}
}
package hibernate;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
?
<hibernate-configuration> <session-factory> ? ?<mapping resource="hibernate.useinfo.hbm.xml" /> </session-factory> </hibernate-configuration> ??? <class name="hibernate.Useinfo" table="useinfo"> </hibernate-mapping> jdbc.driver???? =com.mysql.jdbc.Driver ???? <bean id="dao" class="Dao"> </beans>
public class UseinfoDao extends HibernateDaoSupport {
?
?public void sava(Useinfo u)
?{
??getHibernateTemplate().saveOrUpdate(u);
?}
}
hibernate.cfg.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
??????? "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
??????? "
spring.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "<beans>
?
???? <bean id="sessionFactory"
?????????? class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
?????????? <property name="dataSource" ref="dataSource"/>
?????????? <property name="mappingResources">
???????????? <list>
??????????????? <value>hibernate/useinfo.hbm.xml</value>
???????????? </list>
?????????? </property>
??????????
?????????? <property name="hibernateProperties">
?????????????????? <props>
????????????????????? <prop key="hibernate.dialect">
????????????????????????? org.hibernate.dialect.MySQLMyISAMDialect
????????????????????? </prop>
????????????????????? <prop key="hibernate.show_sql">
??????????????????????????? true
????????????????????? </prop>
?????????????????? </props>
?????????? </property>
????? </bean>
?????
????? <bean id="useinfoDao"
??????????? class="hibernate.UseinfoDao">
??????????
??????????? <property name="sessionFactory" ref="sessionFactory"/>
??????????? </bean>
?????
??? <!--? 連接信息配置 -->
??? <bean
??????? id="PlaceholderConfigurer"
??????? class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
??????? <property
??????????? name="locations"
??????????? value="classpath:jdbc.properties"/>
??? </bean>
??? <bean
??????? id="dataSource"
??????? class="org.apache.commons.dbcp.BasicDataSource"
??????? destroy-method="close">
??????? <property
??????????? name="driverClassName"
??????????? value="${jdbc.driver}" />
??????? <property
??????????? name="username"
??????????? value="${jdbc.user}" />
??????? <property
??????????? name="password"
??????????? value="${jdbc.password}" />
??????? <property
??????????? name="url"
??????????? value="${jdbc.url}" />
??????? <property
??????????? name="initialSize"
??????????? value="${jdbc.initialSize}" />
??????? <property
??????????? name="maxActive"
??????????? value="${jdbc.maxActive}" />
??????? <property
??????????? name="maxIdle"
??????????? value="${jdbc.maxIdle}" />
??????? <property
??????????? name="maxWait"
??????????? value="${jdbc.maxWait}" />
??????? <property
??????????? name="minIdle"
??????????? value="${jdbc.minIdle}" />
??? </bean>
???
??
</beans>
useinfo.hbm.xml
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
??????? "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
??????? "<hibernate-mapping>
?????? <id name="username" column="username"></id>
??????? <property name="userpass"/>
??? </class>
jdbc.url??????? =jdbc:mysql://192.168.100.201/test
jdbc.user?????? =root
jdbc.password?? =
jdbc.initialSize = 5
jdbc.maxActive? = 60
jdbc.maxIdle? = 10
jdbc.maxWait? = 50
jdbc.minIdle? = 5
#hibernate
hibernate.dialect?? ??? ??? ??? ?=?? ?org.hibernate.dialect.MySQLDialect
#hibernate.dialect?? ??? ??? ??? ?=?? ?org.hibernate.dialect.Oracle9Dialect
hibernate.show_sql?? ??? ??? ??? ?=?? ?true
hibernate.format_sql?? ??? ??? ?=?? ?true
hibernate.hbm2ddl.auto?? ??? ??? ?=?? ?create-drop
#hibernate.hbm2ddl.auto?? ??? ??? ?=?? ?update
hibernate.cache.use_query_cache?? ?=?? ?false
hibernate.cache.provider_class?? ?=?? ?org.hibernate.cache.OSCacheProvider
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN"
"<beans>
?????????? <property name="sessionFactory" ref="sessionFactory"/>
???? </bean>
???? <bean
??????? id="sessionFactory"
??????? class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean"
??????? parent="abstractSessionFactory">
??????? <property name="annotatedClasses">
??????????? <list>
??????????????? <value>Account</value>
??????????? </list>
??????? </property>
??? </bean>
???
??? <bean
??????? id="abstractSessionFactory"
??????? class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"
??????? abstract="true">
??????? <property
??????????? name="dataSource"
??????????? ref="dataSource" />
??????? <property name="hibernateProperties">
??????????? <props>
??????????????? <prop key="hibernate.dialect">${hibernate.dialect}</prop>
??????????????? <prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
??????????????? <prop key="hibernate.format_sql">${hibernate.format_sql}</prop>
??????????????? <prop key="hibernate.hbm2ddl.auto">${hibernate.hbm2ddl.auto}</prop>
??????????????? <prop key="hibernate.cache.use_query_cache">${hibernate.cache.use_query_cache}</prop>
??????????????? <prop key="hibernate.cache.provider_class">${hibernate.cache.provider_class}</prop>
??????????? </props>
??????? </property>
???????
??????? <property
??????????? name="lobHandler"
??????????? ref="oracleLobHandler" />
??? </bean>
???
??? <bean
??????? id="defaultLobHandler"
??????? class="org.springframework.jdbc.support.lob.DefaultLobHandler"
??????? lazy-init="true" />
??? <bean
??????? id="oracleLobHandler"
??????? class="org.springframework.jdbc.support.lob.OracleLobHandler"
??????? lazy-init="true">
??????? <property name="nativeJdbcExtractor">
??????????? <bean
??????????????? class="org.springframework.jdbc.support.nativejdbc.CommonsDbcpNativeJdbcExtractor"
??????????????? lazy-init="true" />
??????? </property>
??? </bean>
?
? <bean
??????? id="transactionManager"
??????? class="org.springframework.orm.hibernate3.HibernateTransactionManager">
??????? <property
??????????? name="sessionFactory"
??????????? ref="sessionFactory" />
??? </bean>
??? <!--
???? <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
?????? <property name="dataSource" ref="dataSource"/>
?????? <property name="mappingResources">
???????????????? <list>
??????????????????????? <value>Account.xml</value>
???????????????? </list>
?????? </property>
??????
?????? <property name="hibernateProperties">
?????????????????? <props>
????????????????????? <prop key="hibernate.dialect">
????????????????????????? org.hibernate.dialect.MySQLMyISAMDialect
????????????????????? </prop>
????????????????????? <prop key="hibernate.show_sql">
??????????????????????????? true
????????????????????? </prop>
?????????????????????? <prop key="hibernate.hbm2ddl.auto">
?????????????????????? create-drop
????????????????????? </prop>
?????????????????? </props>
?????????? </property>
???? </bean>
???? -->
<!--? 連接信息配置 -->
??? <bean
??????? id="PlaceholderConfigurer"
??????? class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
??????? <property
??????????? name="locations"
??????????? value="classpath:jdbc.properties"/>
??? </bean>
??? <bean
??????? id="dataSource"
??????? class="org.apache.commons.dbcp.BasicDataSource"
??????? destroy-method="close">
??????? <property
??????????? name="driverClassName"
??????????? value="${jdbc.driver}" />
??????? <property
??????????? name="username"
??????????? value="${jdbc.user}" />
??????? <property
??????????? name="password"
??????????? value="${jdbc.password}" />
??????? <property
??????????? name="url"
??????????? value="${jdbc.url}" />
??????? <property
??????????? name="initialSize"
??????????? value="${jdbc.initialSize}" />
??????? <property
??????????? name="maxActive"
??????????? value="${jdbc.maxActive}" />
??????? <property
??????????? name="maxIdle"
??????????? value="${jdbc.maxIdle}" />
??????? <property
??????????? name="maxWait"
??????????? value="${jdbc.maxWait}" />
??????? <property
??????????? name="minIdle"
??????????? value="${jdbc.minIdle}" />
??? </bean>