// シーン開始後に呼び出される void Start() { Debug.Log("「キャラクター詳細画面」に遷移した"); this.name = CharacterList.CharacterName; Debug.Log("name" + this.name); // キャラクターのデータを取得する ProcessingSQL countSQL = new ProcessingSQL(); DataTable dataTable = countSQL.SelectSQL(this.name); //変数の準備 var name = ""; int job = 0; int hp = 0; int mp = 0; int str = 0; int def = 0; int agi = 0; int luck = 0; string create_at = null; // DBのデータを変数に格納 foreach (DataRow dr in dataTable.Rows) { name = (string)dr["name"]; job = (int)dr["job"]; hp = (int)dr["hp"]; mp = (int)dr["mp"]; str = (int)dr["str"]; def = (int)dr["def"]; agi = (int)dr["agi"]; luck = (int)dr["luck"]; create_at = (string)dr["create_at"]; } // 名前の表示用 textName.text = name; //職業の表示用 if (job == 0) { textJob.text = "戦士"; } else if (job == 1) { textJob.text = "魔法使い"; } else if (job == 2) { textJob.text = "僧侶"; } else { textJob.text = "勇者"; } textStatus.text = string.Format("\n{0}\n{1}\n{2}\n{3}\n{4}\n{5}", hp, mp, str, def, agi, luck); }
// Start is called before the first frame update void Start() { // スクロールビューに表示するノードの数を調べる ProcessingSQL countSQL = new ProcessingSQL(); int count = countSQL.CountSQL(); // DB名を指定して接続 SqliteDatabase sqlDB = new SqliteDatabase("namebattler.db"); // 行数分のノードを作成する for (int i = 0; i < count; i++) { // ノードの自動作成 var character = GameObject.Instantiate(prefab) as RectTransform; character.SetParent(transform, false); // ノード内に表示するテキストを検索する DataTable dataTable = countSQL.SelectSQL(i); string name = ""; int job = 0; int hp = 0; int mp = 0; int str = 0; int def = 0; int agi = 0; int luck = 0; string create_at = null; foreach (DataRow dr in dataTable.Rows) { name = (string)dr["name"]; job = (int)dr["job"]; hp = (int)dr["hp"]; mp = (int)dr["mp"]; str = (int)dr["str"]; def = (int)dr["def"]; agi = (int)dr["agi"]; luck = (int)dr["luck"]; create_at = (string)dr["create_at"]; } texts = character.GetComponentsInChildren <Text>(); texts[0].text = name; if (job == 0) { texts[1].text = "戦士"; } else if (job == 1) { texts[1].text = "魔法使い"; } else if (job == 2) { texts[1].text = "僧侶"; } else { texts[1].text = "勇者"; } texts[2].text = $"HP: {hp} MP: {mp} STR: {str} DEF: {def} AGI: {agi}"; } }