Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class Meter {
- public static void main(String[] args) {
- // TODO Auto-generated method stub
- ServerConnector sc = new OracleServerConnector(USER,PASSWORD);
- Manager manager = new Manager(sc);
- FileReader fr = null;
- BufferedReader br = null;
- StringTokenizer st = null;
- String linea = "";
- String sentencia="";
- manager.openConnection();
- int numPais =0;
- try {
- fr = new FileReader("F:\\proyectosEclipse\\ConexionBasica\\src\\paises.csv");
- br = new BufferedReader(fr);
- while ((linea = br.readLine()) != null) {
- st = new StringTokenizer(linea, ",");
- sentencia = "insert into paises (name,nombre,idpais) values ('";
- while (st.hasMoreTokens()) {
- sentencia = sentencia + st.nextToken() + "','" + st.nextToken() + "'," + numPais;
- st.nextToken();
- }
- sentencia = sentencia + ")";
- numPais = numPais +1;
- manager.ExecuteNonQuery(sentencia);
- }
- } catch (Exception e) {
- e.printStackTrace();
- }
- manager.closeConnection(false);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement