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 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
1 1 1 1 1 1
1 1 1 1 1
1. 2. 3.
4. 1 1 5. 6. INSERTUPDATEDELETE SELECT
1 Oracle 11g 1 SQL Server 2008 R2 1 SQL Server 2012 1 MySQL 5.5 1. 2. 3. 4. 5. 6.
1 1 1 1 1
1. 1 1 2. 3. 4. 1 1 5. 6. 1 1 1
1. 2. 1. 2. 3. 4. 5.
6. 1 localhost127.0.0.1 1 7. 1 1 8. 1 1
1. 1 1 2. 3. 4. 5. 6. 1. 2. 3.
4. 5. 6. 1 localhost127.0.0.1 1 7. 1 1 1 SQL_C_CHARSQL_C_WCHAR 1
8. 1 1
1 1 1 1 1 1. 2.
3. 4. 5. 1. 2.
1. 2. 3. 4. 5. 127.0.0.1localhost 6. 1 1 7. 8.
1. 2. 3. 4. 5. 6. 1 1 1 1
1. 2. 3. 4. 5. 6. 7. 127.0.0.1localhost 8. 1 1 1 SQL_C_CHARSQL_C_WCHAR
1 9. 10. 1. 2. 3. 4. 5. 6. 1 1 1 1
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) { } // register the JDBC client driver try { Driver d = (Driver)Class.forName("com.filemaker.jdbc.Driver").newInstance(); } catch(exception e) { System.out.println(e); } // establish a connection to FileMaker Connection con; try { con = DriverManager.getConnection( jdbc:filemaker://192.168.1.1/mydataba se, username, password ); } catch(exception e) { System.out.println(e); } // get connection warnings 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 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
29 33 29 29 23 21 8 10 31 23 21 7 5 33 26 28 35 28 29 33 29 29 29 34 32 29 29 29 33 34 19 35 25 24 33 33 25 23 20 23 26 25 12 28 29 28 10 35 21 26 23 12
20, 29, 35 20 7 20 20 20 8 8 31 32 23 25 21 23 7 34 33 22 8 31 23 21 10 34 33 34 29 24 12, 26 12, 26 23, 25 31 21 35 7 28 28 32 25 23 28 34 33 5 32 25 23 20 7 27 34 33 22, 24 20