facelog 是一个用于人脸识别验证的跨平台跨语言的开发框架，其核心是一个基于 thrift 技术的 RPC 服务

# 说明 本项目的数据库访问代码(ORM)由[sqlj2ava](https://gitee.com/l0km/sql2java)工具生成。 # 建表语句 sql/create_table.sql MySQL数据库建表脚本 gen-sql.xml Maven脚本执行 create_table.sql 使用示例如下(需要先启动msqyl数据库): create_table.bat -Ddb.url=jdbc:mysql://localhost:3306/test?characterEncoding=utf8 # 如果不指定 db.url参数，则使用默认本地数据库实例(参见pom.xml中db.url定义) # 生成代码 > 运行要求： JDK 1.7 or 1.8, Maven 3.5.0 or above,mysql 5.6(or above) running - gen-mysql.sh gen-mysql.bat 用于生成接口层代码的简单脚本 - gen-mysql.properties sql2java生成接口层代码的配置文件,执行脚本前务必确认文件中jdbc.drive,jdbc.url,jdbc.username,jdbc.password,jdbc.schema等参数正确配置 使用示例如下: $ gen-mysql.bat [INFO] Scanning for projects... [INFO] ------------------------------------------------------------------------ [INFO] Reactor Build Order: [INFO] [INFO] facelog-db2 [INFO] facelog-db2-base [INFO] [INFO] ------------------------------------------------------------------------ [INFO] Building facelog-db2 2.5.2-SNAPSHOT [INFO] ------------------------------------------------------------------------ [INFO] [INFO] --- sql2java-maven-plugin:1.0.6-SNAPSHOT:generate (default-cli) @ facelog-db2 --- database properties initialization [INFO] classpath: [file:/J:/facelog/db2/lib/mysql-connector-java-5.1.43-bin.jar] Connecting to root on jdbc:mysql://localhost:3306/test?characterEncoding=utf8&useInformationSchema=true ... Connected. Database server :MySQL. Loading table list according to pattern fl_% ... table fl_device found table fl_device_group found table fl_face found table fl_feature found table fl_image found table fl_log found table fl_permit found table fl_person found table fl_person_group found table fl_store found table fl_log_light found samePrefix = [fl_] Loading columns ... fl_device.id INT AUTOINCREMENT default value: null fl_device.group_id INT default value: 1 fl_device.name VARCHAR default value: null fl_device.product_name VARCHAR default value: null fl_device.model VARCHAR default value: null fl_device.vendor VARCHAR default value: null fl_device.manufacturer VARCHAR default value: null fl_device.made_date DATE default value: null fl_device.version VARCHAR default value: null fl_device.used_sdks VARCHAR default value: null fl_device.serial_no VARCHAR default value: null fl_device.mac CHAR default value: null fl_device.direction INT default value: null fl_device.remark VARCHAR default value: null fl_device.ext_bin BLOB default value: null fl_device.ext_txt TEXT default value: null fl_device.create_time TIMESTAMP default value: CURRENT_TIMESTAMP fl_device.update_time TIMESTAMP default value: CURRENT_TIMESTAMP fl_device found 18 columns fl_device_group.id INT AUTOINCREMENT default value: null fl_device_group.name VARCHAR default value: null fl_device_group.leaf TINYINT default value: null fl_device_group.parent INT default value: null fl_device_group.root_group INT default value: null fl_device_group.schedule VARCHAR default value: null fl_device_group.remark VARCHAR default value: null fl_device_group.ext_bin BLOB default value: null fl_device_group.ext_txt TEXT default value: null fl_device_group.create_time TIMESTAMP default value: CURRENT_TIMESTAMP fl_device_group.update_time TIMESTAMP default value: CURRENT_TIMESTAMP fl_device_group found 11 columns fl_face.id INT AUTOINCREMENT default value: null fl_face.image_md5 CHAR default value: null fl_face.face_left INT default value: null fl_face.face_top INT default value: null fl_face.face_width INT default value: null fl_face.face_height INT default value: null fl_face.eye_leftx INT default value: null fl_face.eye_lefty INT default value: null fl_face.eye_rightx INT default value: null fl_face.eye_righty INT default value: null fl_face.mouth_x INT default value: null fl_face.mouth_y INT default value: null fl_face.nose_x INT default value: null fl_face.nose_y INT default value: null fl_face.angle_yaw INT default value: null fl_face.angle_pitch INT default value: null fl_face.angle_roll INT default value: null fl_face.ext_info BLOB default value: null fl_face.feature_md5 CHAR default value: null fl_face found 19 columns fl_feature.md5 CHAR default value: null fl_feature.version VARCHAR default value: null fl_feature.person_id INT default value: null fl_feature.feature BLOB default value: null fl_feature.update_time TIMESTAMP default value: CURRENT_TIMESTAMP fl_feature found 5 columns fl_image.md5 CHAR default value: null fl_image.format VARCHAR default value: null fl_image.width INT default value: null fl_image.height INT default value: null fl_image.depth INT default value: 0 fl_image.face_num INT default value: 0 fl_image.thumb_md5 CHAR default value: null fl_image.device_id INT default value: null fl_image found 8 columns fl_log.id INT AUTOINCREMENT default value: null fl_log.person_id INT default value: null fl_log.device_id INT default value: null fl_log.verify_feature CHAR default value: null fl_log.compare_face INT default value: null fl_log.verify_status TINYINT default value: null fl_log.similarty DOUBLE default value: null fl_log.direction INT default value: null fl_log.verify_time TIMESTAMP default value: CURRENT_TIMESTAMP fl_log.create_time TIMESTAMP default value: CURRENT_TIMESTAMP fl_log found 10 columns fl_permit.device_group_id INT default value: null fl_permit.person_group_id INT default value: null fl_permit.schedule VARCHAR default value: null fl_permit.pass_limit VARCHAR default value: null fl_permit.remark VARCHAR default value: null fl_permit.ext_bin BLOB default value: null fl_permit.ext_txt TEXT default value: null fl_permit.create_time TIMESTAMP default value: CURRENT_TIMESTAMP fl_permit found 8 columns fl_person.id INT AUTOINCREMENT default value: null fl_person.group_id INT default value: 1 fl_person.name VARCHAR default value: null fl_person.sex TINYINT default value: null fl_person.rank TINYINT default value: null fl_person.password CHAR default value: null fl_person.birthdate DATE default value: null fl_person.mobile_phone CHAR default value: null fl_person.papers_type TINYINT default value: null fl_person.papers_num VARCHAR default value: null fl_person.image_md5 CHAR default value: null fl_person.expiry_date DATE default value: 2050-12-31 fl_person.activated_date DATE default value: null fl_person.remark VARCHAR default value: null fl_person.ext_bin BLOB default value: null fl_person.ext_txt TEXT default value: null fl_person.create_time TIMESTAMP default value: CURRENT_TIMESTAMP fl_person.update_time TIMESTAMP default value: CURRENT_TIMESTAMP fl_person found 18 columns fl_person_group.id INT AUTOINCREMENT default value: null fl_person_group.name VARCHAR default value: null fl_person_group.leaf TINYINT default valu