扩展属性
有外键关系时将信息处理成用户可看懂的
利用扩展属性
如：Info表中的民族列显示的是民族代号处理成Nation表中的民族名称
需要在Info类里面扩展一个显示nation名称的属性
例：先前在NationDA里面已经下好了一个代号换成名称的方法
public class Info
{
//扩展的名族名称属性
public string NationName
{
get {
NationDA da = new NationDA();
return da.NationName(this.nation);//this关键字，该对象里面是不是有一个nation
}
}
配置文件（App.config）
换台电脑、数据库名不同时，为了让别的用户也可以运行，把数据连接写在配置文件中，方便修改
例：
App.config中：
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<startup>
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />
</startup>
//key 配置名称
<appSettings>
<add key="connstring" value="server=.;database=mydb;user=sa;pwd=123"/>
</appSettings>
</configuration>
数据连接类中：
public class DBConnect
{
private static string connstring = System.Configuration.ConfigurationSettings.AppSettings["connstring"]; public static SqlConnection Conn
{
get {
return new SqlConnection(connstring);
}
}
}
低版本可以用该方法，高版本可以根据提示更改：
对战游戏
要求：
- 自建数据表（例如：数据表包含：代号，姓名，性别，血量，攻击力，防御力，命中，闪避，等级等字段）
- 需要通过程序向数据表添加人员
- 添加的时候，根据用户输入的名字，自动计算生成相应的血量、攻击力、防御力等（例如，名字的前两个字作为种子生成血量，名字的第一个字作为种子生成攻击力，名字的第二个字作为种子生成防御力等）
- 添加完成用户可以输入两个用户进行对战
- 通过程序逻辑实现对战双方的血量变化并显示（使用随机数浮动攻击防御）
- 最终血量先到达0的失败，胜利的一方属性增加（比如等级level加1，血量加一些，攻击力加一些等）
- 访问数据库采用三个类的模式
数据连接类：
namespace ConsoleApplication1
{
public class DBConnect
{
private static string connstring = System.Configuration.ConfigurationSettings.AppSettings["connstring"];
public static SqlConnection Conn
{
get
{
return new SqlConnection(connstring);
}
}
}
}
实体类：
namespace ConsoleApplication1
{
public class Player
{
private string name;
//玩家姓名
public string Name
{
get { return name; }
set { name = value; }
}
private bool sex;
//玩家性别
public bool Sex
{
get { return sex; }
set { sex = value; }
}
private int lev;
//玩家等级
public int Lev
{
get { return lev; }
set { lev = value; }
}
private int blood;
//血量
public int Blood
{
get { return blood; }
set { blood = value; }
}
private int attack;
//攻击
public int Attack
{
get { return attack; }
set { attack = value; }
}
private int defense;
//防御
public int Defense
{
get { return defense; }
set { defense = value; }
}
private int hit;
//命中
public int Hit
{
get { return hit; }
set { hit = value; }
}
private int dodge;
//闪避
public int Dodge
{
get { return dodge; }
set { dodge = value; }
}
}
}
数据访问类：
namespace ConsoleApplication1
{
public class PlayerDA
{
private SqlConnection _conn;
private SqlCommand _cmd;
private SqlDataReader _dr;
public PlayerDA()
{
_conn = DBConnect.Conn;
_cmd = _conn.CreateCommand();
}
//添加人员
public bool AddPlayer(string name_p, bool sex_p)
{
//初始属性
Player p = new Player();
int seed = (int)Convert.ToChar(name_p.Substring(, )) + (int)Convert.ToChar(name_p.Substring(, ));
Random rand = new Random(seed);
p.Lev = ;
p.Blood = + rand.Next();
p.Attack = + rand.Next();
p.Defense = + rand.Next();
p.Hit = + rand.Next();
p.Dodge = + rand.Next();
//添加
_cmd.CommandText = "insert into Player values(@name,@sex," + p.Lev + "," + p.Blood + "," + p.Attack + "," + p.Defense + "," + p.Hit + "," + p.Dodge+ ")";
_cmd.Parameters.Clear();
_cmd.Parameters.AddWithValue("@name", name_p);
_cmd.Parameters.AddWithValue("@sex", sex_p);
_conn.Open();
int add = _cmd.ExecuteNonQuery();
_conn.Close();
if (add > )
{
return true ;
}
else
{
return false;
}
}
//查询
public List<Player> Select(string name_p)
{
_cmd.CommandText = "select *from Player where Name=@name";
_cmd.Parameters.Clear();
_cmd.Parameters.AddWithValue("@name", name_p);
_conn.Open();
_dr = _cmd.ExecuteReader();
List<Player> list = new List<Player>();
if (_dr.HasRows)
{
while (_dr.Read())
{
Player data = new Player();
data.Name = _dr[].ToString();
data.Sex =Convert.ToBoolean(_dr[]);
data.Lev = Convert.ToInt32(_dr[]);
data.Blood = Convert.ToInt32(_dr[]);
data.Attack = Convert.ToInt32(_dr[]);
data.Defense = Convert.ToInt32(_dr[]);
data.Hit = Convert.ToInt32(_dr[]);
data.Dodge = Convert.ToInt32(_dr[]);
list.Add(data);
}
}
_conn.Close();
return list;
} //修改
public bool Update(string name)
{
List<Player> list = Select(name);
list[].Lev += ;
list[].Blood += ;
list[].Attack += ;
list[].Defense += ;
list[].Hit += ;
list[].Dodge += ;
_cmd.CommandText = "update Player set Lev=" + list[].Lev + ",Blood=" + list[].Blood + ",Attack=" + list[].Attack + ",Defense=" + list[].Defense + ",Hit=" + list[].Hit + ",Dodge=" + list[].Dodge + " where Name=@name";
_cmd.Parameters.Clear();
_cmd.Parameters.AddWithValue("@name", name);
_conn.Open();
int n = _cmd.ExecuteNonQuery();
_conn.Close();
if (n > )
{
return true;
}
else
{
return false;
}
}
}
}
添加人物：
namespace ConsoleApplication1
{
class program1
{
static void Main1(string[] args)
{
while (true)
{
Console.WriteLine("请输入姓名：");
string name = Console.ReadLine();
Console.WriteLine("请输入性别：");
bool sex = Console.ReadLine() == "男" ? true : false;
PlayerDA da = new PlayerDA();
if (da.AddPlayer(name, sex))
{
Console.WriteLine(name + "的属性信息为：");
List<Player> list = da.Select(name);
foreach (Player data in list)
{
string ssex = data.Sex ? "男" : "女";
Console.WriteLine("姓名：" + data.Name + "\t" + "性别：" + data.Sex + "\t" + "等级：" + data.Lev + "\t" + "血量：" + data.Blood + "\t" + "攻击：" + data.Attack + "\t" + "防御：" + data.Defense + "\t" + "命中：" + data.Hit + "\t" + "闪避：" + data.Dodge + "\t");
}
}
else
{
Console.WriteLine("添加人物失败！");
}
Console.WriteLine("是否继续添加人物？Y or N");
string yn = Console.ReadLine();
if (yn == "Y")
{
}
else
{
Console.WriteLine("输入完毕");
break;
}
}
Console.ReadLine();
}
}
}
对战：
namespace ConsoleApplication1
{
class program
{
//攻击函数
static Player gj(Player p_1, Player p_2)
{
Random rand = new Random();
Console.ForegroundColor = ConsoleColor.Gray;
Console.WriteLine(p_1.Name + "准备发起攻击... ...");
Console.ForegroundColor = ConsoleColor.Black; System.Threading.Thread.Sleep();
int h2 = rand.Next() + p_1.Hit;
int d1 = rand.Next() + p_2.Dodge;
if (h2 > )
{
if (d1 > )
{
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine(p_2.Name + "躲开了" + p_1.Name + "的攻击");
Console.ForegroundColor = ConsoleColor.Black;
}
else
{
int sh = rand.Next() + p_1.Attack;
p_2.Blood = p_2.Blood - sh + p_2.Defense;
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine(p_1.Name + "攻击掉" + p_2.Name + (sh - p_2.Defense) + "血");
Console.ForegroundColor = ConsoleColor.Black;
}
}
else
{
Console.ForegroundColor = ConsoleColor.DarkYellow;
Console.WriteLine(p_1.Name + "攻击失误");
Console.ForegroundColor = ConsoleColor.Black;
}
return (p_2);
}
static void Main(string[] args)
{
Console.BackgroundColor = ConsoleColor.White;
Console.ForegroundColor = ConsoleColor.Black; PlayerDA da = new PlayerDA();
Console.Write("请输入第一个玩家的姓名：");
string Name_1 = Console.ReadLine(); List<Player> p1 = da.Select(Name_1);
Console.WriteLine("*************************"); Console.Write("请输入第二个玩家的姓名：");
string Name_2 = Console.ReadLine(); List<Player> p2 = da.Select(Name_2);
Console.WriteLine("*************************"); //pk阶段
while (p1[].Blood > && p2[].Blood > )
{
Player pp2 = gj(p1[],p2[]);
p2[] = pp2;
Player pp1 = gj(p2[],p1[]);
p1[] = pp1;
Console.WriteLine(p2[].Name + ":"+(p2[].Blood<?:p2[].Blood)+"————————"+p1[].Name+":"+(p1[].Blood<?:p1[].Blood));
Console.WriteLine();
Console.WriteLine();
System.Threading.Thread.Sleep();
}
//pk结束
Console.WriteLine("**********战斗结束**********");
Console.WriteLine();
if (p1[].Blood <= && p2[].Blood > )
{
Console.WriteLine(p2[].Name + "赢了，恭喜升了一级！");
Console.WriteLine("属性提升为：");
if (da.Update(Name_2))
{
List<Player> list = da.Select(Name_2);
foreach (Player data in list)
{
string ssex = data.Sex ? "男" : "女";
Console.WriteLine("姓名：" + data.Name + "\t" + "性别：" + ssex + "\t" + "等级：" + data.Lev + "\t" + "血量：" + data.Blood + "\t" + "攻击：" + data.Attack + "\t" + "防御：" + data.Defense + "\t" + "命中：" + data.Hit + "\t" + "闪避：" + data.Dodge + "\t");
}
}
else
{
Console.WriteLine("错误！");
}
}
else if (p2[].Blood <= && p1[].Blood > )
{
Console.WriteLine(p1[].Name + "赢了，恭喜升了一级！");
Console.WriteLine("属性提升为：");
if (da.Update(Name_1))
{
List<Player> list = da.Select(Name_1);
foreach (Player data in list)
{
string ssex = data.Sex ? "男" : "女";
Console.WriteLine("姓名：" + data.Name + "\t" + "性别：" + ssex + "\t" + "等级：" + data.Lev + "\t" + "血量：" + data.Blood + "\t" + "攻击：" + data.Attack + "\t" + "防御：" + data.Defense + "\t" + "命中：" + data.Hit + "\t" + "闪避：" + data.Dodge + "\t");
}
}
else
{
Console.WriteLine("错误！");
}
}
else if (p1[].Blood<=&&p2[].Blood<=)
{
Console.WriteLine("同归于尽！");
}
Console.ReadLine();
}
}
}