java mysql 批量查询_Java一次性查询几百万数据的高效方法

publicstaticvoidgetMonthDataList() {

ResultSet rs=null;

Statement stat=null;

Connection conn=null;

List list=newArrayList();try{

conn=createConnection();if(conn!=null){

SimpleDateFormat sdf=newSimpleDateFormat("yyyy-MM-dd");

SimpleDateFormat timesdf=newSimpleDateFormat("yyyy-MM-dd HH:mm:ss");

String nowDate=sdf.format(newDate());

Config.lasttimetext=timesdf.format(newDate());

String lastDate=sdf.format(CreateData.addDaysForDate(newDate(),30));

stat=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);intlastrow=0;intdatanum=0;

String countsql="SELECT count(a.id) FROM trip_special_flight a"+"where a.dpt_date >= to_date('"+nowDate+"','yyyy-mm-dd')"+"and a.