Non mi da nessun errore, ma il database non si riempe!!codice:package beans; import java.io.BufferedReader; import java.io.FileReader; import java.sql.Connection; import java.sql.DriverManager; import java.sql.Statement; import java.util.ArrayList; public class Main { public static void main (String [] args) throws Exception { Class.forName("org.sqlite.JDBC"); Connection c = DriverManager.getConnection("jdbc:sqlite:db1.db"); Statement s = c.createStatement(); ArrayList<String> indirizzi= new ArrayList<String>(); BufferedReader br = new BufferedReader( new FileReader("Docs/DB.txt")); String line; while((line=br.readLine())!=null){ String [] w=line.split(";"); String nome=w[0].trim(); String localita=w[1].trim(); String telefono=w[2].trim(); indirizzi.add(nome); indirizzi.add(localita); indirizzi.add(telefono); }br.close(); s.executeUpdate("create table places (" + "nome1 VARCHAR(50) PRIMARY KEY, " + "localita1 VARCHAR(50), " + "telefono1 VARCHAR(50))"); s.executeUpdate("insert into places(nome1,localita1,telefono1) values(' + nome +', ' + localita + ', ' + telefono+')"); } }![]()
![]()