从SQL Server返回更新错误并在Java中捕获它

import java.sql.*;

public class SQLServerExample {
    public static void main(String[] args) {
        String url = "jdbc:sqlserver://localhost:1433;databaseName=mydatabase";
        String username = "username";
        String password = "password";

        try {
            // 加载数据库驱动程序
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

            // 建立数据库连接
            Connection conn = DriverManager.getConnection(url, username, password);

            // 创建Statement对象
            Statement stmt = conn.createStatement();

            // 执行更新操作
            String sql = "UPDATE mytable SET column1 = 'value' WHERE id = 1";
            int rowsAffected = stmt.executeUpdate(sql);

            // 检查更新是否成功
            if (rowsAffected > 0) {
                System.out.println("更新成功");
            } else {
                System.out.println("更新失败");
            }

            // 关闭连接
            stmt.close();
            conn.close();
        } catch (Exception e) {
            // 捕获异常并处理
            e.printStackTrace();
        }
    }
}

try {
    // 执行更新操作
    String sql = "UPDATE mytable SET column1 = 'value' WHERE id = 1";
    int rowsAffected = stmt.executeUpdate(sql);

    // 检查更新是否成功
    if (rowsAffected > 0) {
        System.out.println("更新成功");
    } else {
        System.out.println("更新失败");
    }
} catch (SQLException e) {
    // 捕获SQL Server返回的更新错误
    System.out.println("更新错误：" + e.getMessage());
}