FileMaker ODBC and JDBC Guide

Transcription

1 FileMaker 14

2

3

4

5

6

7

8 1 1

9

10 6. INSERTUPDATEDELETE SELECT

11

12

13

14 localhost

15

16 localhost

17 SQL_C_CHARSQL_C_WCHAR

18

19

20

21

22 java - version

23

24

25 jdbcsubprotocol filemakersubname 1. 2.

26 3. import java.sql.*; class FMPJDBCTest { } public static void main(string[ ] args) { } // JDBC 클라이언트 드라이버 등록 try { Driver d = (Driver)Class.forName("com.filemaker.jdbc.Driver").newInstance(); } catch(exception e) { System.out.println(e); } // FileMaker 와의 연결 설정 Connection con; try { con = DriverManager.getConnection( jdbc:filemaker:// /mydataba se, username, password ); } catch(exception e) { System.out.println(e); } // 연결 경고 가져오기 SQLWarning warning = null; try { warning = con.getwarnings(); if (warning == null) { System.out.println("No warnings"); return; } while (warning!= null) { System.out.println("Warning: "+warning); warning = warning.getnextwarning(); } } catch (Exception e) { Sysem.out.println(e); }

27 1 1 jdbc:filemaker:// /publications jdbc:filemaker:// /customers?user=collections&password=admin jdbc:filemaker://localhost/sales_db?user=ad&min&password=admin jdbc:filemaker://localhost/sales_db?user=admin1&password=ad&min

28

29 SQL_VARCHAR SQL_DOUBLE SQL_DATE SQL_TIME SQL_TIMESTAMP

30 BLOB SQL_LONGVARBINARY SELECTCAST() GetAs() INSERT INTO mytable(repfield[3]) VALUES ( this is rep 3 ) SELECT repfield[1], repfield[2] FROM mytable java.sql.types.varchar java.sql.types.double java.sql.types.date java.sql.types.time java.sql.types.timestamp java.sql.types.blob

31

32 , ,

33 , 10 6, ,

34 5 12, ,