Notice
Recent Posts
Recent Comments
Link
«   2024/04   »
일 월 화 수 목 금 토
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
Tags more
Archives
Today
Total
관리 메뉴

목록01.About Programming /10.JAVA (2)

kisoo

자바에서 MSSQL CALL PROCEDURE 방법

먼저 CallableStatement 클래스를 사용하여 저장프로시져 호출 방법 ResultSet rs = null;CallableStatement cs = null; cs = conn.prepareCall("{call dbo.comempsearch(?)}"); cs.setString(1,"S"); rs = cs.executeQuery(); PreparedStatement 클래스를 사용하는 방법PreparedStatement pstmt = null;ResultSet rs = null; String sqlQuery = "exec jaorderprc @pWORKGB ='S', @pUSERID ='"+userID+"', @pFIRSTDATE ='"+firstDate+"'"; sqlQuery += ", @pLAS..
01.About Programming /10.JAVA 2013. 4. 3. 14:01
java 개봘환경 설치파일

JDK 1.6.27 - http://www.oracle.com/technetwork/java/javase/downloads/jdk-6u27-download-440405.html 이클립스 (3.5.2) - http://www.eclipse.org/downloads/download.php?file=/technology/epp/downloads/release/galileo/SR2/eclipse-jee-galileo-SR2-win32.zip Tomcat 6.0 - http://mirror.apache-kr.org/tomcat/tomcat-6/v6.0.33/bin/apache-tomcat-6.0.33.exe HeidiSQL - http://heidisql.googlecode.com/files/HeidiSQL_6...
01.About Programming /10.JAVA 2011. 9. 29. 14:52
Prev 1 Next