//fiz esse código e gostaria de saber se existe alguma coisa errada.Obrigado
public void delete() {
String comandoSQL = "DELETE * FROM recorte WHERE nome ='" + getNome() + "'";
Statement stm = Conector.reservaStatement();
try {
stm.executeUpdate(comandoSQL);
} catch (SQLException e) {
e.printStackTrace();
}
}
public void alterar() {
Statement stm = Conector.reservaStatement();
String comandoSQL = "UPDATE recorte SET nome='" + getNome() + "', id='" + getId() + "' WHERE marca='" + getNome();
try {
stm.executeUpdate(comandoSQL);
} catch (SQLException e) {
e.printStackTrace();
}
finally {
Conector.liberaStatement();
}
}
public void inserir() {
Statement stm = Conector.reservaStatement();
String comandoSQL = "INSERT INTO recorte (nome,id,fone) values('"+
getNome() + "', "
+ " '" + getId() + "', "
+ " '" + getFone() + "')";
try {
stm.executeUpdate(comandoSQL);
} catch (SQLException e) {
e.printStackTrace();
}
finally {
try {
stm.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}