在Java中实现整数到字符串的支付方式转换并存储到MySQL数据库

public int insert(Client person){
    Connection conn =  null;
    PreparedStatement stmt = null;
    int registros = 0;
    try {
        conn = getConnection();
        stmt = conn.prepareStatement(SQL_INSERT);

        stmt.setString(1, person.getStr_Name());
        stmt.setString(2, person.getStr_Lastname());
        // 根据支付类型整数值转换为字符串
        String paymentMethod = (person.getInt_TypeOfPayment() == 1) ? "Credit Card" : (person.getInt_TypeOfPayment() == 2 ? "Debit Card" : "Unknown");
        stmt.setString(3, paymentMethod);

        registros= stmt.executeUpdate();
    } catch (SQLException ex) {
        ex.printStackTrace(System.out);
    }finally{
        try {
            close(stmt);
            close(conn);
        } catch (SQLException ex) {
        }
    }
    return registros;
}

ResultSet rs = stmt.executeQuery(QUERY);
while(rs.next()){
    // ...
    String paymentMethod = rs.getString("MethodOfPayment");
    int payment = "Credit Card".equals(paymentMethod) ? 1 : ("Debit Card".equals(paymentMethod) ? 2 : 0);
    person.setIntTypeOfPayment(payment);
    // ...
}

import javax.persistence.AttributeConverter;
import javax.persistence.Converter;

@Converter(autoApply = true)
public class PaymentMethodConverter implements AttributeConverter<Integer, String> {

    @Override
    public String convertToDatabaseColumn(Integer paymentMethod) {
        if (paymentMethod == null) {
            return null;
        }
        switch (paymentMethod) {
            case 1:
                return "Credit Card";
            case 2:
                return "Debit Card";
            default:
                return "Unknown";
        }
    }

    @Override
    public Integer convertToEntityAttribute(String paymentMethod) {
        if (paymentMethod == null) {
            return null;
        }
        switch (paymentMethod) {
            case "Credit Card":
                return 1;
            case "Debit Card":
                return 2;
            default:
                return 0;
        }
    }
}

import javax.persistence.*;

@Entity
@Table(name = "Client")
public class Client {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    private String name;

    private String lastName;

    @Convert(converter = PaymentMethodConverter.class)
    @Column(name = "MethodOfPayment")
    private Integer typeOfPayment;

    // Getters and setters
}