使用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());
        // 根据整数值转换成字符串
        int paymentType = person.getInt_TypeOfPayment();
        String paymentMethod;
        switch (paymentType) {
            case 1:
                paymentMethod = "Credit Card";
                break;
            case 2:
                paymentMethod = "Debit Card";
                break;
            default:
                paymentMethod = "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 paymentType;
    switch (paymentMethod) {
        case "Credit Card":
            paymentType = 1;
            break;
        case "Debit Card":
            paymentType = 2;
            break;
        default:
            paymentType = 0; // 或者其他表示未知支付方式的值
    }
    person.setIntTypeOfPayment(paymentType);
    // ...
}

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

public class PaymentConverter {

    private static final String DB_URL = "jdbc:mysql://localhost:3306/your_database";
    private static final String DB_USER = "your_user";
    private static final String DB_PASSWORD = "your_password";

    public static void main(String[] args) {
        try {
            // 注册 JDBC 驱动
            Class.forName("com.mysql.cj.jdbc.Driver");

            // 获取数据库连接
            Connection connection = DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD);

            // 插入数据
            insertPayment(connection, "John Doe", 1); // 1 代表 Credit Card

            // 查询数据
            queryPayment(connection, "John Doe");

            // 关闭连接
            connection.close();

        } catch (ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        }
    }

    public static void insertPayment(Connection connection, String name, int paymentType) throws SQLException {
        String insertSQL = "INSERT INTO Payments (name, payment_method) VALUES (?, ?)";
        PreparedStatement preparedStatement = connection.prepareStatement(insertSQL);
        preparedStatement.setString(1, name);

        String paymentMethod;
        switch (paymentType) {
            case 1:
                paymentMethod = "Credit Card";
                break;
            case 2:
                paymentMethod = "Debit Card";
                break;
            default:
                paymentMethod = "Unknown";
        }
        preparedStatement.setString(2, paymentMethod);

        preparedStatement.executeUpdate();
        System.out.println("Inserted payment for " + name + " with method: " + paymentMethod);
    }

    public static void queryPayment(Connection connection, String name) throws SQLException {
        String querySQL = "SELECT name, payment_method FROM Payments WHERE name = ?";
        PreparedStatement preparedStatement = connection.prepareStatement(querySQL);
        preparedStatement.setString(1, name);

        ResultSet resultSet = preparedStatement.executeQuery();
        while (resultSet.next()) {
            String retrievedName = resultSet.getString("name");
            String paymentMethod = resultSet.getString("payment_method");
            System.out.println("Retrieved payment for " + retrievedName + " with method: " + paymentMethod);
        }
    }
}