e262. deleting a row from a database table.txt

来自「这里面包含了一百多个JAVA源文件」· 文本 代码 · 共 21 行

try {
        // Create a statement
        Statement stmt = connection.createStatement();
    
        // Prepare a statement to insert a record
        String sql = "DELETE FROM my_table WHERE col_string='a string'";
    
        // Execute the delete statement
        int deleteCount = stmt.executeUpdate(sql);
        // deleteCount contains the number of deleted rows
    
        // Use a prepared statement to delete
    
        // Prepare a statement to delete a record
        sql = "DELETE FROM my_table WHERE col_string=?";
        PreparedStatement pstmt = connection.prepareStatement(sql);
        // Set the value
        pstmt.setString(1, "a string");
        deleteCount = pstmt.executeUpdate();
        System.err.println(e.getMessage());