谁能告诉我这个怎么做哦
要求读取XML里面的内容 链接数据库<?xml version="1.0" encoding="utf-8"?>
<Config>
<ServerAddress>.</ServerAddress>
<DBName>DBabc</DBName>
<UserID>sa</UserID>
<PassWord>sa</PassWord>
</Config>
这个是XML里面的内容哦
文件名可以随便取个
--------------------------------------------
要完成下面的内容怎么完成哦。能够读取到XML 连接上数据库,下面代码要完善哦 求指点
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Xml;
using System.IO;
using System.Web;
namespace MyCore
{
public class DBHelper
{
/// <summary>
/// 数据库配置xml对象
/// </summary>
private static XmlDocument XmlDom=new XmlDocument();
/// <summary>
/// 配置文件物理地址
///
/// </summary>
private static string PhysicsPath;
static DBHelper()
{
PhysicsPath = HttpContext.Current.Server.MapPath("Config.xml").ToString();
if (File.Exists(PhysicsPath))
{
//完善代码,加载XmlDom
}
}
/// <summary>
/// 获取连接字符串
/// </summary>
/// <returns></returns>
public static string GetConnectionString()
{
//直接获取默认链接字符串
//return GetDefalutConnectionString();
//从xml获取连接字符串
return "Data Source=" + GetServerAddress() + ";Initial Catalog=" + GetDBName() + ";Persist Security Info=True;User ID=" + GetUserID() + ";Password=" + GetPassWord();
}
/// <summary>
/// 获取默认连接字符串(web.config中connectionStrings节点的ConnectionString的值)
/// </summary>
/// <returns></returns>
public static string GetDefalutConnectionString()
{
return ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
}
/// <summary>
/// 获取服务器地址
/// </summary>
/// <returns></returns>
public static string GetServerAddress()
{
string ServerAddress = "";
//完善代码
return ServerAddress;
}
/// <summary>
/// 设置服务器地址
/// </summary>
/// <param name="newValue">新地址</param>
public static void SetServerAddress(string newValue)
{
//完善代码
}
/// <summary>
/// 获取数据库名称
/// </summary>
/// <returns></returns>
public static string GetDBName()
{
string DBName = "";
//完善代码
return DBName;
}
/// <summary>
/// 设置数据库名称
/// </summary>
/// <param name="newValue">新名称</param>
public static void SetDBName(string newValue)
{
//完善代码
}
/// <summary>
/// 获取用户
/// </summary>
/// <returns></returns>
public static string GetUserID()
{
string UserID = "";
//完善代码
return UserID;
}
/// <summary>
/// 设置用户
/// </summary>
/// <param name="newValue">新用户</param>
public static void SetUserID(string newValue)
{
//完善代码
}
/// <summary>
/// 获取密码
/// </summary>
/// <returns></returns>
public static string GetPassWord()
{
string PassWord = "";
//完善代码
return PassWord;
}
/// <summary>
/// 设置密码
/// </summary>
/// <param name="newValue">新密码</param>
public static void SetPassWord(string newValue)
{
//完善代码
}
}
}
--------------------编程问答-------------------- 有没有人会呀? --------------------编程问答-------------------- <ServerAddress>.</ServerAddress>
<DBName>DBabc</DBName>
<UserID>sa</UserID>
<PassWord>sa</PassWord>
if (File.Exists(PhysicsPath))--------------------编程问答--------------------
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(PhysicsPath);
var address = xmlDoc.SelectSingleNode("//ServerAddress").Value;
var dbName = xmlDoc.SelectSingleNode("//DBName").Value;
var userId = xmlDoc.SelectSingleNode("//UserID").Value;
var passwd = xmlDoc.SelectSingleNode("//PassWord").Value;
}
下面的那些静态方法里面应该怎么填呢
//完善代码
的部分。谢谢了哦 高手 --------------------编程问答-------------------- 自己设个私有类成员,return。
举个例子:
private static string _address;
...
if (File.Exists(PhysicsPath))
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(PhysicsPath);
_address = xmlDoc.SelectSingleNode("//ServerAddress").Value;
}
...
public static string GetServerAddress()
{
return _address;
}
--------------------编程问答-------------------- +1.
补充:.NET技术 , C#