일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | |||||
3 | 4 | 5 | 6 | 7 | 8 | 9 |
10 | 11 | 12 | 13 | 14 | 15 | 16 |
17 | 18 | 19 | 20 | 21 | 22 | 23 |
24 | 25 | 26 | 27 | 28 | 29 | 30 |
31 |
- 네트워크
- context
- lsof
- bash
- grep
- xargs
- Eclipse
- Windows 10
- maVen
- Windows
- Mac
- tomcat
- 공통표준용어
- web.xml
- 단축키
- find
- import
- DB 도메인
- Source
- Quartz
- ssh
- resource
- GIT
- netsh
- IntelliJ
- JavaScript
- port
- copy-dependencies
- VirtualBox
- profile
- Today
- Total
목록전체 글 (1613)
develog
Configuring Connection Pooling in Tomcathttp://www.javaexperience.com/connection-pooling-in-tomcat/...
SELECT '201303' THIS_MONTH , DATE_FORMAT(DATE_ADD(STR_TO_DATE('201303', '%Y%m'), INTERVAL -1 MONTH), '%Y%m') PREV_MONTH , DATE_FORMAT(DATE_ADD(STR_TO_DATE('201303', '%Y%m'), INTERVAL 1 MONTH), '%Y%m') NEXT_MONTH ;
-- DATE 컬럼 변형 O SELECT * FROM TABLE_NM WHERE DATE_FORMAT(DATE_COL_NM, '%Y%m%d') = '20130306' ORDER BY DATE_COL_NM ; -- DATE 컬럼 변형 X SELECT * FROM TABLE_NM WHERE 1=1 AND DATE_COL_NM >= STR_TO_DATE('20130306', '%Y%m%d') AND DATE_COL_NM < DATE_ADD(STR_TO_DATE('20130306', '%Y%m%d'), INTERVAL 1 DAY) ORDER BY DATE_COL_NM ;
--OracleSELECT *FROM TABLE_NMWHERE ROWNUM
commons-dbcp-1.4.jar commons-pool-1.6.jar fscontext-4.4.jar ojdbc14.jar import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import javax.naming.Context; import javax.naming.InitialContext; import javax.naming.Reference; import javax.naming.StringRefAddr; import javax.sql.DataSource; public class TestJndi { public static void main(String[] args) { Logger.info..
import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet; import javax.sql.DataSource; import org.apache.commons.dbcp.BasicDataSource; public class TestDbcp { public static void main(String[] args) {Logger.info("START");Logger.info("------------------------------------------------");Connection conn = null;PreparedStatement pstmt = null;ResultSet rs = null;String sql..