Connection 8 22 UniSQLConnection / / 9 3 UniSQL OID SET

Size: px
Start display at page:

Download "Connection 8 22 UniSQLConnection / / 9 3 UniSQL OID SET"

Transcription

1

2 Connection 8 22 UniSQLConnection / / 9 3 UniSQL OID SET GLO GLO GLO 27 1

3 1 JDBC UniSQL DBMS( UniSQL) JDBC API UniSQL JDBC UniSQL UniSQL 11 UniSQL JDBC 111 JDBC 10 UniSQL/X Realese 41 UniCAS 41 JDK JDBC 20 UniSQL/X Realese 43 UniCAS 42 JDK UniSQL JDBC UniCAS CLASSPATH UniCAS UniSQL Pooling UniSQL JDBC UniCAS 121 UniCAS UniCAS Easy-Manager Terminal 1211 Easy-Manager UniCAS JDBC UniCAS 1 CAS Type ON, 2 CAS Type 2

4 Application Server Easy-Manager CAS Type 1 EasyManager 2 EasyManager Application Server Broker Level Broker Add 1 ~ 3 3 3

5 1 4 Broker Add Step1 Broker Name : Broker AS Type : CAS APPL_ROOT : CAS AS Minimum : AS Maximum : Broker Port : JDBC Connection Description : 4

6 2 5 Broker Add Step2 Advanced option : 1 Description : 3 6 Broker Add Step3 Report : 5

7 1211 Terminal UniCAS UniCAS monitor ( 7 ) JDBC CAS type broker, CAS broker Application Server Terninal CAS type 7 broker and current job information CAS $UNICAS/conf/unicasconf broker ( 8 ) broker SERVICE ON, Application Server 1 MIN_NUM_APPL_SERVER 1 6

