2秒统计一亿数据

题目如下：

1、生成两个文件：
1）文件名Person.txt
字段：
personid，long，主键
name，string，内容随机
记录条数 1千万条
格式：txt，csv或者二进制，都可以。

2）文件名Order.txt
字段：
orderid，long，主键
personid，long，外键，内容必须在Person.txt里面，取值随机
amount，double，金额，数值随机
记录条数 1亿条，personid的模拟尽量均匀
格式：txt，csv或者二进制，都可以。

2、写程序以刚才生成的文件为依据，读取其内容，统计出等同与以下语句的一组数据，并写入文件 sqlresult.txt
1）给定一个person name ，SELECT o.amount FROM person p,order o WHERE o.personid=p. personid AND p.name=? ORDER BY o.amount limit 1000
2）SELECT p.name, sum(o.amount) sum, count(*) from person p,order o where o.personid=p. personid group by o.personid order by sum limit 1000 【选做】

Java要求：-Xmx1024m，即JVM最大内存超过1G
.NET要求在32位机器上跑。
开发要求：可以使用任何开源组件，包括单机数据库，但不允许使用SQL语句。

1、程序运行时间：

    1）本机时间测试：

    按名称查询：50ms左右

    汇总查询：2000ms左右

    2）局域网测试

    按名称查询：13573ms

    汇总查询：287162ms（5分钟左右，建议把文件Copy到本机）

   

2、文件构成：

    1）存储方式

    二进制，按位存储

    2）文件构成（共5个文件）

    person.nk：                 Person信息（190M），           ID：long（8），Name：String（12）

    person.nk.name：       Person索引文件（190M），    Name、PersonID

    order.nk：                    订单信息（2.23G），                ID：long（8），PersonID：long（8），Amount：double（8）

    order.nk.personid：     订单索引文件（1.48G），        personID，OrderID

    order.nk.amount：       订单索引文件（1.48G），        PersonID，Amount

3、设计思路：

    1）按照名称查询订单信息说明：

    因为person有1千万条，Order有1亿条，平均每人有10个订单；

    首先根据名称查询PersonID：person.nk.name，根据名称排序，二分法查找；

    然后再根据PersonID查询金额：order.nk.personid，根据PersonID排序，二分法查找订单；

    2）查询汇总信息：

    循环订单，统计金额和数量。

    直接查询order.nk文件，因为文件比较大，会花费大量的时间，所以创建PersonID和金额的索引，按PersonID排序，就可以统计出需要的结果。

源码：

test.java

import java.util.ArrayList;
import java.util.List;

public class test {

    public static void main(String[] args) {

        //测试名称（也可通过 PersonOperate.printPersonData(); 打印所有人员）
        // Id:233745 Name:尉全平
        // Id:233746 Name:汪哲宁
        // Id:233747 Name:宦英凡
        // Id:233748 Name:余彪朗
        // Id:233749 Name:贾栋信
        // Id:233750 Name:秋泽波
        // Id:233751 Name:司栋固
        // Id:233752 Name:黎苑芬
        // Id:233753 Name:吉士天
        // Id:233754 Name:轩兰兰
        // Id:233755 Name:西冰凤
        // Id:233756 Name:冀克新
        // Id:233757 Name:梁韵婵
        // Id:233758 Name:吉兰琳
        // Id:233759 Name:齐艳纨
        // Id:233760 Name:马枫聪
        // Id:233761 Name:阙菊婉


        //如有重名，默认取第一个人员，请通过 PersonOperate.getPersonsByName("东楠固") 方法确认
        PersonOperate.printOrderByPersonName("支浩毅", 1000, true);

        OrderOperate.printTop1000SumData(1000, true);



    }

}

PersonOperate.java

import java.io.File;
import java.io.IOException;
import java.io.RandomAccessFile;
import java.nio.MappedByteBuffer;
import java.nio.channels.FileChannel;
import java.util.ArrayList;
import java.util.Collections;
import java.util.Comparator;
import java.util.List;

public class PersonOperate {

