프로젝트 내 src 내 javabasic 패키지 내 PreparedStatementEx1.java package javabasic; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; public class PreparedStatementEx1 { public static void main(String[] args) throws Exception { // TODO Auto-generated method stub Class.forName("oracle.jdbc.driver.OracleDriver"); String url = "jdbc:oracl..

프로젝트 내 src 내 javabasic 패키지 내 OracleClob.java package javabasic; import java.io.CharArrayReader; import java.io.IOException; import java.io.Reader; import java.io.Writer; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import oracle.jdbc.OracleResultSet; import oracle.sql.CLOB; public class Orac..

프로젝트 내 src 내 javabasic 패키지 내 ObjectSerTest.java //PS C:\Users\ydbon> sqlplus // //SQL*Plus: Release 11.2.0.1.0 Production on 수 3월 9 09:44:19 2022 // //Copyright (c) 1982, 2010, Oracle. All rights reserved. // //사용자명 입력: scott/a1234 // //다음에 접속됨: //Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production //With the Partitioning, OLAP, Data Mining and Real Application Testing o..

프로젝트 내 src 내 javabasic 패키지 내 NonBatch.java package javabasic; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException; public class NonBatch { public static void main(String[] args) { // TODO Auto-generated method stub Connection conn = null; PreparedStatement pst = null; try { Class.forName("oracle.jdbc.driver.OracleDriver"); co..

프로젝트 내 src 내 javabaisc 패키지 내 MetaDataEx.java package javabasic; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.Statement; public class MetaDataEx { public static void main(String[] args) throws Exception { // TODO Auto-generated method stub //드라이버등록 Class.forName("oracle.jdbc.driver.OracleDriver"); String u..

프로젝트 내 src 내 javabasic 패키지 내 ScoreDTO.java package javabasic; public class ScoreDTO { // 멤버 선언 private int kor, eng, math, total; private float avg; private String name; public String getName() { return name; } public void setName(String name) { this.name = name; } public int getKor() { return kor; } public void setKor(int kor) { this.kor = kor; } public int getEng() { return eng; } public void ..