// INSERT MOVIE IN DATABASE AND TABLEMODEL
public void insertNewMovie(Movie movie) {
String myInsert =
"insert into "
+ table
+ " (title,director,year,other,loc) values (\""
+ movie.title
+ "\",\""
+ movie.director
+ "\",\""
+ movie.year
+ "\",\""
+ movie.other
+ "\",\""
+ movie.loc
+ "\")";
try {
if (cargaControlador() > -1) {
if (open("jdbc:mysql://" + host + ":" + port + "/" + database, user, pass) > -1) {
// System.out.println(myInsert);
movie.check();
if ((insert(myInsert)) > -1) {
movie.id = lastInsertID();
tabModel.addMovie(movie);
} else {
Errors.showError(Errors.DB_INSERT);
Errors.writeError(Errors.DB_INSERT, myInsert + "\n");
}
close();
}
}
} catch (Exception ex) {
ex.printStackTrace();
Errors.showError(Errors.DB_INSERT);
Errors.writeError(Errors.DB_INSERT, myInsert + "\n");
}
}
