How to fix "missing return statement". error?

[Annie Soomro]

Getting "missing return statement" error for following code:

import java.sql.*;
public class DatabaseManager{
  public static int add(String user,String password)throws Exception{
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    Connection con=DriverManager.getConnection("jdbc:odbc:userRecords");
    Statement st=con.createStatement();
    

    String query="insert into UserRecords(userName,pass) values('"+user+"','"+password+"')";
    System.out.println(query);


    st.close();
    con.close();
  }
}

[horace1]

the method header

public static int add(String user,String password)throws Exception{

states it returns an int result therefore the compiler expects a return statement. If you don't intend to rturn a result say the return type is void.