1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81
|
protected void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException
{
/***************function to read file***********************/
// We are going to read a file called configuration.properties. This
// file is placed under the WEB-INF directory.
String requete_load="";
String fichier = req.getParameter("fichier"); //fichier = chemin + nom fichier
String ligne = "";
File file = new File(fichier).getAbsoluteFile();
System.out.println("file:" + file);
String fileName = file.getName();
FileInputStream fis = new FileInputStream(fichier);
resp.setContentType("text/html");
DataSource dataSource = null;
try
{
System.out.println("Test1:");
dataSource = (DataSource)new InitialContext().lookup("java:jdbc/XXXX");
}
catch (NamingException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
if (dataSource != null)
{
Connection connection;
try
{
// Connection to datasource
connection = dataSource.getConnection();
// Query statement setting
Statement statement = connection.createStatement();
BufferedReader reader = new BufferedReader(new InputStreamReader(fis));
//BufferedReader reader = new BufferedReader(new FileReader(new File(fichier)));
System.out.println("Path_fichier:" + fichier);
System.out.println("Nomfichier:" + fileName);
if (fileName != null)
{
PrintWriter writer = resp.getWriter();
// We read the file line by line and later will be displayed on the browser page.
while ((ligne = reader.readLine()) != null)
{
writer.println(ligne);
String num_action = req.getParameter("num_action");
requete_load = " INSERT INTO MaTable (num_action,Y)"
+ " VALUES ('"+num_action+"','"+ligne+"')";
System.out.println("requete_load: "+ requete_load );
System.out.println("requete_load num_action: "+ num_action );
statement.executeUpdate(requete_load);
}
reader.close();
}
else
{
System.out.println("pas de traitement");
}
connection.close();
}
catch (SQLException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
}
req.getRequestDispatcher("./display/maPage.jsp").forward(req, resp);
} |
Partager