mysql插入自动增长id,MySQL插入数据获得自动增长的ID

INSERT INTO data(name) Values(@name); SELECT @@Identity

///

/// 插入一个用户返回自动增长的id

///

///

///

public int Add(UserInfo userInfo)

{

//string sql = "insert into " + JDBCConst.UserInfoDB + " value(NULL,@cardId,@username,@password,@role)";

// 插入一个用户返回自动增长的id

string sql = "insert into " + JDBCConst.UserInfoDB + " value(NULL,@cardId,@username,@password,@role,null);SELECT @@Identity";

MySqlParameter parCardId = new MySqlParameter("@CardId", userInfo.card_id);

MySqlParameter parUsername = new MySqlParameter("@username", userInfo.username);

MySqlParameter parPassword = new MySqlParameter("@password", userInfo.password);

MySqlParameter parRole = new MySqlParameter("@role", userInfo.role);

object i;

try

{

i = Utils.ExecuteScalar(sql,parCardId,parUsername,parPassword,parRole);

}

catch (Exception)

{

throw;

}

int k = Convert.ToInt32(i);

return k;

}

标签：username,MySqlParameter,插入,role,userInfo,MySQL,new,password,ID

来源： https://www.cnblogs.com/prodigal-son/p/14206350.html