Advertisement
Guest User

java utf8

a guest
Jul 26th, 2016
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.02 KB | None | 0 0
  1. public class Meter {
  2.  
  3. public static void main(String[] args) {
  4. // TODO Auto-generated method stub
  5. ServerConnector sc = new OracleServerConnector(USER,PASSWORD);
  6. Manager manager = new Manager(sc);
  7. FileReader fr = null;
  8. BufferedReader br = null;
  9. StringTokenizer st = null;
  10. String linea = "";
  11. String sentencia="";
  12. manager.openConnection();
  13. int numPais =0;
  14. try {
  15. fr = new FileReader("F:\\proyectosEclipse\\ConexionBasica\\src\\paises.csv");
  16. br = new BufferedReader(fr);
  17. while ((linea = br.readLine()) != null) {
  18. st = new StringTokenizer(linea, ",");
  19. sentencia = "insert into paises (name,nombre,idpais) values ('";
  20. while (st.hasMoreTokens()) {
  21. sentencia = sentencia + st.nextToken() + "','" + st.nextToken() + "'," + numPais;
  22. st.nextToken();
  23. }
  24. sentencia = sentencia + ")";
  25. numPais = numPais +1;
  26. manager.ExecuteNonQuery(sentencia);
  27.  
  28.  
  29. }
  30.  
  31. } catch (Exception e) {
  32. e.printStackTrace();
  33. }
  34. manager.closeConnection(false);
  35. }
  36.  
  37. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement