codice:
import java.util.*;
import java.sql.*;
public class cancella {
public static void main(String[] args) {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\Programmi\\dbricette_1_3_049.mdb");
String query = "Select Ingredienti from Ricette";
Statement s = con.createStatement();
ResultSet rs = s.executeQuery(query);
while(rs.next()){
String ingredienti= rs.getString("Ingredienti");
Scanner parser = new Scanner(ingredienti);
parser.useDelimiter("\\\\r");
System.out.println(ingredienti);
while(parser.hasNext()) {
String ingrediente = parser.next();
ingrediente=ingrediente.substring(ingrediente.lastIndexOf("=")+1);
Statement stm = con.createStatement();
stm.executeUpdate("INSERT INTO Ing (Ingredienti) VALUES (ingrediente)");
}
}
con.close();
}
catch (Exception ex) {
System.out.println(ex.getMessage());
}
}}