1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| try {
BufferedReader br=new BufferedReader(new FileReader(path));
String line;
while ((line=br.readLine())!=null){
String[]value=line.split(";");//separator
String sql="insert into incident (id_incident, status, vendor, priority, criticality_tt, title, description, affected_ci, affected_service, assignee, assignment_group, reassignment_count, open_time, close_time, outage_start, reassignment_time, outage_end, impact, solution, assignment_manager_name, assign_deptmgr, opened_by, closed_by, closure_code, update_action, last_updated_by)"
+"values ('"+value[0]+"','"+value[1]+"','"+value[2]+"','"+value[3]+"','"+value[4]+"','"+value[5]+"','"+value[6]+"','"+value[7]+"','"+value[8]+"','"+value[9]+"','"+value[10]+"','"+value[11]+"','"+value[12]+"','"+value[13]+"','"+value[14]+"','"+value[15]+"','"+value[16]+"','"+value[17]+"','"+value[18]+"','"+value[19]+"','"+value[20]+"','"+value[21]+"','"+value[22]+"','"+value[23]+"','"+value[24]+"','"+value[25]+"',)";
java.sql.PreparedStatement pst=con.prepareStatement(sql);
pst.executeUpdate();
}
br.close();
}
catch (Exception e){
JOptionPane.showMessageDialog(this,e);
} |
Partager