81,090
社区成员
发帖
与我相关
我的任务
分享
2011-03-28 09:09:44 [日志信息] Write Para1:null
2011-03-28 09:09:44 [日志信息] Write Para1:/user.do
2011-03-28 09:09:44 [日志信息] Write Para1:method=getList
2011-03-28 09:09:44 [日志信息] Write Para1:/doUser.do
Hibernate: select count(*) as col_0_0_ from kejia.dbo.td_user tduser0_
Hibernate: select top 18 tduser0_.id as id0_, tduser0_.userName as userName0_, tduser0_.password as password0_, tduser0_.name as name0_, tduser0_.role as role0_, tduser0_.addDate as addDate0_ from kejia.dbo.td_user tduser0_
Hibernate: update kejia.dbo.td_user set userName=?, password=?, name=?, role=?, addDate=? where id=?
Hibernate: update kejia.dbo.td_user set userName=?, password=?, name=?, role=?, addDate=? where id=?
Hibernate: update kejia.dbo.td_user set userName=?, password=?, name=?, role=?, addDate=? where id=?
Hibernate: update kejia.dbo.td_user set userName=?, password=?, name=?, role=?, addDate=? where id=?
Hibernate: update kejia.dbo.td_user set userName=?, password=?, name=?, role=?, addDate=? where id=?
Hibernate: update kejia.dbo.td_user set userName=?, password=?, name=?, role=?, addDate=? where id=?
Hibernate: update kejia.dbo.td_user set userName=?, password=?, name=?, role=?, addDate=? where id=?
Hibernate: update kejia.dbo.td_user set userName=?, password=?, name=?, role=?, addDate=? where id=?
Hibernate: update kejia.dbo.td_user set userName=?, password=?, name=?, role=?, addDate=? where id=?
Hibernate: update kejia.dbo.td_user set userName=?, password=?, name=?, role=?, addDate=? where id=?
Hibernate: update kejia.dbo.td_user set userName=?, password=?, name=?, role=?, addDate=? where id=?
Hibernate: update kejia.dbo.td_user set userName=?, password=?, name=?, role=?, addDate=? where id=?
Hibernate: update kejia.dbo.td_user set userName=?, password=?, name=?, role=?, addDate=? where id=?
Hibernate: update kejia.dbo.td_user set userName=?, password=?, name=?, role=?, addDate=? where id=?
Hibernate: update kejia.dbo.td_user set userName=?, password=?, name=?, role=?, addDate=? where id=?
Hibernate: update kejia.dbo.td_user set userName=?, password=?, name=?, role=?, addDate=? where id=?
Hibernate: update kejia.dbo.td_user set userName=?, password=?, name=?, role=?, addDate=? where id=?
Hibernate: update kejia.dbo.td_user set userName=?, password=?, name=?, role=?, addDate=? where id=?
{"total":19,"data":[{"id":19,"name":"asfdasfd","role":0,"userName":"admin","addDate":{"time":1301274584796,"minutes":9,"seconds":44,"hours":9,"month":2,"timezoneOffset":-480,"year":111,"day":1,"date":28},"password":"admin"},{"id":20,"name":"dfasdf","role":0,"userName":"asdf222","addDate":{"time":1301274584796,"minutes":9,"seconds":44,"hours":9,"month":2,"timezoneOffset":-480,"year":111,"day":1,"date":28},"password":"as"},{"id":21,"name":"sdfasdf","role":0,"userName":"asdf","addDate":{"time":1301274584796,"minutes":9,"seconds":44,"hours":9,"month":2,"timezoneOffset":-480,"year":111,"day":1,"date":28},"password":"asfa"},{"id":22,"name":"3333","role":0,"userName":"dddd","addDate":{"time":1301274584796,"minutes":9,"seconds":44,"hours":9,"month":2,"timezoneOffset":-480,"year":111,"day":1,"date":28},"password":"dddd"},{"id":23,"name":"3333","role":0,"userName":"3333","addDate":{"time":1301274584796,"minutes":9,"seconds":44,"hours":9,"month":2,"timezoneOffset":-480,"year":111,"day":1,"date":28},"password":"333"},{"id":24,"name":"2323","role":0,"userName":"232","addDate":{"time":1301274584796,"minutes":9,"seconds":44,"hours":9,"month":2,"timezoneOffset":-480,"year":111,"day":1,"date":28},"password":"323"},{"id":25,"name":"23424","role":0,"userName":"234234","addDate":{"time":1301274584796,"minutes":9,"seconds":44,"hours":9,"month":2,"timezoneOffset":-480,"year":111,"day":1,"date":28},"password":"234"},{"id":26,"name":"234234","role":0,"userName":"234234","addDate":{"time":1301274584796,"minutes":9,"seconds":44,"hours":9,"month":2,"timezoneOffset":-480,"year":111,"day":1,"date":28},"password":"234"},{"id":28,"name":"4234234","role":0,"userName":"2342","addDate":{"time":1301274584796,"minutes":9,"seconds":44,"hours":9,"month":2,"timezoneOffset":-480,"year":111,"day":1,"date":28},"password":"34234"},{"id":29,"name":"2323","role":0,"userName":"22","addDate":{"time":1301274584796,"minutes":9,"seconds":44,"hours":9,"month":2,"timezoneOffset":-480,"year":111,"day":1,"date":28},"password":"323"},{"id":30,"name":"33","role":0,"userName":"333","addDate":{"time":1301274584796,"minutes":9,"seconds":44,"hours":9,"month":2,"timezoneOffset":-480,"year":111,"day":1,"date":28},"password":"33"},{"id":33,"name":"孙超","role":0,"userName":"sunchao","addDate":{"time":1301274584796,"minutes":9,"seconds":44,"hours":9,"month":2,"timezoneOffset":-480,"year":111,"day":1,"date":28},"password":"shuxhao"},{"id":34,"name":"23","role":0,"userName":"23","addDate":{"time":1301274584796,"minutes":9,"seconds":44,"hours":9,"month":2,"timezoneOffset":-480,"year":111,"day":1,"date":28},"password":"23"},{"id":37,"name":"bbbbb","role":0,"userName":"aaaaaaaaa","addDate":{"time":1301274584796,"minutes":9,"seconds":44,"hours":9,"month":2,"timezoneOffset":-480,"year":111,"day":1,"date":28},"password":"bbbb"},{"id":38,"name":"cccccccc","role":0,"userName":"aaaaaaa","addDate":{"time":1301274584796,"minutes":9,"seconds":44,"hours":9,"month":2,"timezoneOffset":-480,"year":111,"day":1,"date":28},"password":"bbbbbbbbbb"},{"id":39,"name":"haha","role":0,"userName":"hello","addDate":{"time":1301274584796,"minutes":9,"seconds":44,"hours":9,"month":2,"timezoneOffset":-480,"year":111,"day":1,"date":28},"password":"mima"},{"id":40,"name":"3333","role":0,"userName":"33333","addDate":{"time":1301274584796,"minutes":9,"seconds":44,"hours":9,"month":2,"timezoneOffset":-480,"year":111,"day":1,"date":28},"password":"3333"},{"id":41,"name":"ddddd","role":0,"userName":"ddddd","addDate":{"time":1301274584796,"minutes":9,"seconds":44,"hours":9,"month":2,"timezoneOffset":-480,"year":111,"day":1,"date":28},"password":"ddd"}],"success":true}
public void setAddDate(Date addDate) {
Date date = new Date();
this.addDate = date;
}
<!-- 配置事务管理器 -->
<bean id="transactionManager"
class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory">
<ref local="sessionFactory" />
</property>
</bean>
<aop:config>
<aop:pointcut id="daoMethods"
expression="execution(* net.hlj.kj.dao.*.*(..))" />
<!-- 定义了将采用何种拦截操作,这里引用到 txAdvice -->
<aop:advisor advice-ref="txAdvice" pointcut-ref="daoMethods" />
</aop:config>
<!-- 配置事务特性 -->
<tx:advice id="txAdvice" transaction-manager="transactionManager">
<tx:attributes>
<tx:method name="*" propagation="REQUIRED" />
</tx:attributes>
</tx:advice>
<tx:annotation-driven transaction-manager="transactionManager"
proxy-target-class="true" />
<?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/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd">
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="configLocation"
value="classpath:hibernate.cfg.xml">
</property>
</bean>
<!-- 配置事务管理器 -->
<bean id="transactionManager"
class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory">
<ref local="sessionFactory" />
</property>
</bean>
<aop:config>
<aop:pointcut id="daoMethods"
expression="execution(* net.hlj.kj.dao.*.*(..))" />
<!-- 定义了将采用何种拦截操作,这里引用到 txAdvice -->
<aop:advisor advice-ref="txAdvice" pointcut-ref="daoMethods" />
</aop:config>
<!-- 配置事务特性 -->
<tx:advice id="txAdvice" transaction-manager="transactionManager">
<tx:attributes>
<tx:method name="*" propagation="REQUIRED" />
</tx:attributes>
</tx:advice>
<tx:annotation-driven transaction-manager="transactionManager"
proxy-target-class="true" />
<!--用户管理 -->
<bean id="userDao" class="net.hlj.kj.dao.UserDao">
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>
<bean id="userService" class="net.hlj.kj.service.UserServiceImpl">
<property name="userDao">
<ref bean="userDao" />
</property>
</bean>
</beans>
<hibernate-mapping>
<class name="net.hlj.kj.mpppings.TdUser" table="td_user" schema="dbo" catalog="kejia">
<id name="id" type="java.lang.Integer">
<column name="id" />
<generator class="native"></generator>
</id>
<property name="userName" type="java.lang.String">
<column name="userName" length="50" />
</property>
<property name="password" type="java.lang.String">
<column name="password" length="50" />
</property>
<property name="name" type="java.lang.String">
<column name="name" length="50" />
</property>
<property name="role" type="java.lang.Integer">
<column name="role" />
</property>
<property name="addDate" type="java.util.Date">
<column name="addDate" length="23" />
</property>
</class>
</hibernate-mapping>
impl:
public PagerModel getList() {
PagerModel pm=userDao.getList();
return pm;
}
dao
public PagerModel getList() {
PagerModel pm=searchPaginated("from TdUser");
return pm;
}