package fmjdbc;
import java.sql.*;
class FilemakerJDBCTest {
public static void main(String[ ] args) {
// EDIT FOR YOUR SYSTEM
// --------------------------------------
String fmsHostname = "localhost";
String fmFilename = "联系人";
String fmUser = "Admin";
String fmPassword = "web123456";
// -------------------------------------
// END OF EDITABLE SECTION
// 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 = null;
try {
con = DriverManager.getConnection("jdbc:filemaker://" + fmsHostname + "/" + fmFilename, fmUser, fmPassword);
} catch(Exception e) {
System.out.println(e);
}
// get connection warnings
SQLWarning warning = null;
try {
warning = con.getWarnings();
DatabaseMetaData metaData = con.getMetaData();
if (warning == null) {
System.out.println("No warnings");
return;
}
while (warning != null) {
System.out.println("Warning: "+warning);
warning = warning.getNextWarning();
}
} catch (Exception e) {
System.out.println(e);
}
}
}