I have a Exception in DataTable.
I will excel to DataBase import, but i have java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 16
I write in code who is the Exception.
My code:
- Code: Select all
void feltolt()
{
Connection conn = null;
Statement stmt = null;
try
{
try
{
Class.forName("com.mysql.cj.jdbc.Driver"); //Driver meghívása
}
catch (Exception e)
{
System.out.println(e);
String hibauzenet2 = e.toString();
JOptionPane.showMessageDialog(null, hibauzenet2, "Hiba üzenet", 2);
}
conn = DriverManager.getConnection("jdbc:mysql://172.20.22.29", "veasquality", "kg6T$kd14TWbs9&gd"); //kapcsolat létrehozása
stmt = conn.createStatement(); //csatlakozás
PreparedStatement statement = conn.prepareStatement("INSERT INTO qualitydb.Gyartasi_adatok (ID, VT_azon, Cikkszam, Vevo, Vevoi_megnev, Datum, Muszak, Ellenor_neve, Hibagyujtes_helye,"
+ "Felajanlott, Minta_nagysag, PCB_sorszam, Hibakod, Hiba_megnevezes, Pozicio, Hibak_szam, Sor) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
Workbook workbook = new Workbook();
workbook.loadFromFile("c:\\Users\\kovacs.zoltan\\Desktop\\Mappák\\Java projekt\\minden.xlsx");
Worksheet sheet = workbook.getWorksheets().get(0);
DataTable dataTable = sheet.exportDataTable(); // <== Here is the Exception
for (int i = 0; i < dataTable.getRows().size(); i++)
{
for (int j = 0; j < dataTable.getColumns().size(); j++)
{
statement.setString(j + 1, dataTable.getRows().get(i).getString(j));
}
statement.executeUpdate();
}
statement.close();
conn.close();
}
catch (SQLException e1) //kivétel esetén történik
{
e1.printStackTrace();
String hibauzenet2 = e1.toString();
JOptionPane.showMessageDialog(null, hibauzenet2 + "\n \n A Mentés sikertelen!!", "Hiba üzenet", 2);
}
catch (Exception e)
{
e.printStackTrace();
String hibauzenet2 = e.toString();
JOptionPane.showMessageDialog(null, hibauzenet2, "Hiba üzenet", 2);
}
finally //finally rész mindenképpen lefut, hogy hiba esetén is lezárja a kacsolatot
{
try
{
if (stmt != null)
conn.close();
}
catch (SQLException se) {}
try
{
if (conn != null)
conn.close();
}
catch (SQLException se)
{
se.printStackTrace();
}
}
System.out.println("Minden kész!");
}
What make i wrong?
