如上图所示的数据库,共有7个字段,字段mac_id、字段id、字段res_id、字段res_name为字符型串字段;
字段timing、字段noack_time、字段sleep_mode为int型字段。
要求:
数据库中查询满足条件mac_id="FC-12-5A-6B-7C"的记录,并取出满足条件记录的id字段、res_id字段、timing字段的数值。
string mac_name = "FC-12-5A-6B-7C";
string conStr = "server=localhost;port=3306;user Id=root;password=12345; database=sg ;Allow User Variables=True"; //连接字符串
MySqlConnection conn = new MySqlConnection(conStr);
conn.Open();
string sql = "select * from table1 where mac_id = '" + mac_name + "'";
MySqlCommand Cmd = new MySqlCommand(sql, conn);
MySqlDataReader db = Cmd.ExecuteReader();
if (db.Read())
{
string v_id = db["id"].ToString();
string v_res_id = db["res_id"].ToString();
int v_timing = Convert.ToInt32(db["timing"]);
conn.Close();
}
运行结果:
v_id = "AX"
v_res_id = "BY"
v_timing = 10