* @author manchini
*/
public class modeloManipulaSQL {
public static void main(String[] args){
Transacao t = new Transacao();
try{
t.begin();
MusicaGerencia.mapearDiretorio(new File("D:/Users/manchini/Music/Minhas músicas/"), t,null,0);
SQL sql = new SQL();
sql.add("SELECT * from musica");
ResultSet rs = t.executeQuery(sql.getSql());
while(rs.next()){
System.out.println(rs.getString("id"));
System.out.println(rs.getString("nome"));
System.out.println(rs.getString("caminho"));
System.out.println(rs.getString("img"));
System.out.println("******************************");
}
t.commit();
}catch(Exception ex){
ex.printStackTrace();
t.rollback();
}
}