public Movie getMovieByName(String name) {
Movie movie = null;
ResultSet rs;
String mySelect = "select * from " + table + " where title=\"" + name + "\"";
try {
if (cargaControlador() > -1) {
if (open("jdbc:mysql://" + host + ":" + port + "/" + database, user, pass) > -1) {
if (select(mySelect) > -1) {
rs = getRs();
rs.next();
movie = new Movie();
movie.id = (Integer) rs.getObject(Movie.COL_ID + 1);
movie.title = (String) rs.getObject(Movie.COL_TITLE + 1);
if (rs.getObject(Movie.COL_YEAR + 1) != null)
movie.year = rs.getObject(Movie.COL_YEAR + 1).toString();
movie.loc = (String) rs.getObject(Movie.COL_LOC + 1);
movie.director = (String) rs.getObject(Movie.COL_DIR + 1);
movie.other = (String) rs.getObject(Movie.COL_OTHER + 1);
} else {
Errors.writeError(Errors.DB_SELECT, mySelect + "\n");
}
close();
}
}
} catch (Exception ex) {
Errors.showError(Errors.DB_SELECT);
Errors.writeError(Errors.DB_SELECT, mySelect + "\n");
}
return movie;
}
// 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");
}
}