    /**
     * 单条插入
     *
     * @param person
     */
    public static void insert(Person person) {

        File file = new File(CommonFunc.psnPath);
        long fileLen = file.length();

        RandomAccessFile raf = null;
        try {
            raf = new RandomAccessFile(file, "rw");

            long id = person.getPersonId();
            byte[] idByte = CommonFunc.getBytes(id);
            String name = person.getName();
            byte[] nameByte = CommonFunc.getBytes(name, CommonFunc.nameLen);

            byte[] idNameByte = new byte[CommonFunc.psnIdLen + CommonFunc.nameLen];
            System.arraycopy(idByte, 0, idNameByte, 0, CommonFunc.psnIdLen);
            System.arraycopy(nameByte, 0, idNameByte, CommonFunc.psnIdLen, CommonFunc.nameLen);

            raf.seek(fileLen);
            raf.write(idNameByte);

        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        } finally {
            if (null != raf) {
                try {
                    raf.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
        }
    }

    /**
     * 批量插入
     *
     * @param personList
     */
    public static void batchInsert(Person[] personList) {

        File file = new File(CommonFunc.psnPath);
        long fileLen = file.length();

        RandomAccessFile raf = null;
        try {
            byte[] idNameBytes = new byte[(CommonFunc.psnIdLen + CommonFunc.nameLen) * personList.length];
            for (int i = 0; i < personList.length; i++) {
                Person person = personList[i];

                long id = person.getPersonId();
                byte[] idByte = CommonFunc.getBytes(id);
                String name = person.getName();
                byte[] nameByte = CommonFunc.getBytes(name, CommonFunc.nameLen);

                System.arraycopy(idByte, 0, idNameBytes, i * (CommonFunc.psnIdLen + CommonFunc.nameLen), CommonFunc.psnIdLen);
                System.arraycopy(nameByte, 0, idNameBytes, i * (CommonFunc.psnIdLen + CommonFunc.nameLen) + CommonFunc.psnIdLen, CommonFunc.nameLen);
            }

            raf = new RandomAccessFile(file, "rw");
            raf.seek(fileLen);
            raf.write(idNameBytes);
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        } finally {
            if (null != raf) {
                try {
                    raf.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
        }
    }

    /**
     * 根据ID查对象
     *
     * @param personId
     * @return
     */
    public static Person getPersonById(long personId) {
        Person rtn = new Person();

        File file = new File(CommonFunc.psnPath);
        //获取位置
        long pos = (personId - 1) * (CommonFunc.psnIdLen + CommonFunc.nameLen);

        RandomAccessFile raf = null;
        try {
            raf = new RandomAccessFile(file, "r");

            raf.seek(pos);
            rtn.setPersonId(raf.readLong());
            pos += CommonFunc.psnIdLen;

            raf.seek(pos);
            byte[] nameByte = new byte[CommonFunc.nameLen];
            raf.read(nameByte);
            rtn.setName(CommonFunc.getString(nameByte));
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        } finally {
            if (null != raf) {
                try {
                    raf.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
        }

        return rtn;
    }

    /**
     * 根据名字查询Person对象
     *
     * @param name
     * @return
     */
    public static List<Person> getPersonsByName(String name) {
        List<Person> rtn = new ArrayList<>();

        //获取要查询的ID列表
        File idxFile = new File(CommonFunc.psnIdxPath);
        long fileLen = idxFile.length();
        long rowNum = fileLen / (CommonFunc.psnIdLen + CommonFunc.nameLen);

        FileChannel idxFileChannel = null;
        try {
            idxFileChannel = new RandomAccessFile(idxFile, "r").getChannel();
            MappedByteBuffer idxMappedByteBuffer = idxFileChannel.map(FileChannel.MapMode.READ_ONLY, 0, idxFile.length());

            byte[] nameBytes = CommonFunc.getBytes(name, 12);
            long firstNameNum = CommonFunc.getLong(new byte[]{0, 0, 0, 0, 0, nameBytes[0], nameBytes[1], nameBytes[2]});

            //二分法查找，确定位置
            long findRow = -1;
            long minRow = 1;
            long maxRow = rowNum;
            while (maxRow >= minRow) {
                long midRow = (minRow + maxRow) / 2;
                idxMappedByteBuffer.position((int) (midRow - 1) * (CommonFunc.psnIdLen + CommonFunc.nameLen));
                byte[] nameByte = new byte[CommonFunc.nameLen];
                idxMappedByteBuffer.get(nameByte);
                long tempFirstNameNum = CommonFunc.getLong(new byte[]{0, 0, 0, 0, 0, nameByte[0], nameByte[1], nameByte[2]});

                if (tempFirstNameNum > firstNameNum) {
                    if (maxRow == midRow) {
                        break;
                    }
                    maxRow = midRow;
                } else if (tempFirstNameNum < firstNameNum) {
                    if (minRow == midRow) {
                        minRow++;
                        continue;
                    }
                    minRow = midRow;
                } else {
                    findRow = midRow - 1;
                    break;
                }
            }

            if (findRow == -1) {
                return rtn;
            }

            //前后搜索，确定该数据的最大行和最小行
            long minRowIndex = 0;
            while ((findRow - minRowIndex) >= 0) {
                idxMappedByteBuffer.position((int) (findRow - minRowIndex) * (CommonFunc.psnIdLen + CommonFunc.nameLen));
                byte[] nameByte = new byte[CommonFunc.nameLen];
                idxMappedByteBuffer.get(nameByte);
                String tempName = CommonFunc.getString(nameByte);
                long tempFirstNameNum = CommonFunc.getLong(new byte[]{0, 0, 0, 0, 0, nameByte[0], nameByte[1], nameByte[2]});

                if (tempFirstNameNum != firstNameNum) {
                    break;
                }

                if (tempName.equals(name) == true) {
                    idxMappedByteBuffer.position((int) (findRow - minRowIndex) * (CommonFunc.psnIdLen + CommonFunc.nameLen) + CommonFunc.nameLen);
                    long personId = idxMappedByteBuffer.getLong();

                    Person person = new Person();
                    person.setPersonId(personId);
                    person.setName(tempName);
                    rtn.add(person);
                }
                minRowIndex++;
            }

            long maxRowIndex = 1;
            while ((findRow + maxRowIndex) <= rowNum) {
                idxMappedByteBuffer.position((int) (findRow + maxRowIndex) * (CommonFunc.psnIdLen + CommonFunc.nameLen));
                byte[] nameByte = new byte[CommonFunc.nameLen];
                idxMappedByteBuffer.get(nameByte);
                String tempName = CommonFunc.getString(nameByte);
                long tempFirstNameNum = CommonFunc.getLong(new byte[]{0, 0, 0, 0, 0, nameByte[0], nameByte[1], nameByte[2]});

                if (tempFirstNameNum != firstNameNum) {
                    break;
                }

                if (tempName.equals(name) == true) {
                    idxMappedByteBuffer.position((int) (findRow + maxRowIndex) * (CommonFunc.psnIdLen + CommonFunc.nameLen) + CommonFunc.nameLen);
                    long personId = idxMappedByteBuffer.getLong();

                    Person person = new Person();
                    person.setPersonId(personId);
                    person.setName(tempName);
                    rtn.add(person);
                }

                maxRowIndex++;
            }
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        } finally {
            if (null != idxFileChannel) {
                try {
                    idxFileChannel.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
        }

        return rtn;
    }

    public static List<Person> getPersonsByName_bak(String name) {
        List<Person> rtn = new ArrayList<>();

        File file = new File(CommonFunc.psnPath);
        long fileLen = file.length();
        long rowNum = fileLen / (CommonFunc.psnIdLen + CommonFunc.nameLen);

        RandomAccessFile raf = null;
        try {
            raf = new RandomAccessFile(file, "r");
            for (int i = 0; i < rowNum; i++) {
                Person person = new Person();
                raf.seek(i * (CommonFunc.psnIdLen + CommonFunc.nameLen));
                person.setPersonId(raf.readLong());

                raf.seek(i * (CommonFunc.psnIdLen + CommonFunc.nameLen) + CommonFunc.psnIdLen);
                byte[] nameByte = new byte[CommonFunc.nameLen];
                raf.read(nameByte);
                String pName = CommonFunc.getString(nameByte);
                person.setName(pName);

                if (name.equals(pName) == true) {
                    rtn.add(person);
                }
            }
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        } finally {
            if (null != raf) {
                try {
                    raf.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
        }

        return rtn;
    }

    public static List<Person> getPersonsByName_bak2(String name) {
        List<Person> rtn = new ArrayList<>();

        //获取要查询的ID列表
        File idxFile = new File(CommonFunc.psnIdxPath);
        long fileLen = idxFile.length();
        long rowNum = fileLen / (CommonFunc.psnIdLen + CommonFunc.nameLen);

        RandomAccessFile idxRaf = null;
        try {
            idxRaf = new RandomAccessFile(idxFile, "r");

            byte[] nameBytes = CommonFunc.getBytes(name, 12);
            long firstNameNum = CommonFunc.getLong(new byte[]{0, 0, 0, 0, 0, nameBytes[0], nameBytes[1], nameBytes[2]});

            //二分法查找，确定位置
            long findRow = -1;
            long minRow = 1;
            long maxRow = rowNum;
            while (maxRow >= minRow) {
                long midRow = (minRow + maxRow) / 2;
                idxRaf.seek((midRow - 1) * (CommonFunc.psnIdLen + CommonFunc.nameLen));
                byte[] nameByte = new byte[CommonFunc.nameLen];
                idxRaf.read(nameByte);
                long tempFirstNameNum = CommonFunc.getLong(new byte[]{0, 0, 0, 0, 0, nameByte[0], nameByte[1], nameByte[2]});

                if (tempFirstNameNum > firstNameNum) {
                    if (maxRow == midRow) {
                        break;
                    }
                    maxRow = midRow;
                } else if (tempFirstNameNum < firstNameNum) {
                    if (minRow == midRow) {
                        minRow++;
                        continue;
                    }
                    minRow = midRow;
                } else {
                    findRow = midRow - 1;
                    break;
                }
            }

            if (findRow == -1) {
                return rtn;
            }

            //前后搜索，确定该数据的最大行和最小行
            long minRowIndex = 0;
            while ((findRow - minRowIndex) >= 0) {
                idxRaf.seek((findRow - minRowIndex) * (CommonFunc.psnIdLen + CommonFunc.nameLen));
                byte[] nameByte = new byte[CommonFunc.nameLen];
                idxRaf.read(nameByte);
                String tempName = CommonFunc.getString(nameByte);
                long tempFirstNameNum = CommonFunc.getLong(new byte[]{0, 0, 0, 0, 0, nameByte[0], nameByte[1], nameByte[2]});

                if (tempFirstNameNum != firstNameNum) {
                    break;
                }

                if (tempName.equals(name) == true) {
                    idxRaf.seek((findRow - minRowIndex) * (CommonFunc.psnIdLen + CommonFunc.nameLen) + CommonFunc.nameLen);
                    byte[] idByte = new byte[CommonFunc.psnIdLen];
                    idxRaf.read(idByte);
                    long personId = CommonFunc.getLong(idByte);

                    Person person = getPersonById(personId);
                    rtn.add(person);
                }
                minRowIndex++;
            }

            long maxRowIndex = 1;
            while ((findRow + maxRowIndex) <= rowNum) {
                idxRaf.seek((findRow + maxRowIndex) * (CommonFunc.psnIdLen + CommonFunc.nameLen));
                byte[] nameByte = new byte[CommonFunc.nameLen];
                idxRaf.read(nameByte);
                String tempName = CommonFunc.getString(nameByte);
                long tempFirstNameNum = CommonFunc.getLong(new byte[]{0, 0, 0, 0, 0, nameByte[0], nameByte[1], nameByte[2]});

                if (tempFirstNameNum != firstNameNum) {
                    break;
                }

                if (tempName.equals(name) == true) {
                    idxRaf.seek((findRow + maxRowIndex) * (CommonFunc.psnIdLen + CommonFunc.nameLen) + CommonFunc.nameLen);
                    byte[] idByte = new byte[CommonFunc.psnIdLen];
                    idxRaf.read(idByte);
                    long personId = CommonFunc.getLong(idByte);

                    Person person = getPersonById(personId);
                    rtn.add(person);
                }

                maxRowIndex++;
            }
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        } finally {
            if (null != idxRaf) {
                try {
                    idxRaf.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
        }

        return rtn;
    }

    /**
     * 创建名称索引
     * <p/>
     * 每个字符占3个字节，取Int值，占4个字节
     * 3个字符，进行相加，然后进行排序
     * <p/>
     * 1个字节的最大值为 256*256*256 = 16777216
     * 3个字节的最大值为 16777216 * 3 = 50331648
     * <p/>
     * 如：孙(15052185)天(15049897)天(15049897):45151979
     */
    public static void createfirstNameIndex() {

        long totalStartTime = System.currentTimeMillis();
        //1、创建临时文件
        System.out.println("开始创建临时文件");
        long startTime = System.currentTimeMillis();

        createTempFile();

        long endTime = System.currentTimeMillis();
        System.out.println("程序运行时间： " + (endTime - startTime) + "ms");
        System.out.println("临时文件创建完成");

        //2、整理临时文件
        System.out.println("整理临时文件");
        startTime = System.currentTimeMillis();

        fillTempFile();

        endTime = System.currentTimeMillis();
        System.out.println("程序运行时间： " + (endTime - startTime) + "ms");
        System.out.println("整理临时文件完成");

        //3、创建索引文件
        System.out.println("开始创建索引文件");
        startTime = System.currentTimeMillis();

        createIdxFile();

        endTime = System.currentTimeMillis();
        System.out.println("程序运行时间： " + (endTime - startTime) + "ms");
        System.out.println("索引文件创建完成");

        long totalEndTime = System.currentTimeMillis();
        System.out.println("程序运行总时间： " + (totalEndTime - totalStartTime) + "ms");
    }

    private static void createTempFile() {
        File tempFile = new File(CommonFunc.tempPath);
        File file = new File(CommonFunc.psnPath);
        long fileLen = file.length();
        long rowNum = fileLen / (CommonFunc.psnIdLen + CommonFunc.nameLen);

        FileChannel tempFileChannel = null;
        RandomAccessFile raf = null;
        try {
            if (tempFile.exists() == true) {
                tempFile.delete();
            }
            tempFile.createNewFile();

            tempFileChannel = new RandomAccessFile(tempFile, "rw").getChannel();
            raf = new RandomAccessFile(file, "r");
            for (int i = 0; i < rowNum; i++) {
                raf.seek(i * (CommonFunc.psnIdLen + CommonFunc.nameLen) + CommonFunc.psnIdLen);
                byte[] nameByte = new byte[CommonFunc.nameLen];
                raf.read(nameByte);
                long firstNameNum = CommonFunc.getLong(new byte[]{0, 0, 0, 0, 0, nameByte[0], nameByte[1], nameByte[2]});

                MappedByteBuffer mappedByteBuffer = tempFileChannel.map(FileChannel.MapMode.READ_ONLY, (firstNameNum - 1) * (CommonFunc.tempLen + CommonFunc.tempLen), CommonFunc.tempLen);
                byte[] longByte = new byte[CommonFunc.tempLen];
                mappedByteBuffer.get(longByte);
                long tempVal = CommonFunc.getLong(longByte);

                mappedByteBuffer = tempFileChannel.map(FileChannel.MapMode.READ_WRITE, (firstNameNum - 1) * (CommonFunc.tempLen + CommonFunc.tempLen), CommonFunc.tempLen + CommonFunc.tempLen);
                tempVal++;
                longByte = CommonFunc.getBytes(tempVal);
                byte[] zeroByte = new byte[CommonFunc.tempLen];
                byte[] idNameByte = new byte[CommonFunc.tempLen + CommonFunc.tempLen];
                System.arraycopy(longByte, 0, idNameByte, 0, CommonFunc.tempLen);
                System.arraycopy(zeroByte, 0, idNameByte, CommonFunc.tempLen, CommonFunc.tempLen);
                mappedByteBuffer.put(idNameByte);

                if (i % 100000 == 0) {
                    System.out.println("创建临时文件 " + i);
                }
            }
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        } finally {
            if (null != tempFileChannel) {
                try {
                    tempFileChannel.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
            if (null != raf) {
                try {
                    raf.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
        }
    }

    private static void fillTempFile() {
        File tempFile = new File(CommonFunc.tempPath);
        long fileLen = tempFile.length();
        long rowNum = fileLen / (CommonFunc.tempLen + CommonFunc.tempLen);

        FileChannel tempFileChannel = null;
        try {
            tempFileChannel = new RandomAccessFile(tempFile, "rw").getChannel();
            long preNum = 0;
            for (int i = 0; i < rowNum; i++) {
                MappedByteBuffer mappedByteBuffer = tempFileChannel.map(FileChannel.MapMode.READ_ONLY, i * (CommonFunc.tempLen + CommonFunc.tempLen), CommonFunc.tempLen);
                byte[] longByte = new byte[8];
                mappedByteBuffer.get(longByte);
                long tempVal = CommonFunc.getLong(longByte);

                if (tempVal <= 0) {
                    continue;
                }

                mappedByteBuffer = tempFileChannel.map(FileChannel.MapMode.READ_WRITE, i * (CommonFunc.tempLen + CommonFunc.tempLen) + CommonFunc.tempLen, CommonFunc.tempLen);
                longByte = CommonFunc.getBytes(preNum);
                mappedByteBuffer.put(longByte);
                preNum += tempVal;

                if (i % 100000 == 0) {
                    System.out.println("填充临时文件 " + i);
                }
            }
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        } finally {
            if (null != tempFileChannel) {
                try {
                    tempFileChannel.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
        }
    }

    private static void createIdxFile() {
        File file = new File(CommonFunc.psnPath);
        File tempFile = new File(CommonFunc.tempPath);
        File idxFile = new File(CommonFunc.psnIdxPath);
        long fileLen = file.length();
        long rowNum = fileLen / (CommonFunc.psnIdLen + CommonFunc.nameLen);

        RandomAccessFile raf = null;
        RandomAccessFile tempRaf = null;
        RandomAccessFile idxRaf = null;
        try {
            if (idxFile.exists() == true) {
                idxFile.delete();
            }
            idxFile.createNewFile();

            raf = new RandomAccessFile(file, "r");
            tempRaf = new RandomAccessFile(tempFile, "rw");
            idxRaf = new RandomAccessFile(idxFile, "rw");

            for (int i = 0; i < rowNum; i++) {
                raf.seek(i * (CommonFunc.psnIdLen + CommonFunc.nameLen));
                byte[] idByte = new byte[CommonFunc.psnIdLen];
                raf.read(idByte);
                raf.seek(i * (CommonFunc.psnIdLen + CommonFunc.nameLen) + CommonFunc.psnIdLen);
                byte[] nameByte = new byte[CommonFunc.nameLen];
                raf.read(nameByte);
                long firstNameNum = CommonFunc.getLong(new byte[]{0, 0, 0, 0, 0, nameByte[0], nameByte[1], nameByte[2]});

                tempRaf.seek((firstNameNum - 1) * (CommonFunc.tempLen + CommonFunc.tempLen));
                byte[] longByte = new byte[CommonFunc.tempLen];
                tempRaf.read(longByte);
                long tempVal = CommonFunc.getLong(longByte);
                tempRaf.seek((firstNameNum - 1) * (CommonFunc.tempLen + CommonFunc.tempLen) + CommonFunc.tempLen);
                longByte = new byte[CommonFunc.tempLen];
                tempRaf.read(longByte);
                long tempPreNum = CommonFunc.getLong(longByte);
                tempRaf.seek((firstNameNum - 1) * (CommonFunc.tempLen + CommonFunc.tempLen));
                tempVal--;
                longByte = CommonFunc.getBytes(tempVal);
                tempRaf.write(longByte);

                //写入
                idxRaf.seek((tempPreNum + tempVal) * (CommonFunc.psnIdLen + CommonFunc.nameLen));
                idxRaf.write(nameByte);
                idxRaf.seek((tempPreNum + tempVal) * (CommonFunc.psnIdLen + CommonFunc.nameLen) + CommonFunc.nameLen);
                idxRaf.write(idByte);

                if (i % 100000 == 0) {
                    System.out.println("创建索引文件 " + i);
                }
            }
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        } finally {
            if (null != raf) {
                try {
                    raf.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
            if (null != tempRaf) {
                try {
                    tempRaf.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
            if (null != idxRaf) {
                try {
                    idxRaf.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
        }
    }

    //以下为测试用方法

    //标准数据：1千万条
    public static void createData() {

        File file = new File(CommonFunc.psnPath);
        if (file.exists() == true) {
            file.delete();
        }
        try {
            file.createNewFile();
        } catch (IOException e) {
            System.out.println(e.getMessage());
        }

        long totalStartTime = System.currentTimeMillis();
        for (int j = 0; j < 10; j++) {

            long startTime = System.currentTimeMillis();
            Person[] personList = new Person[1000000];
            for (int i = (j * 1000000); i < (j * 1000000 + 1000000); i++) {

                Person person = new Person();
                personList[i - (j * 1000000)] = person;

                person.setPersonId(i + 1);
                person.setName(CommonFunc.getPersonName());
            }

            PersonOperate.batchInsert(personList);
            long endTime = System.currentTimeMillis();
            System.out.println("程序第 " + j + " 次运行时间： " + (endTime - startTime) + "ms");
        }
        long totalEndTime = System.currentTimeMillis();
        System.out.println("程序运行总时间： " + (totalEndTime - totalStartTime) + "ms");
    }

    //测试数据 3条
    public static void createTestData() {

        File file = new File(CommonFunc.psnPath);
        if (file.exists() == true) {
            file.delete();
        }
        try {
            file.createNewFile();
        } catch (IOException e) {
            System.out.println(e.getMessage());
        }

        //批量提交:1KW数据
        long totalStartTime = System.currentTimeMillis();
        for (int j = 0; j < 1; j++) {

            long startTime = System.currentTimeMillis();
            Person[] personList = new Person[3];
            for (int i = (j * 3); i < (j * 3 + 3); i++) {

                Person person = new Person();
                personList[i - (j * 3)] = person;

                person.setPersonId(i + 1);
                person.setName(CommonFunc.getPersonName());
            }

            PersonOperate.batchInsert(personList);
            long endTime = System.currentTimeMillis();
            System.out.println("程序第 " + j + " 次运行时间： " + (endTime - startTime) + "ms");
        }
        long totalEndTime = System.currentTimeMillis();
        System.out.println("程序运行总时间： " + (totalEndTime - totalStartTime) + "ms");
    }

    public static void printPersonData() {

        List<Person> rtn = new ArrayList<>();

        File file = new File(CommonFunc.psnPath);
        long fileLen = file.length();
        long rowNum = fileLen / (CommonFunc.psnIdLen + CommonFunc.nameLen);

        RandomAccessFile raf = null;
        try {
            raf = new RandomAccessFile(file, "r");
            for (int i = 0; i < rowNum; i++) {
                Person person = new Person();
                rtn.add(person);

                raf.seek(i * (CommonFunc.psnIdLen + CommonFunc.nameLen));
                person.setPersonId(raf.readLong());

                raf.seek(i * (CommonFunc.psnIdLen + CommonFunc.nameLen) + CommonFunc.psnIdLen);
                byte[] nameByte = new byte[CommonFunc.nameLen];
                raf.read(nameByte);
                person.setName(CommonFunc.getString(nameByte));

                System.out.println("Id:" + person.getPersonId() + " Name:" + person.getName());
            }
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        } finally {
            if (null != raf) {
                try {
                    raf.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
        }
    }

    public static void printTempData() {

        File tempFile = new File(CommonFunc.tempPath);
        long fileLen = tempFile.length();
        long rowNum = fileLen / (CommonFunc.tempLen + CommonFunc.tempLen);

        RandomAccessFile tempRaf = null;
        try {
            tempRaf = new RandomAccessFile(tempFile, "rw");
            for (int i = 0; i < rowNum; i++) {
                tempRaf.seek(i * (CommonFunc.tempLen + CommonFunc.tempLen));
                byte[] longByte = new byte[8];
                tempRaf.read(longByte);
                long tempVal = CommonFunc.getLong(longByte);

                if (tempVal <= 0) {
                    continue;
                }

                tempRaf.seek(i * (CommonFunc.tempLen + CommonFunc.tempLen) + CommonFunc.tempLen);
                longByte = new byte[8];
                tempRaf.read(longByte);
                long tempPreNum = CommonFunc.getLong(longByte);

                System.out.println("PersonNameNum : " + (i + 1) + " ; Num : " + tempVal + " ; PreNum : " + tempPreNum);
            }
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        } finally {
            if (null != tempRaf) {
                try {
                    tempRaf.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
        }
    }

    public static void printIdxData() {

        File tempFile = new File(CommonFunc.psnIdxPath);
        long fileLen = tempFile.length();
        long rowNum = fileLen / (CommonFunc.psnIdLen + CommonFunc.nameLen);

        RandomAccessFile tempRaf = null;
        try {
            tempRaf = new RandomAccessFile(tempFile, "rw");
            for (int i = 0; i < rowNum; i++) {

                tempRaf.seek(i * (CommonFunc.psnIdLen + CommonFunc.nameLen));
                byte[] nameByte = new byte[CommonFunc.nameLen];
                tempRaf.read(nameByte);
                String name = CommonFunc.getString(nameByte);

                tempRaf.seek(i * (CommonFunc.psnIdLen + CommonFunc.nameLen) + CommonFunc.nameLen);
                byte[] idByte = new byte[CommonFunc.psnIdLen];
                tempRaf.read(idByte);
                long id = CommonFunc.getLong(idByte);

                System.out.println("idx : " + i + " ; name : " + name + " ; id : " + id);
            }
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        } finally {
            if (null != tempRaf) {
                try {
                    tempRaf.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
        }
    }

    public static void printOrderByPersonName(String name) {

        printOrderByPersonName(name, 0, false);
    }

    public static void printOrderByPersonName(String name, int totalNum, final boolean desc) {

        long startTime = System.currentTimeMillis();
        List<Person> personList = PersonOperate.getPersonsByName(name);
        if (personList.size() <= 0) {
            System.out.println("该名称没有对应的人员");
            return;
        }
        //默认取第一个人
        Person person = personList.get(0);
        List<Order> orderList = OrderOperate.getOrderByPersonId(person.getPersonId());

        //排序
        Collections.sort(orderList, new Comparator<Order>() {
            @Override
            public int compare(Order o1, Order o2) {
                int rtn = 0;
                if (o1.getAmount() < o2.getAmount()) {
                    rtn = desc == false ? -1 : 1;
                } else if (o1.getAmount() > o2.getAmount()) {
                    rtn = desc == false ? 1 : -1;
                }
                return rtn;
            }
        });

        List<Order> rtn;
        if (totalNum > 0 && orderList.size() > totalNum) {
            rtn = orderList.subList(0, totalNum);
        } else {
            rtn = orderList;
        }

        if (rtn.size() <= 0) {
            System.out.println("该名称对应的订单为0");
        }

        long endTime = System.currentTimeMillis();

        for (Order order : rtn) {
            System.out.println("订单ID：" + order.getOrderId() + " 价格：" + order.getAmount());
        }
        System.out.println("共查出 " + rtn.size() + " 条");
        System.out.println("程序运行时间： " + (endTime - startTime) + "ms");
    }
}

OrderOperate.java

import java.io.File;
import java.io.IOException;
import java.io.RandomAccessFile;
import java.nio.MappedByteBuffer;
import java.nio.channels.FileChannel;
import java.util.ArrayList;
import java.util.List;

public class OrderOperate {

    /**
     * 插入订单
     *
     * @param order
     */
    public static void insert(Order order) {

        File file = new File(CommonFunc.orderPath);
        long fileLen = file.length();

        RandomAccessFile raf = null;
        try {
            raf = new RandomAccessFile(file, "rw");

            long id = order.getOrderId();
            byte[] idByte = CommonFunc.getBytes(id);
            long personId = order.getPersonId();
            byte[] personIdByte = CommonFunc.getBytes(personId);
            double amount = order.getAmount();
            byte[] amountByte = CommonFunc.getBytes(amount);

            byte[] idNameByte = new byte[CommonFunc.orderIdLen + CommonFunc.personIdLen + CommonFunc.amountLen];
            System.arraycopy(idByte, 0, idNameByte, 0, CommonFunc.orderIdLen);
            System.arraycopy(personIdByte, 0, idNameByte, CommonFunc.orderIdLen, CommonFunc.personIdLen);
            System.arraycopy(amountByte, 0, idNameByte, CommonFunc.orderIdLen + CommonFunc.personIdLen, CommonFunc.amountLen);

            raf.seek(fileLen);
            raf.write(idNameByte);
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        } finally {
            if (null != raf) {
                try {
                    raf.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
        }
    }

    /**
     * 批量插入订单
     *
     * @param orders
     */
    public static void batchInsert(Order[] orders) {

        File file = new File(CommonFunc.orderPath);
        long fileLen = file.length();

        RandomAccessFile raf = null;
        try {
            raf = new RandomAccessFile(file, "rw");

            byte[] idNameBytes = new byte[(CommonFunc.orderIdLen + CommonFunc.personIdLen + CommonFunc.amountLen) * orders.length];
            for (int i = 0; i < orders.length; i++) {
                Order order = orders[i];

                long id = order.getOrderId();
                byte[] idByte = CommonFunc.getBytes(id);
                long personId = order.getPersonId();
                byte[] personIdByte = CommonFunc.getBytes(personId);
                double amount = order.getAmount();
                byte[] amountByte = CommonFunc.getBytes(amount);

                System.arraycopy(idByte, 0, idNameBytes, i * (CommonFunc.orderIdLen + CommonFunc.personIdLen + CommonFunc.amountLen), CommonFunc.orderIdLen);
                System.arraycopy(personIdByte, 0, idNameBytes, i * (CommonFunc.orderIdLen + CommonFunc.personIdLen + CommonFunc.amountLen) + CommonFunc.orderIdLen, CommonFunc.personIdLen);
                System.arraycopy(amountByte, 0, idNameBytes, i * (CommonFunc.orderIdLen + CommonFunc.personIdLen + CommonFunc.amountLen) + (CommonFunc.orderIdLen + CommonFunc.personIdLen), CommonFunc.amountLen);
            }
            raf.seek(fileLen);
            raf.write(idNameBytes);

        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        } finally {
            if (null != raf) {
                try {
                    raf.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
        }
    }

    /**
     * 根据ID查询Order（二分法查询）
     *
     * @param orderId
     * @return
     */
    public static Order getOrderById(long orderId) {
        Order rtn = new Order();

        File file = new File(CommonFunc.orderPath);
        //获取位置
        long pos = (orderId - 1) * (CommonFunc.orderIdLen + CommonFunc.personIdLen + CommonFunc.amountLen);

        RandomAccessFile raf = null;
        try {
            raf = new RandomAccessFile(file, "r");

            raf.seek(pos);
            rtn.setOrderId(raf.readLong());
            pos += CommonFunc.orderIdLen;

            raf.seek(pos);
            rtn.setPersonId(raf.readLong());
            pos += CommonFunc.personIdLen;

            raf.seek(pos);
            rtn.setAmount(raf.readDouble());
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        } finally {
            if (null != raf) {
                try {
                    raf.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
        }

        return rtn;
    }

    /**
     * 根据PersonID查询所有订单
     *
     * @param personId
     * @return
     */
    public static List<Order> getOrderByPersonId(long personId) {
        List<Order> rtn = new ArrayList<>();

        //获取要查询的ID列表
        File idxFile = new File(CommonFunc.orderIdxPath);
        long fileLen = idxFile.length();
        long rowNum = fileLen / (CommonFunc.tempLen + CommonFunc.tempLen);

        FileChannel idxFileChannel = null;
        try {
            idxFileChannel = new RandomAccessFile(idxFile, "r").getChannel();
            MappedByteBuffer idxMappedByteBuffer = idxFileChannel.map(FileChannel.MapMode.READ_ONLY, 0, idxFile.length());

            //二分法查找，确定位置
            long findRow = -1;
            long minRow = 1;
            long maxRow = rowNum;
            while (maxRow > minRow) {
                long midRow = (minRow + maxRow) / 2;
                idxMappedByteBuffer.position((int) (midRow - 1) * (CommonFunc.tempLen + CommonFunc.tempLen));
                long tempPersonId = idxMappedByteBuffer.getLong();
                if (tempPersonId > personId) {
                    if (maxRow == midRow) {
                        break;
                    }
                    maxRow = midRow;
                } else if (tempPersonId < personId) {
                    if (minRow == midRow) {
                        minRow++;
                        continue;
                    }
                    minRow = midRow;
                } else {
                    findRow = midRow - 1;
                    break;
                }
            }

            if (findRow == -1) {
                return rtn;
            }

            //前后搜索，确定该数据的最大行和最小行
            long minRowIndex = 0;
            while ((findRow - minRowIndex) >= 0) {
                idxMappedByteBuffer.position((int) (findRow - minRowIndex) * (CommonFunc.tempLen + CommonFunc.tempLen));
                long tempPersonId = idxMappedByteBuffer.getLong();
                if (tempPersonId != personId) {
                    break;
                }

                idxMappedByteBuffer.position((int) (findRow - minRowIndex) * (CommonFunc.tempLen + CommonFunc.tempLen) + CommonFunc.tempLen);
                long orderId = idxMappedByteBuffer.getLong();
                Order order = getOrderById(orderId);
                rtn.add(order);
                minRowIndex++;
            }

            long maxRowIndex = 1;
            while ((findRow + maxRowIndex) <= rowNum) {
                idxMappedByteBuffer.position((int) (findRow + maxRowIndex) * (CommonFunc.tempLen + CommonFunc.tempLen));
                long tempPersonId = idxMappedByteBuffer.getLong();
                if (tempPersonId != personId) {
                    break;
                }

                idxMappedByteBuffer.position((int) (findRow + maxRowIndex) * (CommonFunc.tempLen + CommonFunc.tempLen) + CommonFunc.tempLen);
                long orderId = idxMappedByteBuffer.getLong();
                Order order = getOrderById(orderId);
                rtn.add(order);
                maxRowIndex++;
            }
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        } finally {
            if (null != idxFileChannel) {
                try {
                    idxFileChannel.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
        }

        return rtn;
    }

    public static List<Order> getOrderByPersonId_bak(long personId) {
        List<Order> rtn = new ArrayList<>();

        //获取要查询的ID列表
        File idxFile = new File(CommonFunc.orderIdxPath);
        long fileLen = idxFile.length();
        long rowNum = fileLen / (CommonFunc.tempLen + CommonFunc.tempLen);

        RandomAccessFile idxRaf = null;
        try {
            idxRaf = new RandomAccessFile(idxFile, "r");

            //二分法查找，确定位置
            long findRow = -1;
            long minRow = 1;
            long maxRow = rowNum;
            while (maxRow > minRow) {
                long midRow = (minRow + maxRow) / 2;
                idxRaf.seek((midRow - 1) * (CommonFunc.tempLen + CommonFunc.tempLen));
                byte[] longByte = new byte[8];
                idxRaf.read(longByte);
                long tempPersonId = CommonFunc.getLong(longByte);
                if (tempPersonId > personId) {
                    if (maxRow == midRow) {
                        break;
                    }
                    maxRow = midRow;
                } else if (tempPersonId < personId) {
                    if (minRow == midRow) {
                        minRow++;
                        continue;
                    }
                    minRow = midRow;
                } else {
                    findRow = midRow - 1;
                    break;
                }
            }

            if (findRow == -1) {
                return rtn;
            }

            //前后搜索，确定该数据的最大行和最小行
            long minRowIndex = 0;
            while ((findRow - minRowIndex) >= 0) {
                idxRaf.seek((findRow - minRowIndex) * (CommonFunc.tempLen + CommonFunc.tempLen));
                byte[] longByte = new byte[8];
                idxRaf.read(longByte);
                long tempPersonId = CommonFunc.getLong(longByte);

                if (tempPersonId != personId) {
                    break;
                }

                idxRaf.seek((findRow - minRowIndex) * (CommonFunc.tempLen + CommonFunc.tempLen) + CommonFunc.tempLen);
                longByte = new byte[8];
                idxRaf.read(longByte);
                long orderId = CommonFunc.getLong(longByte);

                Order order = getOrderById(orderId);
                rtn.add(order);

                minRowIndex++;
            }

            long maxRowIndex = 1;
            while ((findRow + maxRowIndex) <= rowNum) {
                idxRaf.seek((findRow + maxRowIndex) * (CommonFunc.tempLen + CommonFunc.tempLen));
                byte[] longByte = new byte[8];
                idxRaf.read(longByte);
                long tempPersonId = CommonFunc.getLong(longByte);

                if (tempPersonId != personId) {
                    break;
                }

                idxRaf.seek((findRow + maxRowIndex) * (CommonFunc.tempLen + CommonFunc.tempLen) + CommonFunc.tempLen);
                longByte = new byte[8];
                idxRaf.read(longByte);
                long orderId = CommonFunc.getLong(longByte);

                Order order = getOrderById(orderId);
                rtn.add(order);

                maxRowIndex++;
            }
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        } finally {
            if (null != idxRaf) {
                try {
                    idxRaf.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
        }

        return rtn;
    }

    /**
     * 创建PersonID索引（时间太长，待进一步优化）
     */
    public static void createPersonIdIndex() {

        long totalStartTime = System.currentTimeMillis();

        // 1）做一个PersonId，数量的文件；
        System.out.println("开始创建临时文件");
        long startTime = System.currentTimeMillis();

        createTempFile();

        long endTime = System.currentTimeMillis();
        System.out.println("程序运行时间： " + (endTime - startTime) + "ms");
        System.out.println("临时文件创建完成");

        // 2）做一个空间；
        System.out.println("整理临时文件");
        startTime = System.currentTimeMillis();

        fillTempFile();

        endTime = System.currentTimeMillis();
        System.out.println("程序运行时间： " + (endTime - startTime) + "ms");
        System.out.println("整理临时文件完成");

        // 3）填充空间；
        System.out.println("开始创建索引文件");
        startTime = System.currentTimeMillis();

        createIdxFile();

        endTime = System.currentTimeMillis();
        System.out.println("程序运行时间： " + (endTime - startTime) + "ms");
        System.out.println("索引文件创建完成");

        long totalEndTime = System.currentTimeMillis();
        System.out.println("程序运行总时间： " + (totalEndTime - totalStartTime) + "ms");

    }

    public static void createPersonIdAmontIndex() {

        long totalStartTime = System.currentTimeMillis();

        // 1）做一个PersonId，数量的文件；
        System.out.println("开始创建临时文件");
        long startTime = System.currentTimeMillis();

        createTempFile();

        long endTime = System.currentTimeMillis();
        System.out.println("程序运行时间： " + (endTime - startTime) + "ms");
        System.out.println("临时文件创建完成");

        // 2）做一个空间；
        System.out.println("整理临时文件");
        startTime = System.currentTimeMillis();

        fillTempFile();

        endTime = System.currentTimeMillis();
        System.out.println("程序运行时间： " + (endTime - startTime) + "ms");
        System.out.println("整理临时文件完成");

        // 3）填充空间；
        System.out.println("开始创建索引文件");
        startTime = System.currentTimeMillis();

        createIdxAmountFile();

        endTime = System.currentTimeMillis();
        System.out.println("程序运行时间： " + (endTime - startTime) + "ms");
        System.out.println("索引文件创建完成");

        long totalEndTime = System.currentTimeMillis();
        System.out.println("程序运行总时间： " + (totalEndTime - totalStartTime) + "ms");

    }

    private static void createTempFile() {
        File tempFile = new File(CommonFunc.tempPath);
        File file = new File(CommonFunc.orderPath);
        long fileLen = file.length();
        long rowNum = fileLen / (CommonFunc.orderIdLen + CommonFunc.personIdLen + CommonFunc.amountLen);

        FileChannel tempFileChannel = null;
        RandomAccessFile raf = null;
        try {
            if (tempFile.exists() == true) {
                tempFile.delete();
            }
            tempFile.createNewFile();

            tempFileChannel = new RandomAccessFile(tempFile, "rw").getChannel();
            MappedByteBuffer mappedByteBuffer = tempFileChannel.map(FileChannel.MapMode.READ_WRITE, 0, tempFile.length());
            raf = new RandomAccessFile(file, "r");
            for (long i = 0; i < rowNum; i++) {
                raf.seek(i * (CommonFunc.orderIdLen + CommonFunc.personIdLen + CommonFunc.amountLen) + CommonFunc.orderIdLen);
                byte[] longByte = new byte[8];
                raf.read(longByte);
                long personId = CommonFunc.getLong(longByte);

                int currentLen = (int) ((personId - 1) * (CommonFunc.tempLen + CommonFunc.tempLen));
                if (mappedByteBuffer.capacity() < currentLen + (CommonFunc.tempLen + CommonFunc.tempLen)) {
                    mappedByteBuffer = tempFileChannel.map(FileChannel.MapMode.READ_WRITE, 0, currentLen + (CommonFunc.tempLen + CommonFunc.tempLen));
                }

                mappedByteBuffer.position(currentLen);
                long tempVal = mappedByteBuffer.getLong();

                tempVal++;
                mappedByteBuffer.position(currentLen);
                mappedByteBuffer.putLong(tempVal);

                if (i % 1000000 == 0) {
                    System.out.println("创建临时文件 " + i);
                }
            }
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        } finally {
            if (null != tempFileChannel) {
                try {
                    tempFileChannel.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
            if (null != raf) {
                try {
                    raf.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
        }
    }

    private static void fillTempFile() {
        File tempFile = new File(CommonFunc.tempPath);
        long fileLen = tempFile.length();
        long rowNum = fileLen / (CommonFunc.tempLen + CommonFunc.tempLen);

        FileChannel tempFileChannel = null;
        try {
            tempFileChannel = new RandomAccessFile(tempFile, "rw").getChannel();
            MappedByteBuffer mappedByteBuffer = tempFileChannel.map(FileChannel.MapMode.READ_WRITE, 0, fileLen);
            long preNum = 0;
            for (int i = 0; i < rowNum; i++) {
                mappedByteBuffer.position(i * (CommonFunc.tempLen + CommonFunc.tempLen));
                long tempVal = mappedByteBuffer.getLong();

                if (tempVal <= 0) {
                    continue;
                }

                mappedByteBuffer.position(i * (CommonFunc.tempLen + CommonFunc.tempLen) + CommonFunc.tempLen);
                mappedByteBuffer.putLong(preNum);
                preNum += tempVal;

                if (i % 1000000 == 0) {
                    System.out.println("填充临时文件 " + i);
                }
            }
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        } finally {
            if (null != tempFileChannel) {
                try {
                    tempFileChannel.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
        }
    }

    private static void createIdxFile() {
        File file = new File(CommonFunc.orderPath);
        File tempFile = new File(CommonFunc.tempPath);
        File idxFile = new File(CommonFunc.orderIdxPath);
        long fileLen = file.length();
        long rowNum = fileLen / (CommonFunc.orderIdLen + CommonFunc.personIdLen + CommonFunc.amountLen);

        RandomAccessFile raf = null;
        FileChannel tempFileChannel = null;
        FileChannel idxFileChannel = null;
        try {
            if (idxFile.exists() == true) {
                idxFile.delete();
            }
            idxFile.createNewFile();

            raf = new RandomAccessFile(file, "r");
            tempFileChannel = new RandomAccessFile(tempFile, "rw").getChannel();
            idxFileChannel = new RandomAccessFile(idxFile, "rw").getChannel();
            MappedByteBuffer tempMappedByteBuffer = tempFileChannel.map(FileChannel.MapMode.READ_WRITE, 0, tempFile.length());
            MappedByteBuffer idxMappedByteBuffer = idxFileChannel.map(FileChannel.MapMode.READ_WRITE, 0, rowNum * (CommonFunc.personIdLen + CommonFunc.orderIdLen));
            for (long i = 0; i < rowNum; i++) {
                raf.seek(i * (CommonFunc.orderIdLen + CommonFunc.personIdLen + CommonFunc.amountLen));
                byte[] idByte = new byte[CommonFunc.orderIdLen];
                raf.read(idByte);
                raf.seek(i * (CommonFunc.orderIdLen + CommonFunc.personIdLen + CommonFunc.amountLen) + CommonFunc.orderIdLen);
                byte[] personIdByte = new byte[CommonFunc.personIdLen];
                raf.read(personIdByte);
                long personId = CommonFunc.getLong(personIdByte);

                tempMappedByteBuffer.position((int) ((personId - 1) * (CommonFunc.tempLen + CommonFunc.tempLen)));
                long tempVal = tempMappedByteBuffer.getLong();
                tempMappedByteBuffer.position((int) ((personId - 1) * (CommonFunc.tempLen + CommonFunc.tempLen)) + CommonFunc.tempLen);
                long tempPreNum = tempMappedByteBuffer.getLong();
                tempVal--;
                tempMappedByteBuffer.position((int) ((personId - 1) * (CommonFunc.tempLen + CommonFunc.tempLen)));
                tempMappedByteBuffer.putLong(tempVal);
                //写入
                idxMappedByteBuffer.position((int) ((tempPreNum + tempVal) * (CommonFunc.orderIdLen + CommonFunc.personIdLen)));
                idxMappedByteBuffer.put(personIdByte);
                idxMappedByteBuffer.position((int) ((tempPreNum + tempVal) * (CommonFunc.orderIdLen + CommonFunc.personIdLen)) + CommonFunc.personIdLen);
                idxMappedByteBuffer.put(idByte);

                if (i % 1000000 == 0) {
                    System.out.println("创建索引文件 " + i);
                }
            }
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        } finally {
            if (null != raf) {
                try {
                    raf.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
            if (null != tempFileChannel) {
                try {
                    tempFileChannel.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
            if (null != idxFileChannel) {
                try {
                    idxFileChannel.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
        }
    }

    private static void createIdxAmountFile() {
        File file = new File(CommonFunc.orderPath);
        File tempFile = new File(CommonFunc.tempPath);
        File idxFile = new File(CommonFunc.orderIdxAmountPath);
        long fileLen = file.length();
        long rowNum = fileLen / (CommonFunc.orderIdLen + CommonFunc.personIdLen + CommonFunc.amountLen);

        RandomAccessFile raf = null;
        FileChannel tempFileChannel = null;
        FileChannel idxFileChannel = null;
        try {
            if (idxFile.exists() == true) {
                idxFile.delete();
            }
            idxFile.createNewFile();

            raf = new RandomAccessFile(file, "r");
            tempFileChannel = new RandomAccessFile(tempFile, "rw").getChannel();
            idxFileChannel = new RandomAccessFile(idxFile, "rw").getChannel();
            MappedByteBuffer tempMappedByteBuffer = tempFileChannel.map(FileChannel.MapMode.READ_WRITE, 0, tempFile.length());
            MappedByteBuffer idxMappedByteBuffer = idxFileChannel.map(FileChannel.MapMode.READ_WRITE, 0, rowNum * (CommonFunc.personIdLen + CommonFunc.orderIdLen));
            for (long i = 0; i < rowNum; i++) {
                //raf.seek(i * (CommonFunc.orderIdLen + CommonFunc.personIdLen + CommonFunc.amountLen));
                //byte[] idByte = new byte[CommonFunc.orderIdLen];
                //raf.read(idByte);
                raf.seek(i * (CommonFunc.orderIdLen + CommonFunc.personIdLen + CommonFunc.amountLen) + CommonFunc.orderIdLen);
                byte[] personIdByte = new byte[CommonFunc.personIdLen];
                raf.read(personIdByte);
                long personId = CommonFunc.getLong(personIdByte);
                raf.seek(i * (CommonFunc.orderIdLen + CommonFunc.personIdLen + CommonFunc.amountLen) + CommonFunc.orderIdLen + CommonFunc.personIdLen);
                double amount = raf.readDouble();

                tempMappedByteBuffer.position((int) ((personId - 1) * (CommonFunc.tempLen + CommonFunc.tempLen)));
                long tempVal = tempMappedByteBuffer.getLong();
                tempMappedByteBuffer.position((int) ((personId - 1) * (CommonFunc.tempLen + CommonFunc.tempLen)) + CommonFunc.tempLen);
                long tempPreNum = tempMappedByteBuffer.getLong();
                tempVal--;
                tempMappedByteBuffer.position((int) ((personId - 1) * (CommonFunc.tempLen + CommonFunc.tempLen)));
                tempMappedByteBuffer.putLong(tempVal);
                //写入
                idxMappedByteBuffer.position((int) ((tempPreNum + tempVal) * (CommonFunc.orderIdLen + CommonFunc.personIdLen)));
                idxMappedByteBuffer.put(personIdByte);
                idxMappedByteBuffer.position((int) ((tempPreNum + tempVal) * (CommonFunc.orderIdLen + CommonFunc.personIdLen)) + CommonFunc.personIdLen);
                idxMappedByteBuffer.putDouble(amount);

                if (i % 1000000 == 0) {
                    System.out.println("创建索引文件 " + i);
                }
            }
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        } finally {
            if (null != raf) {
                try {
                    raf.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
            if (null != tempFileChannel) {
                try {
                    tempFileChannel.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
            if (null != idxFileChannel) {
                try {
                    idxFileChannel.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
        }
    }

    //以下为测试用方法

    //标准数据:一亿条
    public static void createData() {

        File file = new File(CommonFunc.orderPath);
        if (file.exists() == true) {
            file.delete();
        }
        try {
            file.createNewFile();
        } catch (IOException e) {
            System.out.println(e.getMessage());
        }

        long totalStartTime = System.currentTimeMillis();
        for (int j = 0; j < 100; j++) {

            long startTime = System.currentTimeMillis();
            Order[] orderList = new Order[1000000];
            for (int i = (j * 1000000); i < (j * 1000000 + 1000000); i++) {

                Order order = new Order();
                orderList[i - (j * 1000000)] = order;

                order.setOrderId(i + 1);
                order.setPersonId(CommonFunc.getRandomPersonId(10000000));
                order.setAmount(CommonFunc.getRandomDouble(10000));
            }

            OrderOperate.batchInsert(orderList);
            long endTime = System.currentTimeMillis();
            System.out.println("程序第 " + j + " 次运行时间： " + (endTime - startTime) + "ms");
        }
        long totalEndTime = System.currentTimeMillis();
        System.out.println("程序运行总时间： " + (totalEndTime - totalStartTime) + "ms");

    }

    //测试数据：10条
    public static void createTestData() {

        File file = new File(CommonFunc.orderPath);
        if (file.exists() == true) {
            file.delete();
        }
        try {
            file.createNewFile();
        } catch (IOException e) {
            System.out.println(e.getMessage());
        }

        long totalStartTime = System.currentTimeMillis();
        for (int j = 0; j < 1; j++) {

            long startTime = System.currentTimeMillis();
            Order[] orderList = new Order[10];
            for (int i = (j * 10); i < (j * 10 + 10); i++) {

                Order order = new Order();
                orderList[i - (j * 10)] = order;

                order.setOrderId(i + 1);
                order.setPersonId(CommonFunc.getRandomPersonId(3));
                order.setAmount(CommonFunc.getRandomDouble(10000));
            }

            OrderOperate.batchInsert(orderList);
            long endTime = System.currentTimeMillis();
            System.out.println("程序第 " + j + " 次运行时间： " + (endTime - startTime) + "ms");
        }
        long totalEndTime = System.currentTimeMillis();
        System.out.println("程序运行总时间： " + (totalEndTime - totalStartTime) + "ms");

    }

    public static void printOrderData() {

        List<Order> rtn = new ArrayList<>();

        File file = new File(CommonFunc.orderPath);
        long fileLen = file.length();
        long rowNum = fileLen / (CommonFunc.orderIdLen + CommonFunc.personIdLen + CommonFunc.amountLen);

        RandomAccessFile raf = null;
        try {
            raf = new RandomAccessFile(file, "r");
            for (long i = 0; i < rowNum; i++) {
                Order order = new Order();
                rtn.add(order);

                raf.seek(i * (CommonFunc.orderIdLen + CommonFunc.personIdLen + CommonFunc.amountLen));
                order.setOrderId(raf.readLong());

                raf.seek(i * (CommonFunc.orderIdLen + CommonFunc.personIdLen + CommonFunc.amountLen) + CommonFunc.orderIdLen);
                byte[] personIdByte = new byte[CommonFunc.personIdLen];
                raf.read(personIdByte);
                order.setPersonId(CommonFunc.getLong(personIdByte));

                raf.seek(i * (CommonFunc.orderIdLen + CommonFunc.personIdLen + CommonFunc.amountLen) + (CommonFunc.orderIdLen + CommonFunc.personIdLen));
                byte[] amountLenByte = new byte[CommonFunc.amountLen];
                raf.read(amountLenByte);
                order.setAmount(CommonFunc.getDouble(amountLenByte));

                System.out.println("ID:" + order.getOrderId() + " PersonId:" + order.getPersonId() + " Amount:" + order.getAmount());
            }
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        } finally {
            if (null != raf) {
                try {
                    raf.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
        }
    }

    public static void printTempData() {

        File tempFile = new File(CommonFunc.tempPath);
        long fileLen = tempFile.length();
        long rowNum = fileLen / (CommonFunc.tempLen + CommonFunc.tempLen);

        RandomAccessFile tempRaf = null;
        try {
            tempRaf = new RandomAccessFile(tempFile, "rw");
            for (int i = 0; i < rowNum; i++) {
                tempRaf.seek(i * (CommonFunc.tempLen + CommonFunc.tempLen));
                byte[] longByte = new byte[8];
                tempRaf.read(longByte);
                long tempVal = CommonFunc.getLong(longByte);

                if (tempVal <= 0) {
                    continue;
                }

                tempRaf.seek(i * (CommonFunc.tempLen + CommonFunc.tempLen) + CommonFunc.tempLen);
                longByte = new byte[8];
                tempRaf.read(longByte);
                long tempPreNum = CommonFunc.getLong(longByte);

                System.out.println("PersonId : " + (i + 1) + " ; Num : " + tempVal + " ; PreNum : " + tempPreNum);
            }
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        } finally {
            if (null != tempRaf) {
                try {
                    tempRaf.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
        }
    }

    public static void printIdxData() {

        File tempFile = new File(CommonFunc.orderIdxPath);
        long fileLen = tempFile.length();
        long rowNum = fileLen / (CommonFunc.orderIdLen + CommonFunc.personIdLen);

        RandomAccessFile tempRaf = null;
        try {
            tempRaf = new RandomAccessFile(tempFile, "rw");
            for (long i = 0; i < rowNum; i++) {

                tempRaf.seek(i * (CommonFunc.orderIdLen + CommonFunc.personIdLen));
                byte[] longByte = new byte[CommonFunc.personIdLen];
                tempRaf.read(longByte);
                long personid = CommonFunc.getLong(longByte);

                tempRaf.seek(i * (CommonFunc.orderIdLen + CommonFunc.personIdLen) + CommonFunc.personIdLen);
                longByte = new byte[CommonFunc.orderIdLen];
                tempRaf.read(longByte);
                long orderid = CommonFunc.getLong(longByte);

                System.out.println("idx : " + i + " ; personid : " + personid + " ; orderid : " + orderid);
            }
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        } finally {
            if (null != tempRaf) {
                try {
                    tempRaf.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
        }
    }

    public static void printIdxAmountData() {

        File tempFile = new File(CommonFunc.orderIdxAmountPath);
        long fileLen = tempFile.length();
        long rowNum = fileLen / (CommonFunc.orderIdLen + CommonFunc.personIdLen);

        RandomAccessFile tempRaf = null;
        try {
            tempRaf = new RandomAccessFile(tempFile, "rw");
            for (long i = 0; i < rowNum; i++) {

                tempRaf.seek(i * (CommonFunc.orderIdLen + CommonFunc.personIdLen));
                byte[] longByte = new byte[CommonFunc.personIdLen];
                tempRaf.read(longByte);
                long personid = CommonFunc.getLong(longByte);

                tempRaf.seek(i * (CommonFunc.orderIdLen + CommonFunc.personIdLen) + CommonFunc.personIdLen);
                double amount = tempRaf.readDouble();

                System.out.println("idx : " + i + " ; personid : " + personid + " ; amount : " + amount);
            }
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        } finally {
            if (null != tempRaf) {
                try {
                    tempRaf.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
        }
    }

    public static void printTop1000SumData(int totalNum, boolean desc) {

        long startTime = System.currentTimeMillis();

        List<OrderQuery> rtn = getOrderQueryList(totalNum, desc);

        long endTime = System.currentTimeMillis();

        for (OrderQuery orderQuery : rtn) {
            System.out.println("姓名：" + orderQuery.getPersonName() + " 数量：" + orderQuery.getOrderCount() + " 总价：" + orderQuery.getOrderSum());
        }
        System.out.println("共查出 " + rtn.size() + " 条");
        System.out.println("程序运行时间： " + (endTime - startTime) + "ms");
    }

    private static List<OrderQuery> getOrderQueryList(int totalNum, boolean desc) {

        List<OrderQuery> rtn = new ArrayList<>();

        File idxFile = new File(CommonFunc.orderIdxAmountPath);
        long fileLen = idxFile.length();
        long rowNum = fileLen / (CommonFunc.tempLen + CommonFunc.tempLen);
        File psnFile = new File(CommonFunc.psnPath);

        FileChannel idxFileChannel = null;
        FileChannel psnFileChannel = null;
        try {
            idxFileChannel = new RandomAccessFile(idxFile, "r").getChannel();
            MappedByteBuffer idxMappedByteBuffer = idxFileChannel.map(FileChannel.MapMode.READ_ONLY, 0, idxFile.length());

            psnFileChannel = new RandomAccessFile(psnFile, "r").getChannel();
            MappedByteBuffer psnMappedByteBuffer = psnFileChannel.map(FileChannel.MapMode.READ_ONLY, 0, psnFile.length());

            OrderQuery orderQuery = null;
            long prePersonId = -1;
            for (int i = 0; i < rowNum; i++) {
                long personId = idxMappedByteBuffer.getLong();
                double amount = idxMappedByteBuffer.getDouble();

                if (prePersonId == personId) {
                    orderQuery.setOrderCount(orderQuery.getOrderCount() + 1);
                    orderQuery.setOrderSum(orderQuery.getOrderSum() + amount);
                } else {
                    //处理完的数据，添加入列表
                    if (orderQuery != null) {
                        insertOrderQueryList(rtn, orderQuery, totalNum, desc);
                    }

                    //获取Person姓名
                    int psnNamePos = (int) (personId - 1) * (CommonFunc.psnIdLen + CommonFunc.nameLen) + CommonFunc.psnIdLen;
                    psnMappedByteBuffer.position(psnNamePos);
                    byte[] psnNameByte = new byte[CommonFunc.nameLen];
                    psnMappedByteBuffer.get(psnNameByte);
                    String personName = CommonFunc.getString(psnNameByte);
                    //设置对象
                    orderQuery = new OrderQuery();
                    orderQuery.setPersonName(personName);
                    orderQuery.setOrderCount(1);
                    orderQuery.setOrderSum(amount);

                    prePersonId = personId;
                }

                if (i % 1000000 == 0) {
                    System.out.println("处理条数 " + i);
                }
            }

            //添加最后一条数据
            if (orderQuery != null) {
                insertOrderQueryList(rtn, orderQuery, totalNum, desc);
            }

        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        } finally {
            if (null != idxFileChannel) {
                try {
                    idxFileChannel.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
            if (null != psnFileChannel) {
                try {
                    psnFileChannel.close();
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
        }

        return rtn;
    }

    private static void insertOrderQueryList(List<OrderQuery> list, OrderQuery orderQuery, int listMaxNum, boolean desc) {

        int insertIdx = desc ? getInsertDescIndex(list, orderQuery) : getInsertIndex(list, orderQuery);
        if (insertIdx < listMaxNum || listMaxNum <= 0) {
            list.add(insertIdx, orderQuery);
        }

        if (list.size() > listMaxNum && listMaxNum > 0) {
            for (int i = list.size() - 1; i >= listMaxNum; i--) {
                list.remove(i);

            }
        }
    }

    private static int getInsertIndex(List<OrderQuery> list, OrderQuery orderQuery) {
        int rtn = -1;

        //处理边缘点
        if (list.size() <= 0 || list.get(0).getOrderSum() > orderQuery.getOrderSum()) {
            return 0;
        }
        if (list.get(list.size() - 1).getOrderSum() <= orderQuery.getOrderSum()) {
            return list.size();
        }

        //常规处理
        int minIdx = 0;
        int maxIdx = list.size() - 1;
        while (maxIdx > minIdx) {
            //中间数据处理
            if (minIdx + 1 == maxIdx) {
                rtn = maxIdx;
                break;
            }

            int midIdx = (minIdx + maxIdx) / 2;
            double currentNum = list.get(midIdx).getOrderSum();
            if (currentNum > orderQuery.getOrderSum()) {
                maxIdx = midIdx;
            } else if (currentNum < orderQuery.getOrderSum()) {
                minIdx = midIdx;
            } else {
                rtn = midIdx + 1;
                break;
            }
        }

        return rtn;
    }

    private static int getInsertDescIndex(List<OrderQuery> list, OrderQuery orderQuery) {
        int rtn = -1;

        //处理边缘点
        if (list.size() <= 0 || list.get(0).getOrderSum() < orderQuery.getOrderSum()) {
            return 0;
        }
        if (list.get(list.size() - 1).getOrderSum() >= orderQuery.getOrderSum()) {
            return list.size();
        }

        //常规处理
        int minIdx = 0;
        int maxIdx = list.size() - 1;
        while (maxIdx > minIdx) {
            //中间数据处理
            if (minIdx + 1 == maxIdx) {
                rtn = maxIdx;
                break;
            }

            int midIdx = (minIdx + maxIdx) / 2;
            double currentNum = list.get(midIdx).getOrderSum();
            if (currentNum > orderQuery.getOrderSum()) {
                minIdx = midIdx;
            } else if (currentNum < orderQuery.getOrderSum()) {
                maxIdx = midIdx;
            } else {
                rtn = midIdx + 1;
                break;
            }
        }

        return rtn;
    }

}

CommonFunc.java

import java.nio.charset.Charset;
import java.util.Random;

public class CommonFunc {

    //private static String dbPath = "\\192.168.1.163\Theme\zuoye\order.nk";

//    public static String psnPath = "D:\test\person.nk";
//    public static String psnIdxPath = "D:\test\person.nk.name";
//    public static String orderPath = "D:\test\order.nk";
//    public static String orderIdxPath = "D:\test\order.nk.personid";
//    public static String orderIdxAmountPath = "D:\test\order.nk.amount";
//    public static String tempPath = "D:\test\temp.nk";

    public static String psnPath = "\\192.168.1.163\Theme\zuoye\person.nk";
    public static String psnIdxPath = "\\192.168.1.163\Theme\zuoye\person.nk.name";
    public static String orderPath = "\\192.168.1.163\Theme\zuoye\order.nk";
    public static String orderIdxPath = "\\192.168.1.163\Theme\zuoye\order.nk.personid";
    public static String orderIdxAmountPath = "\\192.168.1.163\Theme\zuoye\order.nk.amount";
    public static String tempPath = "\\192.168.1.163\Theme\zuoye\temp.nk";

    public static int psnIdLen = 8;
    public static int nameLen = 12;
    public static int orderIdLen = 8;
    public static int personIdLen = 8;
    public static int amountLen = 8;
    public static int tempLen = 8;

    private static String firstName = "赵钱孙李周吴郑王冯陈褚卫蒋沈韩杨朱秦尤许何吕施张孔曹严华金魏陶姜戚谢邹喻柏水窦章云苏潘葛奚范彭郎鲁韦昌马苗凤花方俞任袁柳酆鲍史唐费廉岑薛雷贺倪汤滕殷罗毕郝邬安常乐于时傅皮卞齐康伍余元卜顾孟平黄和穆萧尹姚邵湛汪祁毛禹狄米贝明臧计伏成戴谈宋茅庞熊纪舒屈项祝董梁杜阮蓝闵席季麻强贾路娄危江童颜郭梅盛林刁钟徐邱骆高夏蔡田樊胡凌霍虞万支柯咎管卢莫经房裘缪干解应宗宣丁贲邓郁单杭洪包诸左石崔吉钮龚程嵇邢滑裴陆荣翁荀羊於惠甄魏加封芮羿储靳汲邴糜松井段富巫乌焦巴弓牧隗山谷车侯宓蓬全郗班仰秋仲伊宫宁仇栾暴甘钭厉戎祖武符刘姜詹束龙叶幸司韶郜黎蓟薄印宿白怀蒲台从鄂索咸籍赖卓蔺屠蒙池乔阴郁胥能苍双闻莘党翟谭贡劳逄姬申扶堵冉宰郦雍却璩桑桂濮牛寿通边扈燕冀郏浦尚农温别庄晏柴瞿阎充慕连茹习宦艾鱼容向古易慎戈廖庚终暨居衡步都耿满弘匡国文寇广禄阙东殴殳沃利蔚越夔隆师巩厍聂晁勾敖融冷訾辛阚那简饶空曾毋沙乜养鞠须丰巢关蒯相查后江红游竺权逯盖益桓公万俟司马上官欧阳夏侯诸葛闻人东方赫连皇甫尉迟公羊澹台公冶宗政濮阳淳于仲孙太叔申屠公孙乐正轩辕令狐钟离闾丘长孙慕容鲜于宇文司徒司空亓官司寇仉督子车颛孙端木巫马公西漆雕乐正壤驷公良拓拔夹谷宰父谷粱晋楚阎法汝鄢涂钦段干百里东郭南门呼延归海羊舌微生岳帅缑亢况后有琴梁丘左丘东门西门商牟佘佴伯赏南宫墨哈谯笪年爱阳佟第五言福百家姓续";
    private static String girl = "秀娟英华慧巧美娜静淑惠珠翠雅芝玉萍红娥玲芬芳燕彩春菊兰凤洁梅琳素云莲真环雪荣爱妹霞香月莺媛艳瑞凡佳嘉琼勤珍贞莉桂娣叶璧璐娅琦晶妍茜秋珊莎锦黛青倩婷姣婉娴瑾颖露瑶怡婵雁蓓纨仪荷丹蓉眉君琴蕊薇菁梦岚苑婕馨瑗琰韵融园艺咏卿聪澜纯毓悦昭冰爽琬茗羽希宁欣飘育滢馥筠柔竹霭凝晓欢霄枫芸菲寒伊亚宜可姬舒影荔枝思丽 ";
    private static String boy = "伟刚勇毅俊峰强军平保东文辉力明永健世广志义兴良海山仁波宁贵福生龙元全国胜学祥才发武新利清飞彬富顺信子杰涛昌成康星光天达安岩中茂进林有坚和彪博诚先敬震振壮会思群豪心邦承乐绍功松善厚庆磊民友裕河哲江超浩亮政谦亨奇固之轮翰朗伯宏言若鸣朋斌梁栋维启克伦翔旭鹏泽晨辰士以建家致树炎德行时泰盛雄琛钧冠策腾楠榕风航弘";

    /**
     * 随机获取中文名字
     *
     * @return
     */
    public static String getPersonName() {

        String nameStr = getRandomNum(2) == 1 ? boy : girl;

        int firstRandom = getRandomNum(firstName.length() - 1);
        String first = firstName.substring(firstRandom, firstRandom + 1);
        int secondRandom = getRandomNum(nameStr.length() - 1);
        String second = nameStr.substring(secondRandom, secondRandom + 1);
        int thridRandom = getRandomNum(nameStr.length() - 1);
        String third = nameStr.substring(thridRandom, thridRandom + 1);

        return first.concat(second).concat(third);
    }

    /**
     * 随机获取PersonID
     *
     * @return
     */
    public static long getRandomPersonId(int max) {
        return getRandomNum(max) + 1;
    }

    /**
     * 获取随机数，不包含传入的最大数
     *
     * @param maxNum
     * @return
     */
    public static int getRandomNum(int maxNum) {
        return (int) (Math.random() * maxNum);
    }

    /**
     * 获取Double类型的随机数
     *
     * @param maxNum
     * @return
     */
    public static double getRandomDouble(int maxNum) {
        Random randomno = new Random();
        return randomno.nextDouble() * maxNum;
    }

    public static byte[] getBytes(long data) {
        byte[] bytes = new byte[8];
        bytes[7] = (byte) (data & 0xff);
        bytes[6] = (byte) ((data >> 8) & 0xff);
        bytes[5] = (byte) ((data >> 16) & 0xff);
        bytes[4] = (byte) ((data >> 24) & 0xff);
        bytes[3] = (byte) ((data >> 32) & 0xff);
        bytes[2] = (byte) ((data >> 40) & 0xff);
        bytes[1] = (byte) ((data >> 48) & 0xff);
        bytes[0] = (byte) ((data >> 56) & 0xff);
        return bytes;
    }

    public static byte[] getBytes(int data) {
        byte[] bytes = new byte[4];
        bytes[3] = (byte) (data & 0xff);
        bytes[2] = (byte) ((data & 0xff00) >> 8);
        bytes[1] = (byte) ((data & 0xff0000) >> 16);
        bytes[0] = (byte) ((data & 0xff000000) >> 24);
        return bytes;
    }

    public static byte[] getBytes(double data) {
        long intBits = Double.doubleToLongBits(data);
        return getBytes(intBits);
    }

    public static byte[] getBytes(String data, int len) {
        return getBytes(data, len, "UTF-8");
    }

    public static byte[] getBytes(String data, int len, String charsetName) {
        byte[] rtn = new byte[len];

        Charset charset = Charset.forName(charsetName);
        byte[] strByte = data.getBytes(charset);
        //取小的数据
        int copyLen = strByte.length < len ? strByte.length : len;
        System.arraycopy(strByte, 0, rtn, 0, copyLen);

        return rtn;
    }

    public static long getLong(byte[] bytes) {
        return (0xffL & (long) bytes[7]) |
                (0xff00L & ((long) bytes[6] << 8)) |
                (0xff0000L & ((long) bytes[5] << 16)) |
                (0xff000000L & ((long) bytes[4] << 24)) |
                (0xff00000000L & ((long) bytes[3] << 32)) |
                (0xff0000000000L & ((long) bytes[2] << 40)) |
                (0xff000000000000L & ((long) bytes[1] << 48)) |
                (0xff00000000000000L & ((long) bytes[0] << 56));
    }

    public static int getInt(byte[] bytes) {
        return (0xff & bytes[3]) |
                (0xff00 & (bytes[2] << 8)) |
                (0xff0000 & (bytes[1] << 16)) |
                (0xff000000 & (bytes[0] << 24));
    }

    public static double getDouble(byte[] bytes) {
        long l = getLong(bytes);
        return Double.longBitsToDouble(l);
    }

    public static String getString(byte[] bytes) {
        return getString(bytes, "UTF-8");
    }

    public static String getString(byte[] bytes, String charsetName) {
        Charset charset = Charset.forName(charsetName);
        return new String(bytes, charset).trim();
    }
}

OrderQuery.java

public class OrderQuery {

    private String personName;
    private int OrderCount;
    private double OrderSum;

    public String getPersonName() {
        return personName;
    }

    public void setPersonName(String personName) {
        this.personName = personName;
    }

    public int getOrderCount() {
        return OrderCount;
    }

    public void setOrderCount(int orderCount) {
        OrderCount = orderCount;
    }

    public double getOrderSum() {
        return OrderSum;
    }

    public void setOrderSum(double orderSum) {
        OrderSum = orderSum;
    }
}

Person.java

public class Person {

    private long personId;
    private String name;

    public long getPersonId() {
        return personId;
    }

    public void setPersonId(long personId) {
        this.personId = personId;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }
}

Order.java

public class Order {

    private long orderId;
    private long personId;
    private double amount;

    public long getOrderId() {
        return orderId;
    }

    public void setOrderId(long orderId) {
        this.orderId = orderId;
    }

    public long getPersonId() {
        return personId;
    }

    public void setPersonId(long personId) {
        this.personId = personId;
    }

    public double getAmount() {
        return amount;
    }

    public void setAmount(double amount) {
        this.amount = amount;
    }
}