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 1 1 1 1 1 1 1 1 1 1 1 1 http://www.filemaker.com/documentation/ko
1 1 1 1 1 1
1 1 1 1 1
1 1 http://www.filemaker.com/documentation/ko
1. 2. 3. 4. 1 1 5.
6. INSERTUPDATEDELETE SELECT
1 1 1 http://help.filemaker.com 1. 2. 3. 4. 5. 6.
http://www.filemaker.com/kr/support/index.html http://www.filemaker.com/kr/products/filemakerserver/server-14-specifications.html 1 1 1. 1 1 2. 3.
4. 1 1 5. 6. 1 1 1
1. 2. 3. 4. 5. 6. 1 localhost127.0.0.1 1 7. 1
1 1 8. 1 1 1. 1 1 2. 3. 4. 5. 6.
http://www.odbcmanager.net 1. 2. 3. 4. 5. 6. 7. 1 localhost127.0.0.1 1 8. 1
SQL_C_CHARSQL_C_WCHAR 1 1 9. 1 1
1 1 1 1 1 1. 2.
3. 4. 5. 1. 2. 3. 4. 5. 6. 1 1
1 1 1. 2. 3. 4. 5. 6. 1 1 1 1
http://www.filemaker.com/kr/support/index.html java - version 1. 1 1 1 2. 3. 4. 1 1
1 1 1 1 1 1
1 1 1 1 jdbcsubprotocol filemakersubname 1. 2.
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://192.168.1.1/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); }
1 1 jdbc:filemaker://192.168.1.1/publications jdbc:filemaker://192.168.1.1/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
1 1 1 1
1 1 1 1 1 1 1 1 1 1 1 1 SQL_VARCHAR SQL_DOUBLE SQL_DATE SQL_TIME SQL_TIMESTAMP
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
1 1 1 1
23 16 13 16 13 12 15 13 16 13 30 12 15 13 24 30 30 24 29 25 30 30 21 20 8 9, 10 15 13 5 27 21 20 7 5 30 29 29 29 29 29 29 29 12 12, 22 22 24 31 24 25 24 25 25 25 30 28 25 25 24 25 7 11 29 30 18 31
16 21 16 21 9 14 20 13 29 29 21 20 19 19 11 16 22 21 5 24 24 24 11 9, 10 6, 9 29 29 30 29 29 29 29 29 29 31 29 29 8 30 30 30 20 22 20 25 19 31 19 7 6 19 19 8 8 28 27 21 20 21 20 7 30 29 27 21 20 8 10 9, 10 30 29 29 30 25
5 12, 22 6 22 12 19 27 20, 21 20 31 5 9 11 7 5 24 28 21 20 29 30 30 5 28 21 20 19 7 30 29 23 16 13