使用测试
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Xml.Linq;
using UnityEngine;
public class TTTT : MonoBehaviour
{
// Start is called before the first frame update
void Start()
{
//IDictionary<string, ElementModels> elementModelsDic = ElementService.GetAllElementModels();
//foreach (var item in elementModelsDic)
//{
// Debug.Log(item.Key + "-----------" + item.Value.ElementType);
//}
// UpdateExamResults("88", "wxg", "2023/4/5 19:31:19");
SearchData();
// string sql = "update StuTable set Name ='jwhh'where id = '5'";
// SQLHelper.UpdateDataSQL(sql);
ss();
}
public void SearchData()
{
string sql = "SELECT Name, id FROM StuTable";
Debug.Log(sql);
try
{
// DataTable dt = SQLHelper.GetDataSetSQL(sql).Tables[0];
DataTable dt = SQLHelper.GetDataSetSQL(sql).Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
Debug.Log(dt.Rows.Count);
for (int i = 0; i < dt.Rows.Count; i++)
{
Debug.Log(dt.Rows[i]["Name"]);
Debug.Log(dt.Rows[i]["id"]);
}
}
}
catch (Exception ex)
{
throw;
}
}
public void ss()
{
try
{
string strSql = string.Format("spUpdateUser");
int a = 0;
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@Name", "ZSHH"),
new SqlParameter("@id", a)
};
SQLHelper.ExecuteCommand(strSql,para);
}
catch (System.Exception)
{
throw;
}
}
void UpdateExamResults(string grade,string name,string time)
{
//插入
//INSERT INTO ExamResults VALUES('','','','');
//INSERT INTO ExamResults(Name,Grade) VALUES('',&