public void OnClickedLoginButton()
{
if (string.IsNullOrEmpty(UserName.text))
{
ShowTip("请输入用户名");
return;
}
if (!string.IsNullOrEmpty(Password.text))
{
SqliteDataReader UsernameReader = sql.ReadTable("Game", new string[] { "UserName" }, new string[] { "`" + "UserName" + "`", "`" + "Password" + "`" }, new string[] { "=", "=" }, new string[] { ("'" + UserName.text.ToString() + "'").ToString(), ("'" + Password.text.ToString() + "'").ToString() });
if (UsernameReader.HasRows)
{
ShowTip("登陆成功！！！");
LoginPanel.SetActive(false);
RegisterPanel.SetActive(false);
//关闭数据库连接
sql.CloseConnection();
return;
}
else
{
ShowTip("登陆失败！！！");
return;
}
}
else
{
ShowTip("请输入密码！！！");
return;
}
//关闭数据库连接
sql.CloseConnection();
}
public void OnClickedRegisterButton()
{
if (string.IsNullOrEmpty(UserName.text))
{
ShowTip("请输入用户名");
return;
}
else
{
SqliteDataReader UsernameReader = sql.ReadTable("Game", new string[] { "UserName" }, new string[] { "`" + "UserName" + "`" }, new string[] { "=" }, new string[] { ("'" + UserName.text.ToString() + "'").ToString() });
if (UsernameReader.HasRows)
{
ShowTip("用户名已存在！！！");
return;
}
else
{
if (string.IsNullOrEmpty(Password.text))
{
ShowTip("请输入密码！！！");
return;
}
else
{
sql.InsertValues("Game", new string[] { ("'" + UserName.text.ToString() + "'").ToString(), ("'" + Password.text.ToString() + "'").ToString(), "6000000", "true", "true", "false", "false", "false", "false", "0" });
ShowTip("注册成功！！！");
}
}
}
//关闭数据库连接
sql.CloseConnection();
}
// Update is called once per frame
void Update()
{
transform.Translate(-speed * Time.deltaTime, 0, 0);
if (transform.position.x < -11)
{
Destroy(gameObject);
}
timer += Time.deltaTime;
if (timer >= updateTimer)
{
Vector3 position = transform.position;
//实例化子弹并设置初始位置
Instantiate(enemyBullet, new Vector3(position.x - 0.8f, position.y, position.z), Quaternion.identity);
timer = 0;
}
if (this.health <= 0) //敌机生命值小于0时
{
Destroy(gameObject); //飞机爆炸
Instantiate(boom, transform.position, Quaternion.identity); //显示敌机爆炸动画
StartGame.selfPlane.score += score; //得分增加
Sql = new SqliteHelper("data source=sqlite4unity.db"); //连接数据库
float Score = StartGame.selfPlane.score;
Sql.UpdateValues("Game", new string[] { "Score" }, new string[] { ("'" + Score.ToString() + "'").ToString() }, "UserName", "=", ("'" + Login.Name + "'").ToString()); //更新分数
Sql.CloseConnection(); //关闭数据库连接
}
}
public static void CreateDataBaseBySql()
{
string tempSqlPath = EditorUtility.OpenFilePanel("Load sql of Directory", Application.dataPath, "sql");
try
{
string tempSql = File.ReadAllText(tempSqlPath);
SqliteHelper tempHelper = new SqliteHelper(DbPath);
Debug.Log(tempSql);
tempHelper.ExecuteQuery(tempSql);
tempHelper.CloseConnection();
}
catch (System.Exception e)
{
Debug.LogError(e.Message);
}
}
//更新数据库
public void FreshData()
{
float Gold;
float Score;
SqliteDataReader GoldReader = Sql.ReadTable("Game", new string[] { "Gold" }, new string[] { "UserName" }, new string[] { "=" }, new string[] { ("'" + Login.Name + "'").ToString() });
SqliteDataReader ScoreReader = Sql.ReadTable("Game", new string[] { "Score" }, new string[] { "UserName" }, new string[] { "=" }, new string[] { ("'" + Login.Name + "'").ToString() });
Gold = float.Parse(GoldReader[0].ToString());
Score = float.Parse(ScoreReader[0].ToString());
Gold += Score;
Sql.UpdateValues("Game", new string[] { "Gold" }, new string[] { ("'" + Gold.ToString() + "'").ToString() }, "UserName", "=", ("'" + Login.Name + "'").ToString());
Sql.CloseConnection();
}
public void entryGame(GameObject sender)
{
Sql = new SqliteHelper("data source=sqlite4unity.db"); //连接数据库
Sql.UpdateValues("Game", new string[] { "Score" }, new string[] { ("'" + "0" + "'").ToString() }, "UserName", "=", ("'" + Login.Name + "'").ToString()); //将分数置0
Sql.CloseConnection(); //关闭数据库连接
describedText.text = "";
menu.SetActive(false);
modeUI.SetActive(false);
ChoosePlanes.SetActive(false);
SingleGame.SetActive(true);
UICamera.SetActive(true);
//myPlane.SetActive(true);
bgMusic.SetActive(true);
lifebarBG.SetActive(true);
//lifeBar.SetActive(true);
pausebtn.SetActive(true);
pauseUI.SetActive(false);
WinUI.SetActive(false);
DefeatUI.SetActive(false);
//刷新时间和生命值
GameObject.Find("SingleGame").GetComponent <GameManager>().lifeBar.fillAmount = 1f;
GameObject.Find("SingleGame").GetComponent <GameManager>().survivalTime = 0;
switch (sender.name)
{
case "ButtonEasy":
GameManager.successTime = 10f;
EnemyController.updateTimer = 1.5f; //飞机生成频率
EnemyPlane.updateTimer = 1.5f; //子弹更新频率
//GameManager.map = "bg1";
GameObject.Find("SingleGame").GetComponent <GameManager>().bgImage1.sprite = Resources.Load("bgImage/bg1", typeof(Sprite)) as Sprite;
GameObject.Find("SingleGame").GetComponent <GameManager>().bgImage2.sprite = Resources.Load("bgImage/bg1", typeof(Sprite)) as Sprite;
break;
case "ButtonUsual":
GameManager.successTime = 20f;
EnemyController.updateTimer = 1.0f; //飞机生成频率
EnemyPlane.updateTimer = 1.0f; //子弹更新频率
//GameManager.map = "bg2";
//加载地图
GameObject.Find("SingleGame").GetComponent <GameManager>().bgImage1.sprite = Resources.Load("bgImage/bg2", typeof(Sprite)) as Sprite;
GameObject.Find("SingleGame").GetComponent <GameManager>().bgImage2.sprite = Resources.Load("bgImage/bg2", typeof(Sprite)) as Sprite;
break;
case "ButtonHard":
GameManager.successTime = 30f;
EnemyController.updateTimer = 0.5f; //飞机生成频率
EnemyPlane.updateTimer = 0.5f; //子弹更新频率
//GameManager.map = "bg3";
GameObject.Find("SingleGame").GetComponent <GameManager>().bgImage1.sprite = Resources.Load("bgImage/bg3", typeof(Sprite)) as Sprite;
GameObject.Find("SingleGame").GetComponent <GameManager>().bgImage2.sprite = Resources.Load("bgImage/bg3", typeof(Sprite)) as Sprite;
break;
default:
break;
}
//transform.GetComponent<GameManager>().pauseMenu.SetActive(false);
Time.timeScale = 1f;
if (selfPlane == null)
{
if (SelectPlane.IsdefaultplaneChosen == true)
{
selfPlane = Instantiate(Plane[0], new Vector3(-8f, 0f, 0f), Quaternion.identity);
}
else if (SelectPlane.IsheliChosen == true)
{
selfPlane = Instantiate(Plane[1], new Vector3(-8f, 0f, 0f), Quaternion.identity);
}
else
{
selfPlane = Instantiate(Plane[2], new Vector3(-8f, 0f, 0f), Quaternion.identity);
}
}
}
private void ChildPage_Unloaded(object sender, RoutedEventArgs e)
{
sqlite.CloseConnection();
}
