Programming/Java (5) 썸네일형 리스트형 [Java] Oracle JDBC releases Vs JDK versions 참고: https://www.oracle.com/database/technologies/faq-jdbc.html Oracle JDBC Frequently Asked Questions For byte data, there are three Oracle SQL types: VARCHAR2, LONG and CLOB. VARCHAR2 data is of limited length, is stored directly in a column, and is transmitted to the server in inline packets. LONG data has a much larger limit (2 Gigibytes), is stored via www.oracle.com [Java] 키 입력(Scanner) import java.util.Scanner; Scanner sc = new Scanner(System.in); int n = sc.nextInt(); sc.close(); 참고: https://docs.oracle.com/javase/8/docs/api/java/util/Scanner.html Scanner (Java Platform SE 8 ) Scans the next token of the input as a float. This method will throw InputMismatchException if the next token cannot be translated into a valid float value as described below. If the translation is succ.. [Java] JDBC Test (ORACLE DB, tnsnames.ora) // Instant Client 설치 및 TNS_ADMIN 환경변수 세팅 후 tnsnames.ora의 TNS_IDENTIFIER 참고하여 Oracle DB에 접근하는 예제 import java.sql.*; public class JDBCTest { public static void main(String[] args) throws Exception { System.setProperty("oracle.net.tns_admin", System.getenv("TNS_ADMIN")); String dbURL = "jdbc:oracle:thin:@MYDB"; Class.forName ("oracle.jdbc.OracleDriver"); Connection conn = null; Statement stmt = nul.. [Java] 시스템 환경변수 관련(getenv) public static String getenv(String name) 예) String sysPath = System.getenv("PATH"); 참고: https://docs.oracle.com/javase/8/docs/api/java/lang/System.html#getenv-java.lang.String- System (Java Platform SE 8 ) Sets the system property indicated by the specified key. First, if a security manager exists, its SecurityManager.checkPermission method is called with a PropertyPermission(key, "write") permi.. [Java] 환경변수 참고 JAVA_HOME = jdk 설치경로 (예. C:\jdk버전) CLASSPATH = .;%JAVA_HOME%\lib\tools.jar;%JAVA_HOME%\jre\lib\ext PATH = %PATH%;%JAVA_HOME%\bin 운영체제 환경에 맞게 변형해서 설정할 것 RedHat OpenJDK Download: https://developers.redhat.com/products/openjdk/download OpenJDK Download Container Images Download secure, certified, and up-to-date container images for OpenJDK. developers.redhat.com AdoptOpenJDK: https://adoptopenjdk.n.. 이전 1 다음