查找 XML 中的多个属性

发布于 2024-07-10 14:47:00 字数 529 浏览 10 评论 0原文

我正在尝试搜索 XML 中的多个属性：

<APIS>
  <API Key="00001">
    <field Username="username1" UserPassword="password1" FileName="Filename1.xml"/>
    <field Username="username2" UserPassword="password2" FileName="Filename2.xml"/>
    <field Username="username3" UserPassword="password3" FileName="Filename3.xml"/>
  </API>
</APIS>

我需要检查“字段”中的用户名和用户密码值是否都是我与数据集值进行比较的值，是否有一种方法可以检查多个属性（AND 条件））而不编写我自己的使用标志和打破循环的逻辑。

XMLDoc 是否有内置函数可以做到这一点？任何帮助，将不胜感激！

原文

I'm trying to search multiple attributes in XML :

<APIS>
  <API Key="00001">
    <field Username="username1" UserPassword="password1" FileName="Filename1.xml"/>
    <field Username="username2" UserPassword="password2" FileName="Filename2.xml"/>
    <field Username="username3" UserPassword="password3" FileName="Filename3.xml"/>
  </API>
</APIS>

I need to check if in the "field" the Username AND UserPassword values are both what I am comparing with my Dataset values, is there a way where I can check multiple attributes (AND condition) without writing my own logic of using Flags and breaking out of loops.

Is there a built in function of XMLDoc that does it? Any help would be appreciated!

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

踏月而来 2024-07-17 14:47:00

要在您提供的 XML 片段中搜索您想要的内容，您需要以下 XPath 表达式：

/APIS/API/field[@Username='username1' and @UserPassword='password1']

如果用户名和密码匹配，则该表达式将返回某些内容，如果不匹配，则不返回某些内容。

当然，XPath 表达式只是一个字符串 - 例如，您可以使用输入表单字段的值动态构建它。

如果您告诉您所在的语言/环境，此处发布的代码示例可能会变得更加具体。

这是在 C# 中执行此操作的一种方法（VB.NET 类似）：

// make sure the following line is included in your class
using System.Xml;

XmlDocument xmldoc = new XmlDocument();
xmldoc.Load("your XML string or file");

string xpath = "/APIS/API/field[@Username='{0}' and @UserPassword='{1}']";
string username = "username1";
string password = "password1";

xpath = String.Format(xpath, username, password);
XmlNode userNode = xmldoc.SelectSingleNode(xpath);

if (userNode != null)
{
  // found something with given user name and password
}
else
{
  // username or password incorrect
}

请注意，用户名和密码都不能包含单引号，否则上面的示例将失败。以下是有关此特性的一些信息。

Microsoft 还提供了一个操作方法：如何：使用 System.Xml.XmlDocument 类执行 XPath Visual C# .NET 中的查询

To search for what you want in the snippet of XML you provided, you would need the following XPath expression:

/APIS/API/field[@Username='username1' and @UserPassword='password1']

This would either return something, if user name and password match - or not if they don't.

Of couse the XPath expression is just a string - you can build it dynamically with values that were entered into a form field, for example.

If you tell what language/environment you are in, code samples posted here will likely get more specific.

This is a way to do it in C# (VB.NET is analogous):

// make sure the following line is included in your class
using System.Xml;

XmlDocument xmldoc = new XmlDocument();
xmldoc.Load("your XML string or file");

string xpath = "/APIS/API/field[@Username='{0}' and @UserPassword='{1}']";
string username = "username1";
string password = "password1";

xpath = String.Format(xpath, username, password);
XmlNode userNode = xmldoc.SelectSingleNode(xpath);

if (userNode != null)
{
  // found something with given user name and password
}
else
{
  // username or password incorrect
}

Be aware that neither user names nor passwords can contain single quotes, or the above example will fail. Here is some info on this peculiarity.

There is also a How-To from Microsoft available: HOW TO: Use the System.Xml.XmlDocument Class to Execute XPath Queries in Visual C# .NET

回复收藏 0 原文