在SQL中更新Jtable中的特定单元格

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class UpdateJTable {
    public static void main(String[] args) {
        // 建立与数据库的连接
        Connection connection = null;
        try {
            connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password");
        } catch (SQLException e) {
            e.printStackTrace();
        }

        // 确定要更新的特定单元格的位置
        int rowIndex = 0; // 行索引
        int colIndex = 1; // 列索引

        // 构建SQL更新语句
        String tableName = "mytable";
        String columnName = "column2";
        String newValue = "new value";
        String condition = "column1 = 'value1'"; // 更新条件

        String sql = "UPDATE " + tableName + " SET " + columnName + " = '" + newValue + "' WHERE " + condition;

        // 执行SQL更新语句
        try {
            Statement statement = connection.createStatement();
            int rowsAffected = statement.executeUpdate(sql);
            System.out.println("更新了 " + rowsAffected + " 行数据");
        } catch (SQLException e) {
            e.printStackTrace();
        }

        // 关闭数据库连接
        try {
            connection.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}