Just do it this way
public ResultSet insert(AldermanBean bean)
{
Connection con;
Statement stmt;
ResultSet rs;
String url = "jdbc racle:thin:@ServerNameRemoved";
String sql = "INSERT INTO ALDERMAN VALUES(AldermanID.NextVal," + bean.getFirstName() + ", " + bean.getMiddleName() + ", " + bean.getLastName() + ", " + bean.getSuffixID() + ", " + bean.getWardID() + ", " + bean.getActive() + ")";
String query = "Select AldermanID, FName, MName, LName, SuffixID," +" WardID, Active From Alderman;";
try {
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); con = DriverManager.getConnection(url,"boauser", "boauser");
stmt = con.createStatement();
stmt.executeUpdate(sql);
rs = stmt.executeQuery(query);
}
catch (SQLException sqle)
{
System.err.print("SQL Exception: " + sqle.getMessage());
}
finally
{
try
{
stmt.close();
con.close();
}
catch(Exception e)
{}
}
return rs ;
}
let me know if it is still failing to compile