Thread: My Access Database "memberID" now is until M15 , i want to get the next memberID "M16" , how to get it ?

This is my insert query~~ i need to get the next MemberID and display it in textfield(memberID_a).

query = "INSERT INTO Membership VALUES ('" +memberID_a.getText() + "','" +memberName_a.getText() + "','" + icNo_a.getText() + "','" + gender_a.getText() +"','" + birthday_a.getText() +"','" + telephoneNo_a.getText() + "','" + mobileNo_a.getText() + "','" + email_a.getText() + "','" + address_a.getText() + "','" + postalCode_a.getText() + "','" + state_a.getText() + "','" + country_a.getText() + "','" + memberPoint_a.getText() + "');";



try{

stmtInsert = conn.createStatement();
stmtInsert.executeUpdate(query);

} catch(Exception ex){
JOptionPane.showMessageDialog(null,"ERROR"+ex.toSt ring(),"ERROR",JOptionPane.ERROR_MESSAGE);
}

Do you have a question?
Please see the Announcements page for the use of code tags

Hi, can you be more specify on what you want?

if by saying "get" you want to perform a "Select on DB" you can use this code

String query = "select memberID_a from Membership where memberID_a = '"+memberID_a.getText()+"'";

   public void load_text(String query) {
        try {
            Statement st = conn.createStatement();
            ResultSet rs = st.executeQuery(query);
            while (rs.next()) {
               memberID_a.setText(rs.getString("memberID_a"));
            }
            con.close();
 
        } catch (Exception e) {
            System.out.println("Error aqui: " + e);
 
        }
 
    }