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 java.sql.Connection;
import java.util.List;

public class Main {

    public static void main(String[] args) {
        Connection conn = null;

        System.out.println("3333333");

        String queryStr = "SELECT IId, Id, Name, Gender, Department, IDCardNo, LIrisCodeData, RIrisCodeData, LIrisCodeData2, RIrisCodeData2, LIrisCodeData3, RIrisCodeData3 FROM IRIS_DEVICE.dbo.person where Name='余璨译'";

        try {
            conn = ConnectionManager.getSQLServerConnectionFromC3P0();
            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.get(0).length; i++) {
                if (i < 2) {
                    System.out.println(tempList.get(0)[i]);
                } else {
                    System.out.println(ByteUtil.binToHexString((byte[] )tempList.get(0)[i]));
                }
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }
}