2013年11月29日

jdbcTemplate execute example

摘要: package com.material.dao;import java.math.BigDecimal;import java.sql.CallableStatement;import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import java.util.HashMap;import java.util.List;import java.util.Map;import org.springframework.dao.DataA 阅读全文

posted @ 2013-11-29 16:52 TreasureNow 阅读(706) 评论(0) 推荐(0) 编辑

some complex sql to review

摘要: select count(*) from (select b.id id, b.OBJECT_ID, b.POSTING_DATE, b.OPEN_TIME, b.QUOT_DEAD, b.PROCESS_TYPE, b.DESCRIPTION, b.ZORGNAME, b.PSPID, b.POST1, b.ZDJZT, b.NAME_LAST, m.MATNR_ID MATNR, m.CLASS1T, m.MAKTX, m.TEXT, m.QUANTITY from bid b left join material m on b.id = m.b_id) cselect * from .. 阅读全文

posted @ 2013-11-29 16:47 TreasureNow 阅读(194) 评论(0) 推荐(0) 编辑

translate old poem

摘要: 不知吾道无言无行,而即有言有行者求道,忽遇异物,横执为道,殊不知舍源求流,无时得源,舍本就末,无时得本。 ——《文始真經》 Ordinary people are not able to make sense of dao. Dao cant not be explained by word nor expressed by deeds. However, if you insist on seeking like that, then one day you happlily found something, and considered it must be dao. Hardly ... 阅读全文

posted @ 2013-11-29 16:41 TreasureNow 阅读(178) 评论(0) 推荐(0) 编辑

java run at specific time

摘要: Timer timer = new Timer(); Calendar date = Calendar.getInstance(); date.set(Calendar.HOUR, 0); date.set(Calendar.MINUTE, 0); date.set(Calendar.SECOND, 0); date.set(Calendar.MILLISECOND, 0); TimerTask task = new... 阅读全文

posted @ 2013-11-29 16:32 TreasureNow 阅读(246) 评论(0) 推荐(0) 编辑

导航