8 8 specify the parameters of unicasconf file UniCAS Installation Guide 5~ CLASSPATH CLASSPATH UniSQL JDBC ( UniCAS Installation Guide 17~18 ) Ex) csh - setenv CLASSPATH ${CLASSPATH:${HOME/jdbc/unisqljdbc202jar 7

9 2 UniSQL SQL UniSQL RDBMS JDBC UniSQL Connection 21 Connection Connection Connection DriverManagergetConnection( jdbc : unisql : IP : PORT :::, ID, PASSWORD ); IP : IP PORT : UniCAS Type ID : DBA PUBLIC 2 ID PUBLIC PASSWORD : PASSWORD 22 UniSQLConnection UniSQL JDBC Connection UniSQLConnection GLO getnewinstance API UniSQLConnection UniSQLConnection (UniSQLConnection)DriverManagergetConnection( jdbc:unisql:ip : PORT :::, ID, PASSWORD ); 23 RDBMS import javasql*; public class selectdata { public static void main(string[] args) throws Exception { 8

10 Connection null; Statement stmt = null; ResultSet rs = null; // UniSQL DB Connect ClassforName("unisqljdbcdriverUniSQLDriver"); // 1 DriverManagergetConnection("jdbc:unisql: :43300:demodb:::","",""); // 2 String sql = "select name, country, cost, checkout_time, number_of_restaurants from hotel"; stmt = conncreatestatement(); rs = stmtexecutequery(sql); while(rsnext()) { String name = rsgetstring("name"); String country = rsgetstring("country"); String cost = rsgetstring("cost"); String checkout_time = rsgetstring("checkout_time"); String number_of_restaurants = rsgetstring("number_of_restaurants"); Systemoutprintln("name ==> " + name); Systemoutprintln("country ==> " + country); Systemoutprintln("cost ==> " + cost); Systemoutprintln("checkout_time ==> " + checkout_time); Systemoutprintln("number_of_restaurants ==> " + number_of_restaurants); Systemoutprintln("\n=========================================\n"); rsclose(); stmtclose(); connclose(); catch ( SQLException e ) { Systemerrprintln(egetMessage()); catch ( Exception e ) { Systemerrprintln(egetMessage()); finally { if ( conn!= null ) connclose(); 1 : UniSQL JDBC 2 : Connection sample ID PUBLIC user Connection user 2 : Connection / /,, RDBMS 9

11 import javasql*; public class insertdata { public static void main(string[] args) throws Exception { Connection null; Statement stmt = null; // UniSQL DB Connect ClassforName("unisqljdbcdriverUniSQLDriver"); DriverManagergetConnection("jdbc:unisql: :43300:demodb:::","",""); // connection autocommit (default autocommit ) connsetautocommit(false); // 1 String sql = "insert into test_class(cur_date) values (SYS_DATE)"; stmt = conncreatestatement(); stmtexecuteupdate(sql); Systemoutprintln(" "); stmtclose(); conncommit(); catch ( SQLException e ) { Systemerrprintln(egetMessage()); catch ( Exception e ) { Systemerrprintln(egetMessage()); finally { if ( conn!= null ) connclose(); 1 : true autocommit false (3212 ) 10

12 3 UniSQL 31 OID JDBC OID OID, OID DB user_info class car attribute car class, composition CREATE CLASS car ( name char(40), spec string, color char(20) ) CREATE CLASS user_info ( name char(20), addr string, car car ) 311 OID Connection OID string UniSQLOID 3111 OID attribute OID user_info car OID OID name, spec, color import javasql*; import unisqlsql*; // 1 public class selectoid2 { public static void main(string[] args) throws Exception { Connection null; Statement stmt = null; ResultSet rs = null; ResultSet urs = null; // UniSQL DB Connect ClassforName("unisqljdbcdriverUniSQLDriver"); DriverManagergetConnection("jdbc:unisql: :43300:demodb:::","",""); 11

13 connsetautocommit(false); // 2 // car attribute select // OID String sql = "select name, addr, car from user_info"; stmt = conncreatestatement(); rs = stmtexecutequery(sql); // OID attribute array String [] attr = {"name", "spec", "color"; // 3 while(rsnext()) { String user_name = rsgetstring("name"); String user_addr = rsgetstring("addr"); // select OID UniSQLOID UniSQLOID user_car = (UniSQLOID)rsgetObject("car"); // 4 // OID attribute // array, ResultSet urs = user_cargetvalues(attr); // 5 ursnext(); String car_name = ursgetstring("name"); String car_spec = ursgetstring("spec"); String car_color = ursgetstring("color"); Systemoutprintln(" : " + user_name); Systemoutprintln(" : " + user_addr); Systemoutprintln(" : " + car_name); Systemoutprintln(" : " + car_spec); Systemoutprintln(" : " + car_color); Systemoutprintln("\n==================================================\n"); ursclose(); rsclose(); stmtclose(); conncommit(); catch ( SQLException e ) { Systemerrprintln(egetMessage()); catch ( Exception e ) { Systemerrprintln(egetMessage()); finally { if ( conn!= null ) connclose(); user user 1 : OID unisqlsql* import 12

14 2 : ResultSet close() ResultSet ResultSet autocommit close() ResultSet autocommit false 3 : attr OID attribute array 4 : user_info class, user OID OID UniSQLOID getobject 5 : getobject OID API getvalues ResultSet getvalues(attr) : attr String array attribute attribute null attribute (ex getvalues(null) 3212 ) 3112 String OID String, OID String String OID UniSQLOID import javasql*; import unisqlsql*; import unisqljdbcdriver*; // 1 public class selectoid3 { public static void main(string[] args) throws Exception { UniSQLConnection null; ResultSet urs = null; // OID String String Car_OID_S = "@ "; // 2 ClassforName("unisqljdbcdriverUniSQLDriver"); (UniSQLConnection)DriverManagergetConnection("jdbc:unisql: :43300:demodb:::","", ""); // 3 // OID string UniSQLOID UniSQLOID Car_OID = UniSQLOIDgetNewInstance(conn, Car_OID_S); String [] attr = {"name", "spec", "color"; // 4 // OID ResultSet urs = Car_OIDgetValues(attr); ursnext(); String name = ursgetstring("name"); 13

15 String spec = ursgetstring("spec"); String color = ursgetstring("color"); Systemoutprintln("car_name ==> " + name); Systemoutprintln("car_spec ==> " + spec); Systemoutprintln("car_color ==> " + color); Systemoutprintln("\n=========================================\n"); ursclose(); catch ( SQLException e ) { Systemerrprintln(egetMessage()); catch ( Exception e ) { Systemerrprintln(egetMessage()); finally { if ( conn!= null ) connclose(); (servlet, JSP ) OID hidden OID string UniSQLOID 2 : OID string OID Car_OID_S ( ) 4 : string OID UniSQLOID getnewinstance 3 : getnewinstance connection, connection UniSQLConnection 1 : UniSQLConnection unisqljdbcdriver* import 312 OID OID OID OID 3121 OID car, OID user_info user import javasql*; import unisqlsql*; import unisqljdbcdriver*; // 1 public class insertoid { 14

16 public static void main(string[] args) throws Exception { Connection null; UniSQLStatement ustmt = null; UniSQLPreparedStatement upstmt = null; // UniSQL DB Connect ClassforName("unisqljdbcdriverUniSQLDriver"); DriverManagergetConnection("jdbc:unisql: :43300:demodb:::","",""); connsetautocommit(false); String sql = "insert into car values (' ','2000 cc',' ')"; // executeinsert UniSQLStatement ustmt = (UniSQLStatement)conncreateStatement(); // 2 // executeinsert insert insert insert instance OID UniSQLOID car_oid = ustmtexecuteinsert(sql); // 3 Systemoutprintln(" "); // OID class UniSQLPreparedStatement // //? OID sql = "insert into user_info(name, addr, car) values (' ', ' ',?)"; upstmt = (UniSQLPreparedStatement)connprepareStatement(sql); upstmtsetoid(1,car_oid); // 6 upstmtexecuteupdate(); Systemoutprintln("user "); ustmtclose(); upstmtclose(); conncommit(); // 5 // 4 catch ( SQLException e ) { Systemerrprintln(egetMessage()); catch ( Exception e ) { Systemerrprintln(egetMessage()); finally { if ( conn!= null ) connclose(); class, OID class car class, OID user_info class user OID 3 : car class OID executeinsert executeinsert insert, OID 15

17 2 : executeinsert Statement UniSQLStatement, unisqljdbcdriver* import ( 1 ) 4 : OID user_info class UniSQLPreparedStatement ( 5 ) OID? setoid ( 6 ) UniSQLPreparedStatement unisqljdbcdriver* import ( 1 ) 313 RDBMS UniSQL OID 3131 OID user_info class car OID OID car class import javasql*; import unisqlsql*; import unisqljdbcdriver*; public class deleteoid { public static void main(string[] args) throws Exception { Connection null; Statement stmt = null; ResultSet rs = null; // UniSQL DB Connect ClassforName("unisqljdbcdriverUniSQLDriver"); DriverManagergetConnection("jdbc:unisql: :43300:demodb:::","",""); String sql = "select car from user_info where name = ' '"; stmt = conncreatestatement(); rs = stmtexecutequery(sql); rsnext(); // OID UniSQLOID user_car = (UniSQLOID)rsgetObject("car"); // OID OID user_carremove(); // 1 Systemoutprintln(" "); rsclose(); stmtclose(); conncommit(); 16

18 catch ( SQLException e ) { Systemerrprintln(egetMessage()); catch ( Exception e ) { Systemerrprintln(egetMessage()); finally { if ( conn!= null ) connclose(); user car OID OID 1 : remove() car user_info class car attribute null ( ) 314 OID OID 2 JDBC API 3141 UPDATE OBJECT UPDATE OBJECT OID import javasql*; import unisqlsql*; import unisqljdbcdriver*; public class updateoid { public static void main(string[] args) throws Exception { Connection null; Statement stmt = null; UniSQLPreparedStatement upstmt = null; ResultSet rs = null; // UniSQL DB Connect ClassforName("unisqljdbcdriverUniSQLDriver"); DriverManagergetConnection("jdbc:unisql: :43300:demodb:::","",""); connsetautocommit(false); String sql = "select car from user_info where name = ' '"; 17

19 stmt = conncreatestatement(); rs = stmtexecutequery(sql); UniSQLOID user_car = null; // ' OID rsnext(); user_car = (UniSQLOID)rsgetObject("car"); // OID UPDATE sql = "update object? set name = 'SM5', spec ='2000cc, ABS, DUAL AIRBAG', color = ' '"; // 1 upstmt = (UniSQLPreparedStatement)connprepareStatement(sql); upstmtsetoid(1,user_car); upstmtexecuteupdate(); // 2 rsclose(); upstmtclose(); stmtclose(); conncommit(); catch ( SQLException e ) { Systemerrprintln(egetMessage()); catch ( Exception e ) { Systemerrprintln(egetMessage()); finally { if ( conn!= null ) connclose(); 1 : OID update object OID 2 : update object OID 3121 UniSQLPreparedStatement 3142 OID import javasql*; import unisqlsql*; 3141 UniSQL JDBC API public class updateoid2 { public static void main(string[] args) throws Exception { Connection null; Statement stmt = null; ResultSet rs = null; 18

20 // UniSQL DB Connect ClassforName("unisqljdbcdriverUniSQLDriver"); DriverManagergetConnection("jdbc:unisql: :43300:demodb:::","",""); // ' OID String sql = "select car from user_info where name = ' '"; stmt = conncreatestatement(); rs = stmtexecutequery(sql); UniSQLOID user_car = null; rsnext(); user_car = (UniSQLOID)rsgetObject("car"); // OID UPDATE String [] attr = { "name", "spec", "color"; // 1 Object [] val = { "SM525V", "2500cc LSD ABS", " "; // 2 user_carsetvalues(attr, val); rsclose(); stmtclose(); conncommit(); catch ( SQLException e ) { Systemerrprintln(egetMessage()); catch ( Exception e ) { Systemerrprintln(egetMessage()); finally { if ( conn!= null ) connclose(); // : update attribute array 2 : attr array array 3 : setvalues 32 SET JDBC SET SET DB user_info2 class car attribute car2 class car2 class spec attribute string CREATE CLASS car2 ( name char(40), spec set_of(string) ) CREATE CLASS user_info2 ( 19

21 name char(20), addr string, car set_of(car2) ) 321 SET derived table Collection SET 3211 derived table SET import javasql*; derived table SET public class selectset1 { public static void main(string[] args) throws Exception { Connection null; Statement stmt = null; ResultSet rs = null; // UniSQL DB Connect ClassforName("unisqljdbcdriverUniSQLDriver"); DriverManagergetConnection("jdbc:unisql: :43300:demodb:::","",""); // SET derived table String sql = "select name, addr, car2name from user_info2, table(car) as t(car2)"; stmt = conncreatestatement(); rs = stmtexecutequery(sql); while(rsnext()) { String user_name = rsgetstring("name"); String user_addr = rsgetstring("addr"); String car_name = rsgetstring("car2name"); Systemoutprintln(" : " + user_name); Systemoutprintln(" : " + user_addr); Systemoutprintln(" : " + car_name); Systemoutprintln("\n================================\n"); rsclose(); stmtclose(); catch ( SQLException e ) { Systemerrprintln(egetMessage()); catch ( Exception e ) { Systemerrprintln(egetMessage()); finally { if ( conn!= null ) connclose(); // 1 20

22 derived table SET car attribute derived table 1 : car attribute t derived table car2 attribute (3212 ) SM5 XG 3212 Collection SET Collection 3211 SET 3211 import javasql*; import unisqljdbcdriver*; import unisqlsql*; public class selectset2 { public static void main(string[] args) throws Exception { Connection null; Statement stmt = null; UniSQLResultSet rs = null; UniSQLResultSet urs = null; ClassforName("unisqljdbcdriverUniSQLDriver"); DriverManagergetConnection("jdbc:unisql: :43300:demodb:::","",""); connsetautocommit(false); // 1 String sql = "select name, addr, car from user_info2"; stmt = conncreatestatement(); rs = (UniSQLResultSet)stmtexecuteQuery(sql); while(rsnext()) { String user_name = rsgetstring("name"); String user_addr = rsgetstring("addr"); // SET getcollection // OID SET UniSQLOID array 21

23 UniSQLOID[] car = (UniSQLOID[])rsgetCollection("car"); Systemoutprintln(" : " + user_name); Systemoutprintln(" : " + user_addr); // 2 // array for(int i=0; i<carlength; i++) { // getvalues null attribute urs = (UniSQLResultSet)car[i]getValues(null); // 3 ursnext(); String car_name = ursgetstring("name"); Systemoutprintln(" : " + car_name); Systemoutprintln("\n================================\n"); ursclose(); rsclose(); stmtclose(); conncommit(); catch ( SQLException e ) { Systemerrprintln(egetMessage()); catch ( Exception e ) { Systemerrprintln(egetMessage()); finally { if ( conn!= null ) connclose(); derived table Collection SET 1 : ResultSet close() ResultSet ResultSet autocommit close() ResultSet autocommit false 2 : SET, getcollection array 3 : array for 1 UniSQLOID getvalues getvalues attribute null null class attribute (3111 ) (3221 ) SM5 XG 22

24 322 SET API API OID SET import javasql*; insert OID { SET public class insertset { public static void main(string[] args) throws Exception { Connection null; Statement stmt = null; // UniSQL DB Connect ClassforName("unisqljdbcdriverUniSQLDriver"); DriverManagergetConnection("jdbc:unisql: :43300:demodb:::","",""); // SET { // SET // car2 OID user_info2 SET String sql = "insert into user_info2 values (" + "' ', ' 679-4', { insert into car2 values (' ',{'2000cc',' ')," + "insert into car2 values ('SM5',{'2500cc',' '))"; // 1 stmt = conncreatestatement(); stmtexecuteupdate(sql); Systemoutprintln(" "); conncommit(); stmtclose(); catch ( SQLException e ) { Systemerrprintln(egetMessage()); catch ( Exception e ) { Systemerrprintln(egetMessage()); finally { if ( conn!= null ) connclose(); 23

25 SET { insert into car2(name, spec) values( SM5, { V6 2500cc, DUAL AIRBACK, ABS ) set_of(string) set_of(car2) { OID, OID, OID OID car2 class OID insert 323 SET API SET / 3231 SET import javasql*; SET public class updateset { public static void main(string[] args) throws Exception { Connection null; Statement stmt = null; ClassforName("unisqljdbcdriverUniSQLDriver"); DriverManagergetConnection("jdbc:unisql: :43300:demodb:::","",""); // SET String sql = "update car2 set spec = spec - {' ' + {' stmt = conncreatestatement(); stmtexecuteupdate(sql); Systemoutprintln(" "); stmtclose(); conncommit(); catch ( SQLException e ) { Systemerrprintln(egetMessage()); catch ( Exception e ) { Systemerrprintln(egetMessage()); finally { if ( conn!= null ) connclose(); ' where name = ' '"; 1 : spec attribute // 1 24

26 3232 API SET SET API import javasql*; import unisqljdbcdriver*; import unisqlsql*; public class updateset2 { public static void main(string[] args) throws Exception { Connection null; Statement stmt = null; UniSQLResultSet rs = null; ClassforName("unisqljdbcdriverUniSQLDriver"); DriverManagergetConnection("jdbc:unisql: :43300:demodb:::","",""); String sql = "select car from user_info2 where name = ' '"; stmt = conncreatestatement(); rs = (UniSQLResultSet)stmtexecuteQuery(sql); while(rsnext()) { UniSQLOID[] car = (UniSQLOID[])rsgetCollection("car"); // API SET for(int i=0; i<carlength; i++) { car[i]addtoset("spec"," "); car[i]removefromset("spec"," "); // 1 rsclose(); stmtclose(); conncommit(); catch ( SQLException e ) { Systemerrprintln(egetMessage()); catch ( Exception e ) { Systemerrprintln(egetMessage()); finally { if ( conn!= null ) connclose(); 1 : 44 SET OID addtoset(attribute, ) / removefromset(attribute, ) 25

27 33 GLO GLO GLO LO, FBO 2 LO, FBO GLO class GLO class class Create class file_object under glo GLO LO 331 GLO InputStream file_object class import javasql*; import javaio*; import unisqlsql*; import unisqljdbcdriver*; public class insertlo { public static void main(string[] args) throws Exception { UniSQLConnection null; FileInputStream inputfile = null; // UniSQL DB Connect ClassforName("unisqljdbcdriverUniSQLDriver"); (UniSQLConnection)DriverManagergetConnection("jdbc:unisql: :43300:demodb:::","",""); 1 // file InputStream inputfile = new FileInputStream("/home/unisql/file/testtxt"); // file_object class UniSQLOID glo_oid = conngetnewglo("file_object", inputfile); inputfileclose(); conncommit(); connclose(); 2 3 catch ( SQLException e ) { Systemerrprintln(egetMessage()); 26

28 catch ( Exception e ) { Systemerrprintln(egetMessage()); finally { if ( conn!= null ) connclose(); catch ( SQLException e ) { Systemerrprintln(egetMessage()); 1 GLO UniSQLConnection 2 GLO InputStream 3 getnewglo() API getnewglo( class, InputStream) : InputStream class UniSQLOID 332 GLO GLO GLO import javasql*; import javaio*; import unisqlsql*; import unisqljdbcdriver*; public class selectglo { public static void main(string[] args) throws Exception { UniSQLConnection null; FileOutputStream outputfile = null; // UniSQL DB Connect ClassforName("unisqljdbcdriverUniSQLDriver"); (UniSQLConnection)DriverManagergetConnection("jdbc:unisql: :52500:shindb:::","",""); 1 // GLO OID String sql = "select file_object from file_object"; 27

29 Statement stmt = conncreatestatement(); ResultSet rs = stmtexecutequery(sql); rsnext(); UniSQLOID glo_oid = (UniSQLOID)rsgetObject("file_object"); 2 // loadglo GLO outputfile = new FileOutputStream("/home/unisql/file/tmp000"); glo_oidloadglo(outputfile); 4 3 outputfileclose(); rsclose(); conncommit(); connclose(); catch ( SQLException e ) { Systemerrprintln(egetMessage()); catch ( Exception e ) { Systemerrprintln(egetMessage()); finally { if ( conn!= null ) connclose(); catch ( SQLException e ) { Systemerrprintln(egetMessage()); 1 UniSQLConnection 2 OID 3 OutPutStream 4 loadglo() API GLO loadglo(outputstream) : GLO OutPutSteeam 28

10.ppt

10.ppt : SQL. SQL Plus. JDBC. SQL >> SQL create table : CREATE TABLE ( ( ), ( ),.. ) SQL >> SQL create table : id username dept birth email id username dept birth email CREATE TABLE member ( id NUMBER NOT NULL

More information

歯JavaExceptionHandling.PDF

歯JavaExceptionHandling.PDF (2001 3 ) from Yongwoo s Park Java Exception Handling Programming from Yongwoo s Park 1 Java Exception Handling Programming from Yongwoo s Park 2 1 4 11 4 4 try/catch 5 try/catch/finally 9 11 12 13 13

More information

쉽게 풀어쓴 C 프로그래밊

쉽게 풀어쓴 C 프로그래밊 Power Java 제 27 장데이터베이스 프로그래밍 이번장에서학습할내용 자바와데이터베이스 데이터베이스의기초 SQL JDBC 를이용한프로그래밍 변경가능한결과집합 자바를통하여데이터베이스를사용하는방법을학습합니다. 자바와데이터베이스 JDBC(Java Database Connectivity) 는자바 API 의하나로서데이터베이스에연결하여서데이터베이스안의데이터에대하여검색하고데이터를변경할수있게한다.

More information

FileMaker ODBC and JDBC Guide

FileMaker ODBC and JDBC Guide FileMaker 13 5 5 5 6 6 6 7 7 8 8 8 8 9 9 10 10 11 11 12 12 12 12 12 12 13 13 14 14 16 16 18 4 19 19 20 20 21 21 21 23 23 23 23 25 26 26 26 26 27 28 28 28 28 29 31 31 32 33 33 33 33 34 34 35 35 35 36 1

More information

FileMaker ODBC and JDBC Guide

FileMaker ODBC and JDBC Guide FileMaker 14 5 5 5 5 6 6 6 7 7 7 8 8 8 9 9 10 10 11 11 12 12 12 12 12 13 13 14 15 16 17 18 18 19 19 20 20 20 21 21 21 22 22 22 22 23 24 24 24 24 25 27 27 28 29 29 29 29 30 30 31 31 31 32 1 1 1 1 1 1 1

More information

자바-11장N'1-502

자바-11장N'1-502 C h a p t e r 11 java.net.,,., (TCP/IP) (UDP/IP).,. 1 ISO OSI 7 1977 (ISO, International Standards Organization) (OSI, Open Systems Interconnection). 6 1983 X.200. OSI 7 [ 11-1] 7. 1 (Physical Layer),

More information

FileMaker ODBC 및 JDBC 가이드

FileMaker ODBC 및 JDBC 가이드 FileMaker ODBC JDBC 2004-2019 FileMaker, Inc.. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker, FileMaker Cloud, FileMaker Go FileMaker, Inc.. FileMaker WebDirect FileMaker,

More information

ORANGE FOR ORACLE V4.0 INSTALLATION GUIDE (Online Upgrade) ORANGE CONFIGURATION ADMIN O

ORANGE FOR ORACLE V4.0 INSTALLATION GUIDE (Online Upgrade) ORANGE CONFIGURATION ADMIN O Orange for ORACLE V4.0 Installation Guide ORANGE FOR ORACLE V4.0 INSTALLATION GUIDE...1 1....2 1.1...2 1.2...2 1.2.1...2 1.2.2 (Online Upgrade)...11 1.3 ORANGE CONFIGURATION ADMIN...12 1.3.1 Orange Configuration

More information

FileMaker 15 ODBC 및 JDBC 설명서

FileMaker 15 ODBC 및 JDBC 설명서 FileMaker 15 ODBC JDBC 2004-2016 FileMaker, Inc.. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker Go FileMaker, Inc.. FileMaker WebDirect FileMaker, Inc... FileMaker.

More information

PowerPoint 프레젠테이션

PowerPoint 프레젠테이션 @ Lesson 2... ( ). ( ). @ vs. logic data method variable behavior attribute method field Flow (Type), ( ) member @ () : C program Method A ( ) Method B ( ) Method C () program : Java, C++, C# data @ Program

More information

PowerPoint 프레젠테이션

PowerPoint 프레젠테이션 @ Lesson 3 if, if else, if else if, switch case for, while, do while break, continue : System.in, args, JOptionPane for (,, ) @ vs. logic data method variable Data Data Flow (Type), ( ) @ Member field

More information

rmi_박준용_final.PDF

rmi_박준용_final.PDF (RMI) - JSTORM http://wwwjstormpekr (RMI)- Document title: Document file name: Revision number: Issued by: Document Information (RMI)- rmi finaldoc Issue Date: Status:

More information

02 C h a p t e r Java

02 C h a p t e r Java 02 C h a p t e r Java Bioinformatics in J a va,, 2 1,,,, C++, Python, (Java),,, (http://wwwbiojavaorg),, 13, 3D GUI,,, (Java programming language) (Sun Microsystems) 1995 1990 (green project) TV 22 CHAPTER

More information

Interstage5 SOAP서비스 설정 가이드

Interstage5 SOAP서비스 설정 가이드 Interstage 5 Application Server ( Solaris ) SOAP Service Internet Sample Test SOAP Server Application SOAP Client Application CORBA/SOAP Server Gateway CORBA/SOAP Gateway Client INTERSTAGE SOAP Service

More information

Analyze Connection Failover Options.ppt

Analyze Connection Failover Options.ppt Analyze Connection Failover options 1 TAF 를구현하기위한 Application 고려사항 1. Application FailOver 방법결정 2. Application의사용형태, 종류, 중요도에따라 TAF적용여부결정 3. Language별, 사용형태별 TAF사용여부및방법결정 4. Transaction에따른장애시점별 TAF 사용여부및방법결정

More information

J2EE Concepts

J2EE Concepts ! Introduction to J2EE (1) - J2EE Servlet/JSP/JDBC iseminar.. 1544-3355 ( ) iseminar Chat. 1 Who Are We? Business Solutions Consultant Oracle Application Server 10g Business Solutions Consultant Oracle10g

More information

JMF2_심빈구.PDF

JMF2_심빈구.PDF JMF JSTORM http://wwwjstormpekr Issued by: < > Document Information Document title: Document file name: Revision number: Issued by: JMF2_ doc Issue Date: Status: < > raica@nownurinet

More information

@OneToOne(cascade = = "addr_id") private Addr addr; public Emp(String ename, Addr addr) { this.ename = ename; this.a

@OneToOne(cascade = = addr_id) private Addr addr; public Emp(String ename, Addr addr) { this.ename = ename; this.a 1 대 1 단방향, 주테이블에외래키실습 http://ojcedu.com, http://ojc.asia STS -> Spring Stater Project name : onetoone-1 SQL : JPA, MySQL 선택 http://ojc.asia/bbs/board.php?bo_table=lecspring&wr_id=524 ( 마리아 DB 설치는위 URL

More information

Microsoft PowerPoint - GUI _DB연동.ppt [호환 모드]

Microsoft PowerPoint - GUI _DB연동.ppt [호환 모드] GUI 설계 6 주차 DB 연동김문정 tops@yd.ac.kr 강의순서강의전환경 JDK 설치및환경설정톰캣설치및환경설정이클립스 (JEE) 설치및환경설정 MySQL( 드라이버 ) 설치및커넥터드라이브연결 DB 생성 - 계정생성이클립스에서 DB에연결서버생성 - 프로젝트생성 DB연결테이블생성및등록 2 MySQL 설치확인 mysql - u root -p MySQL 에데이터베이스추가

More information

개발문서 Oracle - Clob

개발문서 Oracle - Clob 개발문서 ORACLE CLOB 2008.6.9 ( 주 ) 아이캔매니지먼트 개발팀황순규 0. clob개요 1. lob과 long의비교와 clob와 blob 2. 테이블생성쿼리 ( 차이점-추가사항 ) 3. select 쿼리 4. insert 쿼리및 jdbc프로그래밍 5. update 쿼리및 jdbc프로그래밍 (4, 5). putclobdata() 클래스 6. select

More information

PowerPoint 프레젠테이션

PowerPoint 프레젠테이션 실습문제 Chapter 05 데이터베이스시스템... 오라클로배우는데이터베이스개론과실습 1. 실습문제 1 (5 장심화문제 : 각 3 점 ) 6. [ 마당서점데이터베이스 ] 다음프로그램을 PL/SQL 저장프로시져로작성하고실행해 보시오. (1) ~ (2) 7. [ 마당서점데이터베이스 ] 다음프로그램을 PL/SQL 저장프로시져로작성하고실행해 보시오. (1) ~ (5)

More information

- 다음은 Statement 객체를사용해서삽입 (insert) 작업의예 String sql = "insert into member(code, name, id, pwd, age) values ("; int id = 10; sql = sql + id +, ;// 항목사이에

- 다음은 Statement 객체를사용해서삽입 (insert) 작업의예 String sql = insert into member(code, name, id, pwd, age) values (; int id = 10; sql = sql + id +, ;// 항목사이에 Statement 객체와 PreparedStatement 객체 Connection 객체 - Connection 객체가생성되면데이터베이스에접근이가능해진다. - Connection 객체는자바와데이터베이스의접속된상태의객체를말한다. 데이터베이스에 DML작업을위해서는반드시접속을먼저해야한다. 그리고, 작업후에는반드시접속을해제한다. - Connection 객체를생성할때두개의문자열이필요하다.

More information

PWR PWR HDD HDD USB USB Quick Network Setup Guide xdsl/cable Modem PC DVR 1~3 1.. DVR DVR IP xdsl Cable xdsl Cable PC PC DDNS (

PWR PWR HDD HDD USB USB Quick Network Setup Guide xdsl/cable Modem PC DVR 1~3 1.. DVR DVR IP xdsl Cable xdsl Cable PC PC DDNS ( PWR PWR HDD HDD USB USB Quick Network Setup Guide xdsl/cable Modem PC DVR 1~3 1.. DVR DVR IP xdsl Cable xdsl Cable PC PC DDNS (http://ddns.hanwha-security.com) Step 1~5. Step, PC, DVR Step 1. Cable Step

More information

Microsoft PowerPoint - 18-DataSource.ppt

Microsoft PowerPoint - 18-DataSource.ppt 18 장 : JDBC DataSource DataSource JDBC 2.0의 javax.sql 패키지에포함되어도입됨 DataSource 인터페이스는데이터베이스커넥션을만들거나사용하는데좀더유연한아키텍처를제공하기위해도입됨 DataSource를이용할경우, 클라이언트코드는한줄도바꾸지않고서도다른데이터베이스에접속할수있도록해줌 즉 DataSource 는커넥션상세사항들을캡슐화

More information

13주-14주proc.PDF

13주-14주proc.PDF 12 : Pro*C/C++ 1 2 Embeded SQL 3 PRO *C 31 C/C++ PRO *C NOT! NOT AND && AND OR OR EQUAL == = SQL,,, Embeded SQL SQL 32 Pro*C C SQL Pro*C C, C Pro*C, C C 321, C char : char[n] : n int, short, long : float

More information

개요오라클과티베로에서 JDBC 를통해접속한세션을구분할수있도록 JDBC 접속시 ConnectionProperties 를통해구분자를넣어줄수있다. 하나의 Node 에다수의 WAS 가있을경우 DB 에서 Session Kill 등의동작수행시원하는 Session 을선택할수있다.

개요오라클과티베로에서 JDBC 를통해접속한세션을구분할수있도록 JDBC 접속시 ConnectionProperties 를통해구분자를넣어줄수있다. 하나의 Node 에다수의 WAS 가있을경우 DB 에서 Session Kill 등의동작수행시원하는 Session 을선택할수있다. 설치및환경설정 JDBC 접속세션구분 / 확인 2013. 11. 01 개요오라클과티베로에서 JDBC 를통해접속한세션을구분할수있도록 JDBC 접속시 ConnectionProperties 를통해구분자를넣어줄수있다. 하나의 Node 에다수의 WAS 가있을경우 DB 에서 Session Kill 등의동작수행시원하는 Session 을선택할수있다. 사용하기 JEUS 에서설정방법

More information

USB USB DV25 DV25 REC SRN-475S REC SRN-475S LAN POWER LAN POWER Quick Network Setup Guide xdsl/cable Modem PC DVR 1~3 1.. DVR DVR IP xdsl Cable xdsl C

USB USB DV25 DV25 REC SRN-475S REC SRN-475S LAN POWER LAN POWER Quick Network Setup Guide xdsl/cable Modem PC DVR 1~3 1.. DVR DVR IP xdsl Cable xdsl C USB USB DV25 DV25 REC SRN-475S REC SRN-475S LAN POWER LAN POWER Quick Network Setup Guide xdsl/cable Modem PC DVR 1~3 1.. DVR DVR IP xdsl Cable xdsl Cable PC PC Step 1~5. Step, PC, DVR Step 1. Cable Step

More information

목차 BUG DEQUEUE 의 WAIT TIME 이 1 초미만인경우, 설정한시간만큼대기하지않는문제가있습니다... 3 BUG [qp-select-pvo] group by 표현식에있는컬럼을참조하는집합연산이존재하지않으면결괏값오류가발생할수있습니다... 4

목차 BUG DEQUEUE 의 WAIT TIME 이 1 초미만인경우, 설정한시간만큼대기하지않는문제가있습니다... 3 BUG [qp-select-pvo] group by 표현식에있는컬럼을참조하는집합연산이존재하지않으면결괏값오류가발생할수있습니다... 4 ALTIBASE HDB 6.5.1.5.10 Patch Notes 목차 BUG-46183 DEQUEUE 의 WAIT TIME 이 1 초미만인경우, 설정한시간만큼대기하지않는문제가있습니다... 3 BUG-46249 [qp-select-pvo] group by 표현식에있는컬럼을참조하는집합연산이존재하지않으면결괏값오류가발생할수있습니다... 4 BUG-46266 [sm]

More information

Analytics > Log & Crash Search > Unity ios SDK [Deprecated] Log & Crash Unity ios SDK. TOAST SDK. Log & Crash Unity SDK Log & Crash Search. Log & Cras

Analytics > Log & Crash Search > Unity ios SDK [Deprecated] Log & Crash Unity ios SDK. TOAST SDK. Log & Crash Unity SDK Log & Crash Search. Log & Cras Analytics > Log & Crash Search > Unity ios SDK [Deprecated] Log & Crash Unity ios SDK. TOAST SDK. Log & Crash Unity SDK Log & Crash Search. Log & Crash Unity SDK... Log & Crash Search. - Unity3D v4.0 ios

More information

untitled

untitled PowerBuilder 連 Microsoft SQL Server database PB10.0 PB9.0 若 Microsoft SQL Server 料 database Profile MSS 料 (Microsoft SQL Server database interface) 行了 PB10.0 了 Sybase 不 Microsoft 料 了 SQL Server 料 PB10.0

More information

NoSQL

NoSQL MongoDB Daum Communications NoSQL Using Java Java VM, GC Low Scalability Using C Write speed Auto Sharding High Scalability Using Erlang Read/Update MapReduce R/U MR Cassandra Good Very Good MongoDB Good

More information

Microsoft PowerPoint - aj-lecture5.ppt [호환 모드]

Microsoft PowerPoint - aj-lecture5.ppt [호환 모드] JDBC 프로그래밍 524730-1 2019 년봄학기 4/8/2019 박경신 데이터베이스의개념 데이터베이스 (Database) 여러응용시스템들의통합된정보들을저장하여운영할수있는공용데이터들의집합 데이터의저장, 검색, 갱신을효율적으로수행할수있도록데이터를고도로조직화하여저장 DBMS 데이터베이스관리시스템 (DataBase Management System) 오라클 (Oracle),

More information

<4D F736F F F696E74202D20C1A63234C0E520C0D4C3E2B7C228B0ADC0C729205BC8A3C8AF20B8F0B5E55D>

<4D F736F F F696E74202D20C1A63234C0E520C0D4C3E2B7C228B0ADC0C729205BC8A3C8AF20B8F0B5E55D> Power Java 제 24 장입출력 이번장에서학습할내용 스트림이란? 스트림의분류 바이트스트림 문자스트림 형식입출력 명령어행에서입출력 파일입출력 스트림을이용한입출력에대하여살펴봅시다. 스트림 (stream) 스트림 (stream) 은 순서가있는데이터의연속적인흐름 이다. 스트림은입출력을물의흐름처럼간주하는것이다. 스트림들은연결될수있다. 중간점검문제 1. 자바에서는입출력을무엇이라고추상화하는가?

More information

Microsoft PowerPoint - 04-UDP Programming.ppt

Microsoft PowerPoint - 04-UDP Programming.ppt Chapter 4. UDP Dongwon Jeong djeong@kunsan.ac.kr http://ist.kunsan.ac.kr/ Dept. of Informatics & Statistics 목차 UDP 1 1 UDP 개념 자바 UDP 프로그램작성 클라이언트와서버모두 DatagramSocket 클래스로생성 상호간통신은 DatagramPacket 클래스를이용하여

More information

12-file.key

12-file.key 11 (String).. java.lang.stringbuffer. s String s = "abcd"; s = s + "e"; a b c d e a b c d e ,., "910359,, " "910359" " " " " (token) (token),, (delimiter). java.util.stringtokenizer String s = "910359,,

More information

Microsoft PowerPoint - Supplement-03-TCP Programming.ppt [호환 모드]

Microsoft PowerPoint - Supplement-03-TCP Programming.ppt [호환 모드] - Socket Programming in Java - 목차 소켓소개 자바에서의 TCP 프로그램작성방법 주요클래스와메소드 HTTP 프로토콜을이용한예제 에코프로그램 Q/A 에코프로그램 - EchoServer 에코프로그램 - EchoClient TCP Programming 1 소켓소개 IP, Port, and Socket 포트 (Port): 전송계층에서통신을수행하는응용프로그램을찾기위한주소

More information

[ 목차 ] 5.1 데이터베이스프로그래밍개념 5.2 T-SQL T-SQL 문법 5.3 JAVA 프로그래밍 2

[ 목차 ] 5.1 데이터베이스프로그래밍개념 5.2 T-SQL T-SQL 문법 5.3 JAVA 프로그래밍 2 5 장 SQL 응용 데이터베이스실험실 1 [ 목차 ] 5.1 데이터베이스프로그래밍개념 5.2 T-SQL 5.2.1 T-SQL 문법 5.3 JAVA 프로그래밍 2 5.1 데이터베이스프로그래밍개념 프로그래밍 이라고하면프로그램소스를설계하고, 작성하고, 디버깅하는과정을말한다. 프로그램 혹은소프트웨어는컴퓨터에서주어진작업을하는명령어나열을말한다. 데이터베이스프로그래밍은명확한정의는없지만데이터베이스에데이터를정의하고,

More information

untitled

untitled Push... 2 Push... 4 Push... 5 Push... 13 Push... 15 1 FORCS Co., LTD A Leader of Enterprise e-business Solution Push (Daemon ), Push Push Observer. Push., Observer. Session. Thread Thread. Observer ID.

More information

교육2 ? 그림

교육2 ? 그림 Interstage 5 Apworks EJB Application Internet Revision History Edition Date Author Reviewed by Remarks 1 2002/10/11 2 2003/05/19 3 2003/06/18 EJB 4 2003/09/25 Apworks5.1 [ Stateless Session Bean ] ApworksJava,

More information

IBM blue-and-white template

IBM blue-and-white template IBM Software Group 웹기반의 DB2 개발환경구축및 DB2 Information Integrator 를이용한정보통합데모 한국 IBM 소프트웨어사업부 정진영대리 (jyjeong@kr.ibm.com) Agenda Preparation JAVA ENV JAVA CONNECTION PHP ENV PHP CONNECTION Preparation Installation

More information

Java

Java Java http://cafedaumnet/pway Chapter 1 1 public static String format4(int targetnum){ String strnum = new String(IntegertoString(targetNum)); StringBuffer resultstr = new StringBuffer(); for(int i = strnumlength();

More information

Microsoft PowerPoint - 03-TCP Programming.ppt

Microsoft PowerPoint - 03-TCP Programming.ppt Chapter 3. - Socket in Java - 목차 소켓소개 자바에서의 프로그램작성방법 주요클래스와메소드 HTTP 프로토콜을이용한예제 에코프로그램 에코프로그램 - EchoServer 에코프로그램 - EchoClient Q/A 1 1 소켓소개 IP,, and Socket 포트 (): 전송계층에서통신을수행하는응용프로그램을찾기위한주소 소켓 (Socket):

More information

chapter4

chapter4 Basic Netw rk 1. ก ก ก 2. 3. ก ก 4. ก 2 1. 2. 3. 4. ก 5. ก 6. ก ก 7. ก 3 ก ก ก ก (Mainframe) ก ก ก ก (Terminal) ก ก ก ก ก ก ก ก 4 ก (Dumb Terminal) ก ก ก ก Mainframe ก CPU ก ก ก ก 5 ก ก ก ก ก ก ก ก ก ก

More information

Spring Boot/JDBC JdbcTemplate/CRUD 예제

Spring Boot/JDBC JdbcTemplate/CRUD 예제 Spring Boot/JDBC JdbcTemplate/CRUD 예제 오라클자바커뮤니티 (ojc.asia, ojcedu.com) Spring Boot, Gradle 과오픈소스인 MariaDB 를이용해서 EMP 테이블을만들고 JdbcTemplate, SimpleJdbcTemplate 을이용하여 CRUD 기능을구현해보자. 마리아 DB 설치는다음 URL 에서확인하자.

More information

91 // 물리적으로닫지않고 cache에반환만한다. opstmt.close(); } opstmt.setint(3, lowerlimit); opstmt.setint(4, upperlimit); // Execute query rset = opstmt.executequery

91 // 물리적으로닫지않고 cache에반환만한다. opstmt.close(); } opstmt.setint(3, lowerlimit); opstmt.setint(4, upperlimit); // Execute query rset = opstmt.executequery 90 2007 Spring Oracle Korea Magazine *Technology & Developer Technical Tips Oracle JDBC 를이용한성능향상방법쉽게적용할수있는예제들 저자 _ 김정식 Oracle ACE(oramaster@empal.com) JAVA 기반의웹프로젝트를진행하다보면대부분의개발자분들이사용하는 JDBC API들은제한적인것같다.

More information

PowerPoint 프레젠테이션

PowerPoint 프레젠테이션 @ Lesson 1,..... @ 1 Green Project 1991 Oak Java 1995. 5 December '90 by Patrick Naughton, Mike Sheridan and James Gosling Embedded in various consumer electronic device 1992. 9. 3 Star 7 1993 www portability

More information

MasoJava4_Dongbin.PDF

MasoJava4_Dongbin.PDF JSTORM http://wwwjstormpekr Issued by: < > Revision: Document Information Document title: Document file name: MasoJava4_Dongbindoc Revision number: Issued by: < > SI, dbin@handysoftcokr

More information

PowerPoint 프레젠테이션

PowerPoint 프레젠테이션 @ Lesson 4 (Object) (Class) (Instance) (Method) (Constructor) Memory 1 UML 1 @ & 1 (Real World) (Software World) @ &.. () () @ & 2 (Real World) (Software World) OOA/ Modeling Abstraction Instantiation

More information

단계

단계 TIBERO-WAS 연동 Guide 본문서에서는 Tibero RDBMS 에서제공하는 JDBC 통한 JEUS, WEBLOGIC 등다양한 WAS (Web Application Server) 제품과의연동방법을알아본다. Contents 1. Connection Pool 방식... 2 2. JEUS 연동... 3 2.1. JEUSMain.xml 설정 (Thin 방식

More information

thesis

thesis ( Design and Implementation of a Generalized Management Information Repository Service for Network and System Management ) ssp@nile nile.postech.ac..ac.kr DPE Lab. 1997 12 16 GMIRS GMIRS GMIRS prototype

More information

Chap7.PDF

Chap7.PDF Chapter 7 The SUN Intranet Data Warehouse: Architecture and Tools All rights reserved 1 Intranet Data Warehouse : Distributed Networking Computing Peer-to-peer Peer-to-peer:,. C/S Microsoft ActiveX DCOM(Distributed

More information

untitled

untitled - -, (insert) (delete) - - (insert) (delete) (top ) - - (insert) (rear) (delete) (front) A A B top A B C top push(a) push(b) push(c) A B top pop() top A B D push(d) top #define MAX_STACK_SIZE 100 int

More information

07 자바의 다양한 클래스.key

07 자바의 다양한 클래스.key [ 07 ] . java.lang Object, Math, String, StringBuffer Byte, Short, Integer, Long, Float, Double, Boolean, Character. java.util Random, StringTokenizer Calendar, GregorianCalendar, Date. Collection, List,

More information

untitled

untitled (shared) (integrated) (stored) (operational) (data) : (DBMS) :, (database) :DBMS File & Database - : - : ( : ) - : - : - :, - DB - - -DBMScatalog meta-data -DBMS -DBMS - -DBMS concurrency control E-R,

More information

03-JAVA Syntax(2).PDF

03-JAVA Syntax(2).PDF JAVA Programming Language Syntax of JAVA (literal) (Variable and data types) (Comments) (Arithmetic) (Comparisons) (Operators) 2 HelloWorld application Helloworldjava // class HelloWorld { //attribute

More information

JavaGeneralProgramming.PDF

JavaGeneralProgramming.PDF , Java General Programming from Yongwoo s Park 1 , Java General Programming from Yongwoo s Park 2 , Java General Programming from Yongwoo s Park 3 < 1> (Java) ( 95/98/NT,, ) API , Java General Programming

More information

비긴쿡-자바 00앞부속

비긴쿡-자바 00앞부속 IT COOKBOOK 14 Java P r e f a c e Stay HungryStay Foolish 3D 15 C 3 16 Stay HungryStay Foolish CEO 2005 L e c t u r e S c h e d u l e 1 14 PPT API C A b o u t T h i s B o o k IT CookBook for Beginner Chapter

More information

8 장데이터베이스 8.1 기본개념 - 데이터베이스 : 데이터를조직적으로구조화한집합 (cf. 엑셀파일 ) - 테이블 : 데이터의기록형식 (cf. 엑셀시트의첫줄 ) - 필드 : 같은종류의데이터 (cf. 엑셀시트의각칸 ) - 레코드 : 데이터내용 (cf. 엑셀시트의한줄 )

8 장데이터베이스 8.1 기본개념 - 데이터베이스 : 데이터를조직적으로구조화한집합 (cf. 엑셀파일 ) - 테이블 : 데이터의기록형식 (cf. 엑셀시트의첫줄 ) - 필드 : 같은종류의데이터 (cf. 엑셀시트의각칸 ) - 레코드 : 데이터내용 (cf. 엑셀시트의한줄 ) 8 장데이터베이스 8.1 기본개념 - 데이터베이스 : 데이터를조직적으로구조화한집합 (cf. 엑셀파일 ) - 테이블 : 데이터의기록형식 (cf. 엑셀시트의첫줄 ) - 필드 : 같은종류의데이터 (cf. 엑셀시트의각칸 ) - 레코드 : 데이터내용 (cf. 엑셀시트의한줄 ) - DDL(Data Definition Language) : show, create, drop

More information

DocsPin_Korean.pages

DocsPin_Korean.pages Unity Localize Script Service, Page 1 Unity Localize Script Service Introduction Application Game. Unity. Google Drive Unity.. Application Game. -? ( ) -? -?.. 준비사항 Google Drive. Google Drive.,.. - Google

More information

13-Java Network Programming

13-Java Network Programming JAVA Programming Language JAVA Network Programming IP Address(Internet Protocol Address) URL(Uniform Resource Location) TCP(Transmission Control Protocol) Socket UDP(User Datagram Protocol) Client / Server

More information

뇌를 자극하는 JSP & Servlet 슬라이드

뇌를 자극하는 JSP & Servlet 슬라이드 데이터베이스사용하기 JSP & Servlet Contents 학습목표 데이터베이스를이용하면파일보다훨씬더체계적이고구조적인방법으로데이터를저장하고관리할수있다. 그래서웹프로그래밍에서도데이터베이스를사용해야할경우가많이있는데이번장에서는그방법을배워보자. 내용 데이터베이스개론 MySQL 설치하기 Connector/J 설치하기 웹컴포넌트에서데이터베이스를사용하는방법 데이터베이스커넥션풀의설치와사용

More information

웹연동 } 웹 (Web) 환경에서데이터베이스시스템을연동하는방법은다음과같다 } Server Client 구조의통신 (2-Tier) } Server Middleware Client 구조의통신 (3-Tier) 2

웹연동 } 웹 (Web) 환경에서데이터베이스시스템을연동하는방법은다음과같다 } Server Client 구조의통신 (2-Tier) } Server Middleware Client 구조의통신 (3-Tier) 2 DB 와 WEB 연동 (1) [2-Tier] Java Applet 이용 웹연동 } 웹 (Web) 환경에서데이터베이스시스템을연동하는방법은다음과같다 } Server Client 구조의통신 (2-Tier) } Server Middleware Client 구조의통신 (3-Tier) 2 JAVA Applet 을이용한 Client Server 연동기법 } Applet

More information

교육자료

교육자료 THE SYS4U DODUMENT Java Reflection & Introspection 2012.08.21 김진아사원 2012 SYS4U I&C All rights reserved. 목차 I. 개념 1. Reflection 이란? 2. Introspection 이란? 3. Reflection 과 Introspection 의차이점 II. 실제사용예 1. Instance의생성

More information

PowerPoint 프레젠테이션

PowerPoint 프레젠테이션 배효철 th1g@nate.com 1 목차 표준입출력 파일입출력 2 표준입출력 표준입력은키보드로입력하는것, 주로 Scanner 클래스를사용. 표준출력은화면에출력하는메소드를사용하는데대표적으로 System.out.printf( ) 를사용 3 표준입출력 표준출력 : System.out.printlf() 4 표준입출력 Example 01 public static void

More information

Cluster management software

Cluster management software 자바네트워크프로그래밍 (OCJP 국제공인자격취득중심 ) 충북대학교 최민 기본예제 예외클래스를정의하고사용하는예제 class NewException extends Exception { public class ExceptionTest { static void methoda() throws NewException { System.out.println("NewException

More information

Application 에서 Parameter 값을받아 JDBC Interface 로보내게되면적절한 JDBC Driver 를통해 SQL 을 Database 로보내주게되고결과를받아서사용자에게보여주게된다. 2-2 JDBC Interface JDBC 의핵심 Interface

Application 에서 Parameter 값을받아 JDBC Interface 로보내게되면적절한 JDBC Driver 를통해 SQL 을 Database 로보내주게되고결과를받아서사용자에게보여주게된다. 2-2 JDBC Interface JDBC 의핵심 Interface All about JDBC Performance Tuning 엑셈컨설팅본부 /APM 팀임대호 1 개요 JDBC 란 Java Database Connectivity 의약어이며, 데이터베이스표준접근 API(Application Programing Interface) 를말한다. JDBC 를사용하면어떤관계형데이터베이스에서도, 각데이터베이스에맞는접근프로그램을따로생성할필요없이사용할수있다.

More information

웹의 뼈대, HTML

웹의 뼈대, HTML 6. JSP 와 DB 연동 1. 관계형데이터베이스시스템 2. JDBC Programming 3. 견본데이터베이스생성 4. Report 실습예제 웹서버와 DB 서버와의관계 Client Web Browser HTTP 요청 HTML 페이지응답 Server Web Server Apache, IIS, IBM WebSpere, Oracle WAS TmaxSoft JEUS

More information

I T C o t e n s P r o v i d e r h t t p : / / w w w. h a n b i t b o o k. c o. k r

I T C o t e n s P r o v i d e r h t t p : / / w w w. h a n b i t b o o k. c o. k r I T C o t e n s P r o v i d e r h t t p : / / w w w. h a n b i t b o o k. c o. k r -------------------------------------------------------------------- -- 1. : ts_cre_bonsa.sql -- 2. :

More information

Simplify your Job Automatic Storage Management DB TSC

Simplify your Job Automatic Storage Management DB TSC Simplify your Job Automatic Storage Management DB TSC 1. DBA Challenges 2. ASM Disk group 3. Mirroring/Striping/Rebalancing 4. Traditional vs. ASM 5. ASM administration 6. ASM Summary Capacity in Terabytes

More information

Chap12

Chap12 12 12Java RMI 121 RMI 2 121 RMI 3 - RMI, CORBA 121 RMI RMI RMI (remote object) 4 - ( ) UnicastRemoteObject, 121 RMI 5 class A - class B - ( ) class A a() class Bb() 121 RMI 6 RMI / 121 RMI RMI 1 2 ( 7)

More information

ALTIBASE 사용자가이드 Templete

ALTIBASE 사용자가이드 Templete Real Alternative DBMS ALTIBASE, Since 1999 ALTIBASE & TOMCAT 연동가이드 ALTIBASE 6 2014. 10 Copyright c 2000~2014 ALTIBASE Corporation. All Rights Reserved. Document Control Change Record Date Author Change

More information

MySQL-Ch10

MySQL-Ch10 10 Chapter.,,.,, MySQL. MySQL mysqld MySQL.,. MySQL. MySQL....,.,..,,.,. UNIX, MySQL. mysqladm mysqlgrp. MySQL 608 MySQL(2/e) Chapter 10 MySQL. 10.1 (,, ). UNIX MySQL, /usr/local/mysql/var, /usr/local/mysql/data,

More information

17장

17장 17 JDBC 프로그래밍 O b j e c t i v e s 데이터베이스개념을이해한다. JDBC 구조를이해한다. MySQL을간단히설치하고활용할줄안다. 데이터베이스생성 접속, 테이블생성, 레코드추가 삭제, 데이터검색 수정등을위한 SQL 문을이해한다. JDBC를이용한데이터베이스프로그래밍을작성해본다. C H A P T E R JAVA PROGRAMMING JDBC

More information

I T C o t e n s P r o v i d e r h t t p : / / w w w. h a n b i t b o o k. c o. k r

I T C o t e n s P r o v i d e r h t t p : / / w w w. h a n b i t b o o k. c o. k r I T C o t e n s P r o v i d e r h t t p : / / w w w. h a n b i t b o o k. c o. k r I T C o t e n s P r o v i d e r h t t p : / / w w w. h a n b i t b o o k. c o. k r Jakarta is a Project of the Apache

More information

[ 정보 ] 과학고 R&E 결과보고서 Monte Carlo Method 를이용한 고교배정시뮬레이션 연구기간 : ~ 연구책임자 : 강대욱 ( 전남대전자컴퓨터공학부 ) 지도교사 : 최미경 ( 전남과학고정보 컴퓨터과 ) 참여학생 : 박진명 ( 전

[ 정보 ] 과학고 R&E 결과보고서 Monte Carlo Method 를이용한 고교배정시뮬레이션 연구기간 : ~ 연구책임자 : 강대욱 ( 전남대전자컴퓨터공학부 ) 지도교사 : 최미경 ( 전남과학고정보 컴퓨터과 ) 참여학생 : 박진명 ( 전 [ 정보 ] 과학고 R&E 결과보고서 Monte Carlo Method 를이용한 고교배정시뮬레이션 연구기간 : 2013. 3 ~ 2014. 2 연구책임자 : 강대욱 ( 전남대전자컴퓨터공학부 ) 지도교사 : 최미경 ( 전남과학고정보 컴퓨터과 ) 참여학생 : 박진명 ( 전남과학고 1학년 ) 박수형 ( 전남과학고 1학년 ) 서범수 ( 전남과학고 1학년 ) 김효정

More information

페이지 2 / 9 목차 개요웹취약점분류점검결과해결방안 주의사항 : 빛스캔 ( 주 ) 의취약성검사가대상웹사이트의취약점을 100% 진단하지못할가능성이있으며, 원격에서탐지 하는점검의특성상오탐지 (False Positive) 할가능성이있으므로충분한검토과정

페이지 2 / 9 목차 개요웹취약점분류점검결과해결방안 주의사항 : 빛스캔 ( 주 ) 의취약성검사가대상웹사이트의취약점을 100% 진단하지못할가능성이있으며, 원격에서탐지 하는점검의특성상오탐지 (False Positive) 할가능성이있으므로충분한검토과정 페이지 1 / 9 https://scan.bitscan.co.kr -BMT version 웹취약점점검보고서 점검대상 : testasp.vulnweb.com 주의 : 점검대상웹서버보안에관련된중요한정보를포함하고있습니다. 빛스캔 ( 주 ) https://scan.bitscan.co.kr 페이지 2 / 9 목차 1. 2. 3. 4. 개요웹취약점분류점검결과해결방안 주의사항

More information

1

1 1 1....6 1.1...6 2. Java Architecture...7 2.1 2SDK(Software Development Kit)...8 2.2 JRE(Java Runtime Environment)...9 2.3 (Java Virtual Machine, JVM)...10 2.4 JVM...11 2.5 (runtime)jvm...12 2.5.1 2.5.2

More information

1217 WebTrafMon II

1217 WebTrafMon II (1/28) (2/28) (10 Mbps ) Video, Audio. (3/28) 10 ~ 15 ( : telnet, ftp ),, (4/28) UDP/TCP (5/28) centralized environment packet header information analysis network traffic data, capture presentation network

More information

Microsoft PowerPoint - Tech-iSeminar_9iAS_OAS10g_PBT.ppt

Microsoft PowerPoint - Tech-iSeminar_9iAS_OAS10g_PBT.ppt Oracle 9iAS, OracleAS 10g 일반튜닝및문제해결 Getting the most out of MetaLink 오치영 한국오라클 ( 주 ) 제품지원실 목차 Performance Tuning 전고려사항 Performance Tuning Parameter 자주발견되는문제들 많은고객분들이 Oracle 9iAS 나 OAS 10g 를포함한각종 J2EE container

More information

MySQL-Ch05

MySQL-Ch05 MySQL P A R T 2 Chapter 05 Chapter 06 Chapter 07 Chapter 08 05 Chapter MySQL MySQL. (, C, Perl, PHP),. 5.1 MySQL., mysqldump, mysqlimport, mysqladmin, mysql. MySQL. mysql,. SQL. MySQL... MySQL ( ). MySQL,.

More information

05-class.key

05-class.key 5 : 2 (method) (public) (private) (interface) 5.1 (Method), (public method) (private method) (constructor), 3 4 5.2 (client). (receiver)., System.out.println("Hello"); (client object) (receiver object)

More information

PRO1_09E [읽기 전용]

PRO1_09E [읽기 전용] Siemens AG 1999 All rights reserved File: PRO1_09E1 Information and - ( ) 2 3 4 5 Monitor/Modify Variables" 6 7 8 9 10 11 CPU 12 Stop 13 (Forcing) 14 (1) 15 (2) 16 : 17 : Stop 18 : 19 : (Forcing) 20 :

More information

PowerPoint Presentation

PowerPoint Presentation Package Class 1 Heeseung Jo 목차 section 1 패키지개요와패키지의사용 section 2 java.lang 패키지의개요 section 3 Object 클래스 section 4 포장 (Wrapper) 클래스 section 5 문자열의개요 section 6 String 클래스 section 7 StringBuffer 클래스 section

More information

<4D F736F F F696E74202D20C1A63235C0E520B3D7C6AEBFF6C5A920C7C1B7CEB1D7B7A1B9D628B0ADC0C729205BC8A3C8AF20B8F0B5E55D>

<4D F736F F F696E74202D20C1A63235C0E520B3D7C6AEBFF6C5A920C7C1B7CEB1D7B7A1B9D628B0ADC0C729205BC8A3C8AF20B8F0B5E55D> Power Java 제 25 장네트워크프로그래밍 이번장에서학습할내용 네트워크프로그래밍의개요 URL 클래스 TCP를이용한통신 TCP를이용한서버제작 TCP를이용한클라이언트제작 UDP 를이용한통신 자바를이용하여서 TCP/IP 통신을이용하는응응프로그램을작성하여봅시다. 서버와클라이언트 서버 (Server): 사용자들에게서비스를제공하는컴퓨터 클라이언트 (Client):

More information

歯sql_tuning2

歯sql_tuning2 SQL Tuning (2) SQL SQL SQL Tuning ROW(1) ROW(2) ROW(n) update ROW(2) at time 1 & Uncommitted update ROW(2) at time 2 SQLDBA> @ UTLLOCKT WAITING_SESSION TYPE MODE_REQUESTED MODE_HELD LOCK_ID1

More information

ilist.add(new Integer(1))과 같이 사용하지 않고 ilist.add(1)과 같이 사용한 것은 자바 5.0에 추가된 기본 자료형과 해당 객체 자료 형과의 오토박싱/언박싱 기능을 사용한 것으로 오토박싱이란 자바 컴파일러가 객체를 요구하는 곳에 기본 자료형

ilist.add(new Integer(1))과 같이 사용하지 않고 ilist.add(1)과 같이 사용한 것은 자바 5.0에 추가된 기본 자료형과 해당 객체 자료 형과의 오토박싱/언박싱 기능을 사용한 것으로 오토박싱이란 자바 컴파일러가 객체를 요구하는 곳에 기본 자료형 바에 제네릭스(generics)를 도입하기 위한 연구는 이미 8년 전인 1996년부터라고 한다. 실제로 자바에 제네릭스를 도입하 는 몇 가지 방안들이 논문으로 나오기 시작한 것이 1998년 초임을 감 안하면 무려 8년이 지난 후에야 자바 5.0에 전격 채택되었다는 것은 이것이 얼마나 어려운 일이었나 하는 것을 보여준다. 자바의 스펙을 결정하는 표준화 절차인

More information

자바 프로그래밍

자바 프로그래밍 5 (kkman@mail.sangji.ac.kr) (Class), (template) (Object) public, final, abstract [modifier] class ClassName { // // (, ) Class Circle { int radius, color ; int x, y ; float getarea() { return 3.14159

More information

슬라이드 1

슬라이드 1 UNIT 16 예외처리 로봇 SW 교육원 3 기 최상훈 학습목표 2 예외처리구문 try-catch-finally 문을사용핛수있다. 프로그램오류 3 프로그램오류의종류 컴파일에러 (compile-time error) : 컴파일실행시발생 럮타임에러 (runtime error) : 프로그램실행시발생 에러 (error) 프로그램코드에의해서해결될수없는심각핚오류 ex)

More information

Sena Device Server Serial/IP TM Version

Sena Device Server Serial/IP TM Version Sena Device Server Serial/IP TM Version 1.0.0 2005. 3. 7. Release Note Revision Date Name Description V1.0.0 2005-03-7 HJ Jeon Serial/IP 4.3.2 ( ) 210 137-130, : (02) 573-5422 : (02) 573-7710 email: support@sena.com

More information

uFOCS

uFOCS 1 기 : 기 UF_D_V250_002 기 기 기 품 ufocs 기 v2.5.0 히기기기기기기기기기 기 Manual 기 version 기 3.2 기품 2011.7.29 히기 345-13 1 Tel : 02-857-3051 Fax : 02-3142-0319 : http://www.satu.co.kr 2010 SAT information Co., Ltd. All

More information

Data Sync Manager(DSM) Example Guide Data Sync Manager (DSM) Example Guide DSM Copyright 2003 Ari System, Inc. All Rights reserved. Data Sync Manager

Data Sync Manager(DSM) Example Guide Data Sync Manager (DSM) Example Guide DSM Copyright 2003 Ari System, Inc. All Rights reserved. Data Sync Manager Data Sync Manager (DSM) Example Guide DSM Copyright 2003 Ari System, Inc. All Rights reserved. Data Sync Manager are trademarks or registered trademarks of Ari System, Inc. 1 Table of Contents Chapter1

More information

목차 BUG 문법에맞지않는질의문수행시, 에러메시지에질의문의일부만보여주는문제를수정합니다... 3 BUG ROUND, TRUNC 함수에서 DATE 포맷 IW 를추가지원합니다... 5 BUG ROLLUP/CUBE 절을포함하는질의는 SUBQUE

목차 BUG 문법에맞지않는질의문수행시, 에러메시지에질의문의일부만보여주는문제를수정합니다... 3 BUG ROUND, TRUNC 함수에서 DATE 포맷 IW 를추가지원합니다... 5 BUG ROLLUP/CUBE 절을포함하는질의는 SUBQUE ALTIBASE HDB 6.3.1.10.1 Patch Notes 목차 BUG-45710 문법에맞지않는질의문수행시, 에러메시지에질의문의일부만보여주는문제를수정합니다... 3 BUG-45730 ROUND, TRUNC 함수에서 DATE 포맷 IW 를추가지원합니다... 5 BUG-45760 ROLLUP/CUBE 절을포함하는질의는 SUBQUERY REMOVAL 변환을수행하지않도록수정합니다....

More information

파일로입출력하기II - 파일출력클래스중에는데이터를일정한형태로출력하는기능을가지고있다. - PrintWriter와 PrintStream을사용해서원하는형태로출력할수있다. - PrintStream은구버전으로가능하면 PrintWriter 클래스를사용한다. PrintWriter

파일로입출력하기II - 파일출력클래스중에는데이터를일정한형태로출력하는기능을가지고있다. - PrintWriter와 PrintStream을사용해서원하는형태로출력할수있다. - PrintStream은구버전으로가능하면 PrintWriter 클래스를사용한다. PrintWriter 파일로입출력하기II - 파일출력클래스중에는데이터를일정한형태로출력하는기능을가지고있다. - PrintWriter와 PrintStream을사용해서원하는형태로출력할수있다. - PrintStream은구버전으로가능하면 PrintWriter 클래스를사용한다. PrintWriter 클래스의사용법은다음과같다. PrintWriter writer = new PrintWriter("output.txt");

More information

Mobile Service > IAP > Android SDK [ ] IAP SDK TOAST SDK. IAP SDK. Android Studio IDE Android SDK Version (API Level 10). Name Reference V

Mobile Service > IAP > Android SDK [ ] IAP SDK TOAST SDK. IAP SDK. Android Studio IDE Android SDK Version (API Level 10). Name Reference V Mobile Service > IAP > Android SDK IAP SDK TOAST SDK. IAP SDK. Android Studio IDE 2.3.3 Android SDK Version 2.3.3 (API Level 10). Name Reference Version License okhttp http://square.github.io/okhttp/ 1.5.4

More information

강의 개요

강의 개요 DDL TABLE 을만들자 웹데이터베이스 TABLE 자료가저장되는공간 문자자료의경우 DB 생성시지정한 Character Set 대로저장 Table 생성시 Table 의구조를결정짓는열속성지정 열 (Clumn, Attribute) 은이름과자료형을갖는다. 자료형 : http://dev.mysql.cm/dc/refman/5.1/en/data-types.html TABLE

More information

ALTIBASE HDB Patch Notes

ALTIBASE HDB Patch Notes ALTIBASE HDB 6.3.1.10.6 Patch Notes 목차 BUG-45060 offline replication start 와 replication drop 을동시에수행하는경우, replication start 가완료되지않았으면 replication drop 을수행하지못하도록수정하였습니다... 4 BUG-46193 메모리테이블의이중화병렬 sync

More information

The Self-Managing Database : Automatic Health Monitoring and Alerting

The Self-Managing Database : Automatic Health Monitoring and Alerting The Self-Managing Database : Automatic Health Monitoring and Alerting Agenda Oracle 10g Enterpirse Manager Oracle 10g 3 rd Party PL/SQL API Summary (Self-Managing Database) ? 6% 6% 12% 55% 6% Source: IOUG

More information

Microsoft PowerPoint - Java7.pptx

Microsoft PowerPoint - Java7.pptx HPC & OT Lab. 1 HPC & OT Lab. 2 실습 7 주차 Jin-Ho, Jang M.S. Hanyang Univ. HPC&OT Lab. jinhoyo@nate.com HPC & OT Lab. 3 Component Structure 객체 (object) 생성개념을이해한다. 외부클래스에대한접근방법을이해한다. 접근제어자 (public & private)

More information

PowerPoint 프레젠테이션

PowerPoint 프레젠테이션 Synergy EDMS www.comtrue.com opyright 2001 ComTrue Technologies. All right reserved. - 1 opyright 2001 ComTrue Technologies. All right reserved. - 2 opyright 2001 ComTrue Technologies. All right reserved.

More information

14-Servlet

14-Servlet JAVA Programming Language Servlet (GenericServlet) HTTP (HttpServlet) 2 (1)? CGI 3 (2) http://jakarta.apache.org JSDK(Java Servlet Development Kit) 4 (3) CGI CGI(Common Gateway Interface) /,,, Client Server

More information