Parameters用法

public bool InsertAdmin(string userName, string password, string remark, string mail, int departId, int power)
    {
        string sql = "insert into S_Admin(UserName,Password,Remark,Mail,DepartId,Power)values(:UserName,:Password,:Remark,:Mail,:DepartId,:Power)";
        OracleConnection connection = new OracleConnection();
        connection.ConnectionString = "";//此处设置链接字符串
        OracleCommand command = new OracleCommand(sql, connection);
        command.Parameters.Add("@UserName", OracleType.NVarChar, 60).Value = userName;
        command.Parameters.Add("@Password", OracleType.NVarChar, 60).Value =password;
        command.Parameters.Add("@Remark", OracleType.NVarChar, 60).Value = remark;
        command.Parameters.Add("@Mail", OracleType.NVarChar, 60).Value =mail;
        command.Parameters.Add("@DepartId", OracleType.Int32, 4).Value =departId;
        command.Parameters.Add("@Power", OracleType.Int32, 4).Value = power;
        connection.Open();
        int rowsAffected=command.ExecuteNonQuery();
        connection.Close();
        command.Dispose();
        return rowsAffected > 0;
    }
}