java exception 行号_java – 允许范围以外的行号(65536)无效(0..65535)

我正在从文本文件中读取整数，将它们作为查询的输入，并获取查询输出并写入xls文件。

ResultSet rs;

Connection con = null;

PreparedStatement ps = null;

int person_org_id, external_person_org_id;

File f = null;

Scanner scan = null;

try {

System.out.println("----------checkpoint-----------");

Class.forName("oracle.jdbc.driver.OracleDriver");

System.out.println("----------checkpoint 1-----------");

con = DriverManager.getConnection("jdbc:oracle:thin:@ksdjf.kjdlk.jkd.com:2222:edb", "aaaaa", "aaaa");

System.out.println("----------checkpoint 2 ----------");

if (con == null) {

System.out.println("unable to connect to database");

}

System.out.println("----------checkpoint 3::connected to database---------");

StringBuffer sql = new StringBuffer();

sql.append("select abd from edb.abd where customer_id=510 and person_org_id =? ");

ps = con.prepareStatement(sql.toString());

HSSFWorkbook wb = new HSSFWorkbook();

HSSFSheet sheet = wb.createSheet("Excel Sheet");

HSSFRow rowhead = sheet.createRow(0);

rowhead.createCell(0).setCellValue("ABC");

rowhead.createCell(1).setCellValue("DEF");

f = new File("/tmp/contacts.txt");

scan = new Scanner(f);

int index=1;

while (scan.hasNextInt()) {

person_org_id = scan.nextInt();

ps.setInt(1,person_org_id);

rs= ps.executeQuery();

while (rs.next()) {

external_person_org_id = rs.getInt(1);

HSSFRow row = sheet.createRow(index);

row.createCell(0).setCellValue(person_org_id);

row.createCell(1).setCellValue(external_person_org_id);

index++;

}

}

FileOutputStream fileOut = new FileOutputStream(new File("/tmp/External_contact_id.xls"));

wb.write(fileOut);

fileOut.close();

System.out.println("--------checkpoint 4:: writing data to xls completed------------");

}

catch (Exception e) {

System.out.println(e.getMessage());

}

我收到错误无效的行号(65536)超出允许范围(0..65535)

我的contacts.txt文件有大约36000个数字。