| 12
 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