- 博客(5)
- 收藏
- 关注
原创 spring配置文件
<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context" xml
2015-09-30 17:42:19 201
原创 MySQL——存储过程
BEGIN DECLARE detail_id int default 0; DECLARE log_d_score int default 0; DECLARE detail_count int default 0; declare sign int default 0; DECLARE done INT DEFAULT 0; declare cur1 cursor for
2015-09-27 15:01:39 292
原创 date_format()的使用
String sql = " select * from tjyx.member a where a.DELETED = 0 and DATE_FORMAT(a.BIRTH_DATE, '%m%d')>=DATE_FORMAT('"; sql = sql + start + "', '%m%d') and DATE_FORMAT(a.BIRTH_DATE,'%m%d')<= DATE_FORMA
2015-09-24 16:03:31 1133
原创 hibernate查询和jdbc查询
package com.weinet.cardfolder.dao; import java.util.ArrayList; import java.util.List; import javax.persistence.EntityManager; import javax.persistence.PersistenceContext; import javax.persistence.Qu
2015-09-15 13:48:07 389
原创 SQL杂集
select t3.TX_DATE, t3.pay_type ,t4.DISCOUNT_TYPE ,t3.CARD_TYPE_ID,sum(money_consume) amount from( SELECT t1.* ,t2.CARD_TYPE_ID FROM tjyx.TRANSACTION t1 LEFT JOIN tjyx.member_card t2 ON t2.
2015-09-11 16:03:24 323
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人