非主键数据验证数据的唯一性
一般是通过Ajax的方式来从后台获取是否唯一
后台再通过去数据库查找,数据库语句为
select count(*) from TableName where number =?
JS下将中国标准时间转化为指定格式时间
在我们使用日期的时候经常会遇到 这种情况,下面是我搜索到的一个工具方法
var format = function(time, format){
var t = new Date(time);
var tf = function(i){return (i < 10 ? '0' : '') + i};
return format.replace(/yyyy|MM|dd|HH|mm|ss/g, function(a){
switch(a){
case 'yyyy':
return tf(t.getFullYear());
break;
case 'MM':
return tf(t.getMonth() + 1);
break;
case 'mm':
return tf(t.getMinutes());
break;
case 'dd':
return tf(t.getDate());
break;
case 'HH':
return tf(t.getHours());
break;
case 'ss':
return tf(t.getSeconds());
break;
}
})
}
//使用该方法
alert(format("Thu Aug 22 2013 15:12:00 GMT+0800", 'yyyy-MM-dd HH:mm:ss'));
CreateSQLQuery将结果转换为Map
public List<Map<String, Object>> getTypeMoney()
{
//payrecordsDao.find
SQLQuery query =payrecordsDao.getSession().createSQLQuery("select t.typename,sum(p.payment) as sumpay from Payrecords p INNER JOIN paytype t where t.typeid =p.typeid group by t.typeid");
query.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);
return query.list();
//return payrecordsDao.getSession().createQuery("select typeid,sum(payment) as sumpay from Payrecords group by typeid").list();
//return (List<Record>)payrecordsDao.getSession().createSQLQuery("select typeid,sum(payment) as sumpay from Payrecords group by typeid").addEntity(Record.class).list();
//payrecordsDao.getSession();
//payrecordsDao.find(page,"select typeid,sum(payment) as sumpay from Payrecords group by typeid");
//return (List<Object>) payrecordsDao.createQuery("select typeid,sum(payment) as sumpay from Payrecords group by typeid");
}
sessionfactory or HibernateTemplete not found
Hibernate在使用全注解配置实体类的时候,要用
org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean来声明生成sessionfactory。
在使用hbm.xml时,使用
org.springframework.orm.hibernate3.LocalSessionFactoryBean来声明生成。