package com.casic.birmm;

import com.casic.birmm.util.ByteUtil;
import com.casic.birmm.util.ConnectionManager;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.ArrayListHandler;
import org.apache.log4j.Logger;

import java.sql.Connection;
import java.util.List;

public class ExtractPersonDataFromMySQL {
    public static void main(String[] args) {
        Connection conn = null;
        Logger logger = Logger.getLogger(ExtractPersonDataFromMySQL.class.getName());

        String queryStr = "select name, sex, simplename, p.ID_CARD_NO, " +
                "left_iris_code1, right_iris_code1, LEFT_IRIS_CODE2, RIGHT_IRIS_CODE2, LEFT_IRIS_CODE3, RIGHT_IRIS_CODE3 " +
                "from sys_person p, iris_data i, sys_dept d where p.id = i.PERSON_ID and p.DEPTID = d.id and p.name='刘栋' order by SIMPLENAME, p.ID";

        try {
            conn = ConnectionManager.getMySQLConnectionFromC3P0();
            conn.setAutoCommit(false);

            QueryRunner runner = new QueryRunner();
            List<Object[]> tempList = (List<Object[]>) runner.query(conn, queryStr, new ArrayListHandler());

            System.out.println(tempList.size());
            for (int i = 0; i < tempList.size(); i++) {
                Object[] person = tempList.get(i);
                String content = "";
                content += person[0] + "\t";

                if (person[1].equals("1")) {
                    content += "男" + "\t";
                } else {
                    content += "女" + "\t";
                }

                content += person[2] + "\t" + person[3];
                logger.info(content);

                String leftIris1 = "";
                if (person[4] != null) {
                    leftIris1 = ByteUtil.binToHexString((byte[]) person[4]);
                }
                logger.info("left1: " + leftIris1);

                String rightIris1 = "";
                if (person[5] != null) {
                    rightIris1 = ByteUtil.binToHexString((byte[]) person[5]);
                }
                logger.info("right1: " + rightIris1);

                String leftIris2 = "";
                if (person[6] != null) {
                    leftIris2 = ByteUtil.binToHexString((byte[]) person[6]);
                }
                logger.info("left2: " + leftIris2);

                String rightIris2 = "";
                if (person[7] != null) {
                    rightIris2 = ByteUtil.binToHexString((byte[]) person[7]);
                }
                logger.info("right2: " + rightIris2);

                String leftIris3 = "";
                if (person[8] != null) {
                    leftIris3 = ByteUtil.binToHexString((byte[]) person[8]);
                }
                logger.info("left3: " + leftIris3);

                String rightIris3 = "";
                if (person[9] != null) {
                    rightIris3 = ByteUtil.binToHexString((byte[]) person[9]);
                }
                logger.info("right3: " + rightIris3);

                logger.info("\n");
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }
}