Deleting from MySQL database

[darrenstyles88]

Hi,
I have a hr recruitment application that lists job vacancies.I want to be able to delete a job from the database when an action button is clicked.
I am using a mysql database with struts and cannot delete specific records!! It has me annoyed all night!!:(
Here is the action i am calling while passing in the ID of the job I want to delete:
It is running through the action but does not delete the job from the database:(

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class RemoveJob {
private int IDjob;
private String result ="SUCCESS";
private Connection connection;
private Statement statement;

public RemoveJob() {

}

private void loadDriver() throws ClassNotFoundException{
Class.forName("com.mysql.jdbc.Driver");
}

// Setup the connection with the DB
private void makeConnection() throws SQLException {
connection=DriverManager.getConnection("jdbc:mysql ://localhost/portal?user=user&password=password");
}

public void buildStatement() throws SQLException {
statement = connection.createStatement();
}

//execute update


public String execute() throws Exception {
try {
this.loadDriver();
this.makeConnection();
String sql = "DELETE * FROM portal.job where job.IDjob ='"+IDjob+"'";
int delete = statement.executeUpdate(sql);
System.out.println("in try");

}
finally{
this.closeConnections();
return result;
}
}

/**
* Closes prepared statements and the connection to the database.
*/
public void closeConnections() {
try {
connection.close();
}
catch (SQLException e) {
System.out.println("");
e.printStackTrace();
}
}

[DarrylBurke]

Forum Rules
Guide For New Members
BB Code List - Java Programming Forum

db

[darrenstyles88]

Forum Rules
Guide For New Members
BB Code List - Java Programming Forum

db

What is wrong with the db then darryl?!Thanks

[Tolls]

Darryl is pointing out that you clearly haven't read the forum rules.
One of which is to post code using [code] tags [/code] since people generally won't read unformatted code.

I will say you need more debug code in there.
You don't (for example) print the value of the id you're trying to delete.
ALso you have a 'return' statement in a finally block. That's a very wrong.
That should be after the finally block.
I'll explain that if you want.

[Tolls]

That's a very wrong.

And I appear to have become Chico Marx.